📄 modefiy_roomin.php

📁 酒店管理系统

💻 PHP

字号:

<? 
 require_once('include/connection.php'); 
 include('include/admin_or_user.php');
 require_once('include/sqlfuns.php');
 ?>
 <?
 $sql="select count(id) as a from book where room_number like '%".$_POST['old_roomnumber']."%'";
   $rs=odbc_exec($conn,$sql);
   if(odbc_result($rs,'a')<1)
     $sql3="update room set room_state=-1 where room_number='".$_POST['old_roomnumber']."'";
	   else 
	    $sql3="update room set room_state=0 where room_number='".$_POST['old_roomnumber']."'";
   
odbc_exec($conn,$sql3);
 
 $sql = sprintf("update coustom set days=%s, room_number=%s,dieing_prise=%s,person=%s,other_prise=%s,paiedmoney=%s  where room_number=%s",
	                  
                       GetSQLValueString($_POST['days'], "int"),
					    GetSQLValueString($_POST['room_number'], "text"),
						 GetSQLValueString($_POST['dieing_prise'], "int"),
						  GetSQLValueString($_POST['person'], "int"),
						  GetSQLValueString($_POST['other_prise'], "int"),
						  GetSQLValueString($_POST['paied_money'], "int"),
						  GetSQLValueString($_POST['old_roomnumber'], "text"));

	odbc_exec($conn,$sql);
	$sql3="update room set room_state=1 where room_number='".$_POST['room_number']."'";
    odbc_exec($conn,$sql3);
echo "<script> alert('操作成功');location='roomined.php';</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 + -