header("Cache-Control: no-store, no-cache, must-revalidate"); // HTTP/1.1 header("Pragma: no-cache"); // HTTP/1.0 ?> include("include/db.inc.php"); ?> include("include/vars_xrd.php"); ?> if ($cancel && $reserved && !$signin) { $result = mysql_query("update xrd set reserved_by='', cancelled_by='" . $login_user . "' where reserved_by='" . $login_user . "' and end_time>'" . $cur_time . "' and signin_time='0000-00-00 00:00:00'"); if (!$result) { echo mysql_error(); exit; } } ?> if ($signin && !$signined) { $result = mysql_query("update xrd set signin_time='" . $cur_time . "' where reserved_by='" . $login_user . "' and start_time<'" . $cur_time . "' and end_time>'" . $cur_time . "'"); if (!$result) { echo mysql_error(); exit; } } ?> include("include/vars_xrd.php"); ?> include("include/header.php"); ?> echo "
Date | \n"; echo "Time | \n"; echo "Reserved by | \n"; echo "Signin time | \n"; echo "Last Cancelled by | \n"; echo "Remark | \n"; $result = mysql_query("select * from xrd where reserved_by<>'root' order by start_time"); while ($data = mysql_fetch_array($result)) { $start_time=$data['start_time']; $end_time=$data['end_time']; $reserved_by=$data['reserved_by']; $action=$data['action']; $signin_time=$data['signin_time']; $cancelled_by=$data['cancelled_by']; $remark=$data['remark']; $session_date=substr($start_time,0,10); if (substr($start_time,11,5)=="09:30") $session_time="S1 "; else if (substr($start_time,11,5)=="14:00") $session_time="S2 "; else $session_time="S3 "; $session_time=$session_time . substr($start_time,-8) . "-" . substr($end_time,-8); if ($end_time>$cur_time) if ($start_time>$cur_time) $fcol="#000000"; else $fcol="#0080FF"; else $fcol="#FF0000"; echo "||||
$session_date | \n"; echo "$session_time | \n"; if ($reserved_by=="") echo "-------- | \n"; else echo "$reserved_by | \n"; if ($signin_time=="0000-00-00 00:00:00") echo "-------- | \n"; else echo "$signin_time | \n"; if ($cancelled_by=="--------") echo "$cancelled_by | \n"; else echo "$cancelled_by | \n"; if ($remark=="") echo "-------- | \n"; else echo "$remark | \n"; } mysql_free_result($result); ?>