left_other_close.php

来自「程序脚本为PHP+MYSQL」· PHP 代码 · 共 24 行

<?php 
$sqlop=mysql_query("select * from ptime where now_sign='1'",$conn);
$other_closes=mysql_result($sqlop,0,"other_close_time");   //znum
$sqlcs=mysql_query("select * from ptime where sign='4'",$conn);
$hand=mysql_result($sqlcs,0,"hand");
if($hand==1) echo "<script language='javascript'>window.location='left_state.php'</script>";
$ltime=split(" ",$other_closes);
$ymd=split("-",$ltime[0]);
$hms=split(":",$ltime[1]);
$limit_times=mktime($hms[0],$hms[1],$hms[2],$ymd[1],$ymd[2],$ymd[0]);  //éè?¨ê±??
$limit_time=$limit_times-time();
if($limit_time<=0)
{
mysql_query("update ptime set now_state='1' where dates='$dates'",$conn);
mysql_query("update ptime set other='1' where sign='4'",$conn); //znum close
}
$sqlcs=mysql_query("select * from ptime where sign='4'",$conn);
$all_close=mysql_result($sqlcs,0,"opstate");
$tnum_close=mysql_result($sqlcs,0,"tnum");
$other_close=mysql_result($sqlcs,0,"other");
if($all_close==1) echo "<script language='javascript'>window.location='left_state.php'</script>";
if($other_close==1) echo "<script language='javascript'>window.location='left_state.php'</script>";
?>