<?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_act_id = $_REQUEST['tb_act_id'];
$tb_act_code = $_REQUEST['tb_act_code'];
$tb_act_name = $_REQUEST['tb_act_name'];
$tb_act_object = $_REQUEST['tb_act_object'];
$tb_act_detail = $_REQUEST['tb_act_detail'];
$tb_act_num = $_REQUEST['tb_act_num'];
$tb_act_room = $_REQUEST['tb_act_room'];
$tb_act_class = $_REQUEST['tb_act_class'];
$tb_act_year = $_REQUEST['tb_act_year'];
$tb_teacher_id = $_REQUEST['tb_teacher_id'];
$tb_act_comment = $_REQUEST['tb_act_comment'];

if($action=='save'){
	$query_int = $db->query("INSERT INTO  tb_acts (tb_act_code, tb_act_name,tb_act_object, tb_act_detail, tb_act_num, tb_act_room, tb_act_year, tb_act_status, tb_teacher_id, tb_act_comment,tb_act_class) VALUES ('".$tb_act_code."', '".$tb_act_name."','".$tb_act_object."', '".$tb_act_detail."', '".$tb_act_num."', '".$tb_act_room."', '".$tb_act_year."', '1', '".$tb_teacher_id."' ,'".$tb_act_comment."','".$tb_act_class."');");
	print "
	<script language='javascript'>
		window.location.href='display_act.php';
	</script>
	";
}else{
	$query_up = $db->query("UPDATE  tb_acts 
	SET
	tb_act_name = '".$tb_act_name."' , 
	tb_act_object = '".$tb_act_object."' , 
	tb_act_detail = '".$tb_act_detail."' , 
	tb_act_num = '".$tb_act_num."' , 
	tb_act_room = '".$tb_act_room."' , 
	tb_act_year = '".$tb_act_year."' , 
	tb_teacher_id = '".$tb_teacher_id."',
	tb_act_class = '".$tb_act_class."',
	tb_act_comment='".$tb_act_comment."' 
 where tb_act_id='".$tb_act_id."' ");
	print "
	<script language='javascript'>
		window.location.href='display_act.php';
	</script>
	";
}
?>