other_close.php

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

<?php 
/*
????:????????????,??????????????,??????????????,
????????????,???????????????????????????!
????!
????????,???????????????!
*/
$sqlcs=mysql_query("select * from ptime where sign='4'",$conn);
$all_close=mysql_result($sqlcs,0,"opstate");
$other_close=mysql_result($sqlcs,0,"other");
$hand=mysql_result($sqlcs,0,"hand");
if($hand==1) echo "<script language='javascript'>window.location='close_plate.php'</script>";
$sqlop=mysql_query("select * from ptime where now_sign='1'",$conn);
$open_time=mysql_result($sqlop,0,"open_time");   //tnum
$other_closes=mysql_result($sqlop,0,"other_close_time");   //znum
$oltime=split(" ",$open_time);//open
$oymd=split("-",$oltime[0]);
$ohms=split(":",$oltime[1]);
$olimit_times=mktime($ohms[0],$ohms[1],$ohms[2],$oymd[1],$oymd[2],$oymd[0]);  //设定时间
$olimit_time=$olimit_times-time();
if($olimit_time>=0)
{
 mysql_query("update ptime set opstate='1',tnum='1',other='1' where sign='4'",$conn);
 echo "<script language='javascript'>window.location='close_plate.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
}
if($all_close==1)
{
 //mysql_query("update now_open set num1='',num2='',num3='',num4='',num5='',num6='',num7='' where ID='1'",$conn);
 echo "<script language='javascript'>window.location='close_plate.php'</script>";
 }
if($other_close==1) echo "<script language='javascript'>window.location='close_plate.php'</script>";
$sqlps=mysql_query("select * from online where user_account='$user' and vmsg='1'",$conn);
?>