<?php
session_start();
$path = "../";
include ($path.'include/config_db.php');
include ($path.'include/class_db.php'); 
include ($path.'include/class_display.php'); 
include ($path.'include/class_application.php'); 

$CLASS['db']   = new db();
$CLASS['db']->connect (); 
$CLASS['disp']   = new display();
$db   = $CLASS['db']; 
$disp   = $CLASS['disp']; 
$date_day = date("Y-m-d").' '.date("H:i:s");  

$tb_act_id = $_REQUEST['tb_act_id'];
$tb_student_id = $_REQUEST['tb_student_id'];
$tb_student_number = $_REQUEST['tb_student_number'];

$fetch_num_regis = $db->fetch_array($db->query("SELECT COUNT(tb_act_id) AS num_regis FROM tb_registers WHERE tb_act_id ='".$tb_act_id."' "));
$fetch_num_all = $db->fetch_array($db->query("select tb_act_num,tb_act_id from tb_acts WHERE tb_act_id ='".$tb_act_id."'"));
										
if($fetch_num_all['tb_act_num'] == $fetch_num_regis['num_regis']){
	print "
	<script language='javascript'>
		alert('Num Of Full');
		window.location.href='display_act.php';
	</script>
	";
}else{
		$query_delete1 = $db->query("DELETE FROM tb_registers WHERE  tb_student_id='' ");
		$query_delete = $db->query("DELETE FROM tb_registers WHERE  tb_student_id='".$tb_student_id."'");
		$query_insert = $db->query("INSERT INTO tb_registers (tb_register_id, tb_act_id, tb_student_id, tb_register_date, tb_student_number) VALUES (NULL,
        '".$tb_act_id."',
        '".$tb_student_id."',
		'".$date_day."',
        '".$tb_student_number."')");
	
	print "
	<script language='javascript'>
		alert('OK SUCESS');
		window.location.href='display_regis_view.php?tb_student_id=$tb_student_id';
	</script>
	";
}
?>