<?php
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">";
@session_start();
$path = "../";
include ($path.'include/config_db.php');
include ($path.'include/class_db.php'); 
include ($path.'include/class_display.php'); 
include ($path.'include/function.php'); 
include ($path.'include/permission_denied.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_knowledge_id = $_REQUEST['tb_knowledge_id'];
$tb_register_knowledge_order = $_REQUEST['tb_register_knowledge_order'];
$array_know = explode("/",$tb_knowledge_id);

$tb_knowledge_id_int = $array_know[0];
$tb_knowledge_4h_int = $array_know[1];

$tb_student_id = $_REQUEST['tb_student_id'];
$tb_student_code = $_REQUEST['tb_student_code'];

$fetch_num_regis = $db->fetch_array($db->query("SELECT COUNT(tb_knowledge_id) AS num_regis FROM tb_registers_knowledge WHERE tb_knowledge_id ='".$tb_knowledge_id_int."' "));
$fetch_num_all = $db->fetch_array($db->query("select tb_knowledge_num,tb_knowledge_id from tb_knowledges WHERE tb_knowledge_id ='".$tb_knowledge_id_int."'"));

if($fetch_num_all['tb_knowledge_num'] == $fetch_num_regis['num_regis']){
	print "
	<script language='javascript'>
		alert('จำนวนผู้ลงทะเบียนครบแล้ว กรุณาเลือกชุมนุมใหม่');
		window.location.href='display_regis_knowledge.php';
	</script>
	";
}else{
 
	$query_delete1 = $db->query("DELETE FROM tb_registers_knowledge WHERE  tb_student_id='' ");
	$query_delete = $db->query("DELETE FROM tb_registers_knowledge WHERE tb_student_id='".$tb_student_id."'");
	$query_up = $db->query("INSERT INTO  tb_registers_knowledge
            (tb_register_knowledge_id,
             tb_knowledge_id,
             tb_knowledge_4h,
             tb_student_id,
             tb_student_number,
             tb_register_knowledge_date,
             tb_register_knowledge_type,
			 tb_register_knowledge_order)
VALUES (NULL,
        '".$tb_knowledge_id_int."',
        '".$tb_knowledge_4h_int."',
        '".$tb_student_id."',
        '".$tb_student_code."',
        '".$date_day."',
        '0',
		'".$tb_register_knowledge_order."')");
		
			print "
	<script language='javascript'>
		alert('Register Ok');
		window.location.href='display_regis_knowledge.php';
	</script>
	";
}
?>