<?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/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");  

$action = $_REQUEST['action'];
$tb_course_id = $_REQUEST['tb_course_id'];
$tb_course_code = $_REQUEST['tb_course_code'];
$tb_course_name = $_REQUEST['tb_course_name'];
$tb_teacher_id = $_REQUEST['tb_teacher_id'];
$tb_course_class = $_REQUEST['tb_course_class'];
$tb_course_num = $_REQUEST['tb_course_num'];
$tb_course_group = $_REQUEST['tb_course_group'];
$tb_course_comment = $_REQUEST['tb_course_comment'];
$tb_course_day = $_REQUEST['tb_course_day'];
$tb_course_area = $_REQUEST['tb_course_area'];
$tb_course_time = $_REQUEST['tb_course_time'];
$course_class = $_REQUEST['course_class'];

if($action=='save'){
	$query_int = $db->query("INSERT INTO  tb_courses (tb_course_id, tb_course_code, tb_course_name, tb_teacher_id,tb_course_class,tb_course_num,tb_course_group, tb_course_comment ,tb_course_day,tb_course_area,tb_course_time ) VALUES (NULL, '".$tb_course_code."', '".$tb_course_name."', '".$tb_teacher_id."' ,'".$tb_course_class."', '".$tb_course_num."', '".$tb_course_group."', '".$tb_course_comment."', '".$tb_course_day."', '".$tb_course_area."','".$tb_course_time."');");
	print "
	<script language='javascript'>
		window.location.href='display_course.php?course_class=$course_class';
	</script>
	";
}else{
	$query_up = $db->query("UPDATE  tb_courses 
	SET
	tb_course_code = '".$tb_course_code."' , 
	tb_course_name = '".$tb_course_name."' , 
	tb_teacher_id = '".$tb_teacher_id."',
	tb_course_class = '".$tb_course_class."',
	tb_course_num = '".$tb_course_num."',
	tb_course_group = '".$tb_course_group."',
	tb_course_day = '".$tb_course_day."',
	tb_course_comment = '".$tb_course_comment."',
	tb_course_time = '".$tb_course_time."',
	tb_course_area='".$tb_course_area."' 
 where tb_course_id='".$tb_course_id."' ");
	print "
	<script language='javascript'>
		window.location.href='display_course.php?course_class=$course_class';
	</script>
	";
}
?>