<?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_knowledge_id = $_REQUEST['tb_knowledge_id'];

$tb_knowledge_4h = $_REQUEST['tb_knowledge_4h'];
$tb_student_id = $_REQUEST['tb_student_id'];
$tb_student_number = $_REQUEST['tb_student_number'];
$tb_register_knowledge_order = $_REQUEST['tb_register_knowledge_order'];

$fetch_knowledgesetup = $db->fetch_array($db->query("select * from tb_knowledge_setup"));

$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."' and tb_register_knowledge_order='".$fetch_knowledgesetup['tb_knowledge_setup_order']."'"));
$fetch_num_all = $db->fetch_array($db->query("select * from tb_knowledges WHERE tb_knowledge_id ='".$tb_knowledge_id."'"));


if($fetch_num_all['tb_knowledge_num']==$fetch_num_regis['num_regis']){
	print "
	<script language='javascript'>
		alert('Num Of Full');
		window.location.href='display_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_knowledge_id='".$tb_knowledge_id."' AND tb_student_id='".$tb_student_id."'");
		$query_insert = $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."',
        '".$tb_knowledge_4h."',
        '".$tb_student_id."',
        '".$tb_student_number."',
        '".$date_day."',
        '0',
		'".$tb_register_knowledge_order."')");
	
	print "
	<script language='javascript'>
		window.location.href='display_regis_view.php?tb_student_id=$tb_student_id';
	</script>
	";
}
?>