📄 booked.php

📁 酒店管理系统
💻 PHP
字号:
<? 
require_once('include/connection.php'); 
include('include/admin_or_user.php');
require_once('include/sqlfuns.php');

 
if(isset($_POST['s1']))
{ 
 if(isset($_POST['rows']))
  $rows=$_POST['rows'];
  $room_number="";
  for($i=1;$i<=$rows;$i++)
   { 
    if(isset($_POST['checkbox'.$i]))
	{ $updatesql="update room set room_state=0 where room_number='".$_POST['checkbox'.$i]."'";
	  odbc_exec($conn,$updatesql);
	$room_number.=$_POST['checkbox'.$i]."@";
	}
  }
$insertsql = sprintf("INSERT INTO book (name,booktime ,bookdays, room_number,longintime,person,phone) VALUES(%s, %s, %s,%s, %s, %s,%s)",
	                   GetSQLValueString($_POST['name'], "text"),
                       GetSQLValueString($_POST['book_time'], "text"),
                       GetSQLValueString($_POST['book_days'], "double"),
					    GetSQLValueString($room_number, "text"),
						 GetSQLValueString($_POST['selectmonth']."-".$_POST['selectday'], "text"),
						  GetSQLValueString($_POST['person'], "int"),
						  GetSQLValueString($_POST['phone'], "text"));

	$result=odbc_exec($conn,$insertsql);
	$insertsql = sprintf("INSERT INTO bookbak (name,booktime ,bookdays, room_number,longintime,person,phone) VALUES(%s, %s, %s,%s, %s, %s,%s)",
	                   GetSQLValueString($_POST['name'], "text"),
                       GetSQLValueString($_POST['book_time'], "text"),
                       GetSQLValueString($_POST['book_days'], "int"),
					    GetSQLValueString($room_number, "text"),
						 GetSQLValueString($_POST['selectmonth']."-".$_POST['selectday'], "text"),
						  GetSQLValueString($_POST['person'], "int"),
						  GetSQLValueString($_POST['phone'], "text"));

	$result=odbc_exec($conn,$insertsql);
	if($result)
	echo "<script> window.open('user.php', target='_top');alert('操作成功');
	             
	  </script>";
	else 
	echo "<script>window.open('user.php', target='_top'); alert('操作失败');</script>";
	

 }
 
  ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>

<body>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -