📄 book.php
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>预订结果</title>
</head>
<body>
<?php
function cdata($in,$in2)
{
return (strtotime($in)-strtotime($in2))/86400;
}
mysql_connect("222.20.57.135","root","");
$book_result="";
$result_roomno=mysql_db_query("bs","select roomno from room");
while($row_roomno=mysql_fetch_array($result_roomno))
{
if(!($$row_roomno["roomno"]=="on"))continue;
$result_state=mysql_db_query("bs","select state from room where roomno='".$row_roomno["roomno"]."'");
$row_state=mysql_fetch_array($result_state);
if($row_state==2)
{
$book_result.=$row_roomno["roomno"]."房间待修理!<br>";
break;
}
$result_bookno=mysql_db_query("bs","select bookno from bookroom where roomno='".$row_roomno["roomno"]."'");
while($row_bookno=mysql_fetch_array($result_bookno))
{
$sqlstr="select indate,date_add(indate,interval daynum day) dateadd from bookrecord where bookno='".$row_bookno["bookno"]."'";
$result_book=mysql_db_query("bs",$sqlstr);
$row_book=mysql_fetch_array($result_book);
$year_old_sml=strtok($row_book["indate"],"-");
$mon_old_sml=strtok("-");
$day_old_sml=strtok("-");
$year_old_big=strtok($row_book["dateadd"],"-");
$mon_old_big=strtok("-");
$day_old_big=strtok("-");
$year_new_sml=strtok($from,"-");
$mon_new_sml=strtok("-");
$day_new_sml=strtok("-");
$year_new_big=strtok($to,"-");
$mon_new_big=strtok("-");
$day_new_big=strtok("-");
if(($year_old_sml<$year_new_big||($year_old_sml==$year_new_big&&$mon_old_sml<$mon_new_big)||($year_old_sml==$year_new_big&&$mon_old_sml==$mon_new_big&&$day_old_sml<=$day_new_big))&&($year_new_sml<$year_old_big||($year_new_sml==$year_old_big&&$mon_new_sml<$mon_old_big)||($year_new_sml==$year_old_big&&$mon_new_sml==$mon_old_big&&$day_new_sml<=$day_old_big)))
$book_result.=$row_roomno["roomno"]."房间与别人的预订时间冲突!<br>";
mysql_free_result($result_book);
}
mysql_free_result($result_bookno);
$result_regno=mysql_db_query("bs","select regno from regroom where roomno='".$row_roomno["roomno"]."'");
while($row_regno=mysql_fetch_array($result_regno))
{
$sqlstr="select indate,date_add(indate,interval predaynum day) dateadd from regrecord where regno='".$row_regno["regno"]."'";
$result_reg=mysql_db_query("bs",$sqlstr);
$row_reg=mysql_fetch_array($result_reg);
$year_old_sml=strtok($row_reg["indate"],"-");
$mon_old_sml=strtok("-");
$day_old_sml=strtok("-");
$year_old_big=strtok($row_reg["dateadd"],"-");
$mon_old_big=strtok("-");
$day_old_big=strtok("-");
$year_new_sml=strtok($from,"-");
$mon_new_sml=strtok("-");
$day_new_sml=strtok("-");
$year_new_big=strtok($to,"-");
$mon_new_big=strtok("-");
$day_new_big=strtok("-");
if(($year_old_sml<$year_new_big||($year_old_sml==$year_new_big&&$mon_old_sml<$mon_new_big)||($year_old_sml==$year_new_big&&$mon_old_sml==$mon_new_big&&$day_old_sml<=$day_new_big))&&($year_new_sml<$year_old_big||($year_new_sml==$year_old_big&&$mon_new_sml<$mon_old_big)||($year_new_sml==$year_old_big&&$mon_new_sml==$mon_old_big&&$day_new_sml<=$day_old_big)))
$book_result.=$row_roomno["roomno"]."房间与别人已登记的入住时间冲突!<br>";
mysql_free_result($result_reg);
}
mysql_free_result($result_regno);
}
mysql_free_result($result_roomno);
$result=mysql_db_query("bs","select bookLimit from config");
$row=mysql_fetch_array($result);
if($book_result=="")
{ while(1){
$booknores=mysql_db_query("bs","select num from config");
$bookrow=mysql_fetch_array($booknores);
$bookno=date(y).date(m).date(d).sprintf("%03d",$bookrow["num"]);
mysql_db_query("bs","update config set num=mod(num+1,1000)");
$checkconf=mysql_db_query("bs","select * from bookrecord where bookno='".$bookno."'");
if(!mysql_fetch_array($checkconf))break;
}
mysql_free_result($booknores);
mysql_free_result($checkconf);
mysql_db_query("bs","insert into bookrecord values('".$bookno."','".$idcard."','".$name."',".$guestnum.",'".$from."',".cdata(str_replace("-","",$to),str_replace("-","",$from)).",now())");
if(mysql_errno()){echo "MySQL error!请确保您填写的资料格式正确!<br>".mysql_errno().": ".mysql_error()."<BR>";exit();}
$result_roomno=mysql_db_query("bs","select roomno from room");
while($row_roomno=mysql_fetch_array($result_roomno))
{
if(!($$row_roomno["roomno"]=="on"))continue;
mysql_db_query("bs","insert into bookroom values('".$bookno."','".$row_roomno["roomno"]."')");
if(mysql_errno()){echo "MySQL error!请确保您填写的资料格式正确!<br>".mysql_errno().": ".mysql_error()."<BR>";exit();}
mysql_db_query("bs","update room set state=3 where roomno='".$row_roomno["roomno"]."' and state=1");
if(mysql_errno()){echo "MySQL error!请确保您填写的资料格式正确!<br>".mysql_errno().": ".mysql_error()."<BR>";exit();}
}
mysql_free_result($result_roomno);
echo "预订成功！预订号为：".$bookno."(请记注此号码!)<br>请于".$row["bookLimit"]."小时内到本旅馆办理入住登记手续，否则预定被自动撤销!";
}
else echo "预订失败！原因如下:<br>";
mysql_free_result($result);
echo $book_result;
?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -