📄 modefiyroom.php

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

require_once('../include/sqlfuns.php');
if(isset($_POST['s'])&&$_POST['s']=="修改")
{
if($_POST['room_number']!=$_POST['rnumber'])
if(findindb($conn,"room_number","room",$_POST['room_number'],"text"))
{ ?>
<script>
alert("房间号已在数据库中！");
window.history.back();
</script>
<? exit; 
}


$updatesql = sprintf("update room set room_number=%s, room_level=%s ,room_person=%s where room_number=%s",  
                       GetSQLValueString($_POST['room_number'], "text"),
                       GetSQLValueString($_POST['room_level'], "int"),
					   GetSQLValueString($_POST['room_person'], "int"),
					   GetSQLValueString($_POST['rnumber'], "text"));
if(isset($_GET['add'])&&$_GET['add']==1) 
  {
$updatesql1 = sprintf("update roomlevel set room_level=%s ,room_prise=%s, room_introduction=%s where room_level=%s",
                       GetSQLValueString($_POST['room_level'], "int"),
                       GetSQLValueString($_POST['room_prise'], "int"),
                       GetSQLValueString($_POST['room_introduction'], "text"),
					   GetSQLValueString($_POST['rlevel'], "int"));
odbc_exec($conn,$updatesql1);
}			   
 $result=odbc_exec($conn,$updatesql);
 odbc_close($conn);
 if($result)
 { echo "<p>&nbsp;</p>";
  echo "<p align=center>增加成功</p>";
  }
  else 
    {echo "<p>&nbsp;</p>";
      echo "<p align=center>操作失败</p>";
	 } 
 exit;
 }
 
$selectroom="select room.room_number,room.room_person,roomlevel.room_level,roomlevel.room_prise,roomlevel.room_introduction from roomlevel,room where roomlevel.room_level=room.room_level AND room_number='".base64_decode($_GET['room_number']) ."'";
$room=odbc_exec($conn,$selectroom);

$selectsql="select room_level from roomlevel order by room_level";
$selectresult=odbc_exec($conn,$selectsql);
?>

<!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>
<link href="../css/hotel.css" rel="stylesheet" type="text/css" />
</head>
<? require('../include/check.inc');?>
<body>
<form id="form1" name="form1" method="post" action=""  onSubmit="return (empty(room_level)&&empty(room_number)&&numbercheck(room_level)<? if(isset($_GET['add'])&&$_GET['add']==1) { ?>&&maxlevel(room_level)<? }?>)">
  <table width="100%" border="1">
  <tr>
  <td>
  <table width="62%" border="0" align="left">
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>修改房间</td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td><div align="right">房间号码：</div></td>
      <td><label>
        <input name="room_number" type="text" id="room_number" value="<? echo odbc_result($room,'room_number');?>" size="13" maxlength="15" />
     &nbsp; * </label></td>
    </tr>
	<tr>
      <td><div align="right">可入住人数：</div></td>
      <td><label>
        <input name="room_person" type="text" id="room_number" value="<? echo odbc_result($room,'room_person');?>" size="6" maxlength="6" />
     &nbsp; * </label></td>
    </tr>
    <tr>
      <td><div align="right">房间星级：</div></td>
      <? if(isset($_GET['add'])&&$_GET['add']==1) { ?>
      <td><label>
        <input name="room_level" type="text" id="room_level" size="4" maxlength="10" />
        *
      (现有星级房间：<? if(!odbc_fetch_row($selectresult,"1")) echo "暂无记录!"; 
	  do{
	  echo odbc_result($selectresult,'room_level');echo "&nbsp;&nbsp;"; 
	    }while(odbc_fetch_row($selectresult)); ?>)</label></td>
		
		
      <? } else {?>
      <td><label>
        <select name="room_level" id="room_level">
          <option value="">请选择</option>
		  <? while(odbc_fetch_row($selectresult)){ ?>
          <option value="<? echo odbc_result($selectresult,'room_level');?>" <? if(odbc_result($selectresult,'room_level')==odbc_result($room,'room_level')) { ?>selected="selected" <? }?>><? echo odbc_result($selectresult,'room_level');?></option>
		   
		  <? }?>
        </select>
        *
        </label>
          <input name="add" type="button" id="add" value="增加房间星级" onClick="location=('?room_number=<? echo $_GET['room_number'];?>&add=1')" />      </td>
      <? }?>
    </tr>
	<? if(isset($_GET['add'])&&$_GET['add']==1) { ?>
    <tr>
      <td><div align="right">房间价格：</div></td>
      <td><label>
        <input name="room_prise" type="text" id="room_prise" size="4"  value="<? echo odbc_result($room,'room_prise');?>"/>
     /天/人&nbsp; * </label></td>
    </tr>
	
    <tr>
      <td><div align="right">房间介绍：</div></td>
      <td><label>
        <textarea name="room_introduction" cols="26" rows="6" id="room_introduction"><? echo odbc_result($room,'room_introduction');?></textarea>
      </label></td>
    </tr>
	<? }?>
   
    <tr>
      <td>&nbsp;</td>
      <td height="60"><label>
        <input name="s" type="submit" id="s" value="修改" />
      </label>
        <label>
       &nbsp; 
       <input type="reset" name="Submit2" value="重置" />
      </label>
      <input name="rnumber" type="hidden" id="rnumber" value="<? echo base64_decode($_GET['room_number']);?>" />
      <input name="rlevel" type="hidden" id="rlevel" value="<? echo odbc_result($room,'room_level');?>" /></td>
    </tr>
	 <tr>
      <td>&nbsp;</td>
      <td height="60"><p align="left" >&nbsp;&nbsp;&nbsp; <a href="#" onClick="window.history.back();">返回</a></p></td>
    </tr>
  </table>
  </td>
  </tr>
  </table>
  
</form>
<script>
function maxlevel(number)
{
 if(number.value<<? echo odbc_result($selectresult,'room_level');?>||number.value==<? echo odbc_result($selectresult,'room_level');?>)
   { 
     alert("星级房间已在数据库中！");
     return false;
  　}
  else 
  return true;
  
	
}
</script>
<p \>
 <script src="../copyright.inc">
</script>
</body>
</html>
⌨️ 快捷键说明

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