<html>
<head>
<title>edit reservation</title>
<script language=javascript src="function.js">
</script>
<script language=javascript>
function checkout()
{
var i=0;
for(x=0;x<document.f1.elements.length;x++)
{
if(document.f1.elements[x].value=="")
{
f1.txtname.focus();
alert("Plz Enter All Value");
i=1;
break;
}
}
if(i==0)
{
f1.method="POST";
f1.action="editres.php";
f1.submit();
}
}
</script>
</head>
<body bgcolor="#fff2e5">
<form method=POST>
Enter E-mail:
<input type="text" name="txtemail" value="<?php echo $_REQUEST['txtemail'];?>">
<table>
<tr>
<th align=left>CHECKIN DT:</th>
<td>
<select name=cmdday>
<?php
for($i=1;$i<=31;$i++)
if($i==date("d"))
{
echo "<option value='$i' selected>$i</option>";
}
else
{
echo "<option value='$i'>$i</option>";
}
?>
</select>
<select name=cmdmonth>
<?php
for($i=1;$i<=12;$i++)
if($i==date("m"))
{
echo "<option value='$i' selected>$i</option>";
}
else
{
echo "<option value='$i'>$i</option>";
}
?>
</select>
<select name=cmdyear>
<?php
for($i=2010;$i<=2020;$i++)
{
if($i==date("Y"))
{
echo "<option value='$i' selected>$i</option>";
}
else
{
echo "<option value='$i'>$i</option>";
}
}
?>
</select>
</td>
</tr>
</table>
<input type=submit value="go" name=sgo>
</form>
<?php
if(isset($_POST["sgo"]))
{
include "connection.php";
$email=$_POST["txtemail"];
$cid=$_POST["cmdday"]."-".$_POST["cmdmonth"]."-".$_POST["cmdyear"];
$qsel="select * from reservation where r_email='".$email."' and r_chkindt='".$cid."'";
$rs=mysql_query($qsel);
if(mysql_num_rows($rs)<1)
{
echo "<font color=purple>Record not found.</font>";
exit();
}
$v=mysql_fetch_array($rs);
?>
<form action="editres.php" method=POST name=f1>
<table>
<tr>
<th align=left>CHECKIN DT :</th>
<td>
<select name=cmdday>
<?php
$d=substr($v["r_chkindt"],8);
for($i=1;$i<=31;$i++)
if($i==$d)
{
echo "<option value='$i' selected>$i</option>";
}
else
{
echo "<option value='$i'>$i</option>";
}
?>
</select>
<select name=cmdmonth>
<?php
$m=substr($v["r_chkindt"],5,2);
for($i=1;$i<=12;$i++)
if($i==$m)
{
echo "<option value='$i' selected>$i</option>";
}
else
{
echo "<option value='$i'>$i</option>";
}
?>
</select>
<select name=cmdyear>
<?php
$y=substr($v["r_chkindt"],0,4);
for($i=2010;$i<=2020;$i++)
{
if($i==$Y)
{
echo "<option value='$i' selected>$i</option>";
}
else
{
echo "<option value='$i'>$i</option>";
}
}
?>
</select>
</td>
</tr>
<tr>
<th align=left>CHECKOUT DT :</th>
<td>
<select name=cmbday>
<?php
$d=substr($v["r_chkoutdt"],8);
for($i=1;$i<=31;$i++)
{
if($i==$d)
{
echo "<option value='$i' selected>$i</option>";
}
else
{
echo "<option value='$i'>$i</option>";
}
}
?>
</select>
<select name=cmbmonth>
<?php
$m=substr($v["r_chkoutdt"],5,2);
for($i=1;$i<=12;$i++)
{
if($i==$m)
{
echo "<option value='$i' selected>$i</option>";
}
else
{
echo "<option value='$i'>$i</option>";
}
}
?>
</select>
<select name=cmbyear>
<?php
$y=substr($v["r_chkoutdt"],0,4);
for($i=2010;$i<=2020;$i++)
{
if($i==$y)
{
echo "<option value='$i' selected>$i</option>";
}
else
{
echo "<option value='$i'>$i</option>";
}
}
?>
</select>
</td>
</tr>
<tr>
<th align=left>NO OF ROOMS :</th>
<td><input type=text name=txtroom size=3 value="<?php echo $v['r_rooms'];?>"></td>
<th align=left>TYPE :</th>
<td colspan=3><input type=text name=txttype size=10 readonly onKeyPress="validtype()" value="<?php echo $v['r_type'];?>"></td>
</tr>
<tr>
<th align=left>FULL NAME :</th>
<td colspan=3><input type=text name=txtname size=50 value="<?php echo $v['r_name'];?>"></td>
</tr>
<tr>
<th align=left>EMAIL :</th>
<td colspan=3><input type=text name="email" size=50 readonly onKeyPress="validemail()" value="<?php echo $v['r_email'];?>"></td>
</tr>
<tr>
<th align=left>COMPANY :</th>
<td colspan=3><input type=text name=txtcompany size=50 onKeyPress="validcompany()" value="<?php echo $v['r_company'];?>"></td>
</tr>
<tr>
<th align=left>TELEPHONE :</th>
<td colspan=3><input type=text name=txtnumber size=15 onKeyPress="validnumber()" value="<?php echo $v['r_phone'];?>"></td>
</tr>
<tr>
<th align=left valign=top>ADDRESS :</th>
<td colspan=3><textarea name=txtaddress rows=5 cols=40><?php echo $v['r_address'];?></textarea></td>
</tr>
<tr>
<th align=left>SPECIAL REQUIREMENT IF ANY :</th>
<td colspan=3><textarea name=txtspanyreq rows=5 cols=40><?php echo $v['r_spanyreq'];?> </textarea></td>
</tr>
<tr>
<td align=center colspan=2><input type="submit" name="s2" value="submit"></td>
</tr>
</table>
<input type=hidden name=txtemail2 value="<?php $_POST['txtemail']?>">
</form>
<?php } ?>
</body>
</html>
<?php
$qupd=mysql_query("update tariff set avroom=".$norm." where type='".$type."'");
$upd="update reservation set r_chkindt=$cid,r_chkoutdt=$cod,r_rooms=$norm,r_name=$name,r_email=$email,r_company=$comp,r_phone=$tele,r_address=$addr,r_spanyreq=$spreq where r_email=$emailn and r_chkindt=$cind";
$u=mysql_query($upd);
echo "<br><font color=7c0000 size=5>THANK YOU FOR INTEREST IN THE HOTEL PARAS.</font>";
?>
一个用PHP和MySql开发的成熟的酒店管理系统。您可以查看、预订、取消房间。有各种各样的房间，从标准房到豪华房；.zip
版权申诉
10 浏览量
2023-03-10
09:57:43
上传
评论
收藏 561KB ZIP 举报
一个用PHP和MySql开发的成熟的酒店管理系统。您可以查看、预订、取消房间。有各种各样的房间，从标准房到豪华房；.zip （109个子文件） 
reservation.frm 9KB tariff.frm 9KB user.frm 8KB
1.gif 29KB
hdining.jpg 71KB 1234.jpg 49KB dubai_hotel_001p.jpg 42KB piccolino_hotel_10.jpg 40KB bar-lobby-of-the-hotel.jpg 39KB caption.jpg 33KB little-india-hotels-5.jpg 31KB 273-2-zoom-1-aminta-grand-hotel-sorrento-lounge.jpg 31KB 310042_137777_1156182440.jpg 25KB p01.jpg 18KB Yuvraj-Surat.jpg 16KB 4352_1.jpg 15KB dining4.jpg 9KB meeting4.jpg 7KB hsuites.jpg 5KB dining2.jpg 5KB dining3.jpg 5KB regal4.jpg 5KB dining1.jpg 4KB regal3.jpg 4KB hmarriage.jpg 4KB meeting2.jpg 4KB hoverview.jpg 4KB im8ages.jpg 4KB hdefault.jpg 4KB hmeetings.jpg 4KB delicacy.jpg 4KB helegance.jpg 4KB meeting3.jpg 3KB hbusicent.jpg 3KB image111s.jpg 3KB hrooms.jpg 3KB superior.jpg 3KB meeting1.jpg 3KB std1.jpg 3KB exe1.jpg 3KB ima2ges.jpg 2KB images1.jpg 2KB pic5.jpg 2KB function.js 678B user.MYD 60B user.MYI 1024B edres.php 6KB reservation.php 4KB feedback.php 3KB contectus.php 3KB home.php 3KB bancon.php 3KB login.php 2KB tariff.php 2KB userinfo.php 2KB restaurant.php 2KB accommodation.php 2KB location.php 2KB addres.php 2KB aboutus.php 2KB deluxe1.php 2KB standard1.php 2KB taried.php 2KB superdeluxe1.php 2KB suite1.php 2KB delres.php 1KB index.php 1KB tariadd.php 1KB tariadd1.php 792B editres.php 742B suite.php 522B superdeluxe.php 508B tariedit.php 497B loginsession.php 489B deluxe.php 472B standard.php 436B deleres.php 427B userdetailinsert.php 307B link.php 251B first.php 250B room.php 240B connection.php 153B h1.php 103B standard2.php 96B b1.php 87B 11.php 87B h2.php 87B b2.php 87B r4.php 86B b3.php 86B 14.php 86B b4.php 86B r1.php 85B r3.php 85B r2.php 85B superdeluxe2.php 85B h3.php 84B 13.php 84B 12.php 84B h4.php 82B共 109 条
- 1
- 2
资源评论
