<?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']; 

$checkid = $_REQUEST['checkid'];
$tb_volunteer_status = $_REQUEST['tb_volunteer_status'];
$tb_student_id = $_REQUEST['tb_student_id'];
$count_rows = $_REQUEST['count_rows'];
$tb_student_degree = $_REQUEST['tb_student_degree'];

	for($r=0;$r<$count_rows;$r++){
		$checkid_i = $checkid[$r];
		$tb_volunteer_status_i = $tb_volunteer_status[$r];
		$tb_student_id_i = $tb_student_id[$r];
		
	$delete_add = $db->query("DELETE FROM tb_volunteer WHERE tb_student_id = '".$tb_student_id_i."' ");
	
	$insert_time = $db->query("INSERT INTO  tb_volunteer (tb_student_id, tb_student_degree, tb_teacher_id , tb_volunteer_status, tb_volunteer_date)VALUES('".$tb_student_id_i."','".$tb_student_degree."','".$_SESSION['sessiontuser_id']."', '".$tb_volunteer_status_i."','".$date_day."')");
	//	$insert_time = $db->query("UPDATE tb_volunteer SET  tb_volunteer_status = '".$tb_volunteer_status_i."' WHERE tb_student_id = '".$tb_student_id_i."' ");
		
	}
	
	print "
	<script language='javascript'>
		alert('Success !!!');
		window.location.href='report_vol_allroomcheck.php?tb_student_degree=$tb_student_degree';
	</script>
	";
?>