|
 |
| |
ขอโค๊ด หน้า period กับหน้า Booking hotel แก้โค๊ดมาหลายรอบแล้ว ไม่ได้สักที ช่วยแนะนำหน่อยนะค่ะ ขอบคุณมาก ๆ ค่ะ |
| |
 |
|
|
 |
 |
|
เอาโค๊ดมาแปะดีกว่าไหมครับ
|
 |
 |
 |
 |
| Date :
2009-09-01 16:34:18 |
By :
plakrim |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
Code
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<?
include("../connect.php");
include("../function.php");
$id = $_GET["id"];
$id_p=$_GET["id_p"];
$sql = "select * from hotel_room_rate where id_period='$id_p'";
$sql_query=mysql_db_query("hotelthailand",$sql)or die(mysql_error());
$row = mysql_fetch_array($sql_query);
/*$sql = "SELECT* FROM
hotelthailand.hotel_roomtype
INNER JOIN hotelthailand.hotel_room_rate
ON (hotel_roomtype.id_room = hotel_room_rate.id_room) where id_information='$id' ";
$sql_query=mysql_db_query("hotelthailand",$sql)or die(mysql_error());
$row = mysql_fetch_array($sql_query);*/
if($_POST['button']){
$num=$_POST['num'];
echo $num;
for($loop=1; $loop<=$num; $loop++){
//echo '///////////////////////'.$_POST['room_actual_rate'.$loop].'<br>';
$id_period=$_POST['id_period'];
$id_information=$_POST['id_information'];
$id_language=$_POST['id_laguage'];
$id_room=$_POST['id_room'.$loop];
$room_period_from=$_POST['room_period_from'];
$room_period_to=$_POST['room_period_to'];
$room_actual_rate=$_POST['room_actual_rate'.$loop];
$room_vender_rate=$_POST['room_vender_rate'];
$room_member_rate=$_POST['room_member_rate'];
$room_extra_bed_adult=$_POST['room_extra_bed_adult'.$loop];
$room_extra_bed_child=$_POST['room_extra_bed_child'.$loop];
$room_breakfast_incl=$_POST['room_breakfast_incl'];
$update_date=$_POST['update_date'];
$room_period_from=$yy.'-'.$mm.'-'.$dd; // 2009-12-10 20091210
$room_period_to=$yy2.'-'.$mm2.'-'.$dd2; // 2009-12-10 20091210
if($id_room>0){
$sql="INSERT INTO hotel_room_rate
(id_period, id_information,id_language,id_room,
room_period_from,
room_period_to,
room_actual_rate,
room_vender_rate,
room_member_rate,
room_extra_bed_adult,
room_extra_bed_child,
room_breakfast_incl,
update_date)
values
(NULL,'$id','$id_language','$id_room',
'$room_period_from',
'$room_period_to',
'$room_actual_rate',
'$room_vender_rate',
'$room_member_rate',
'$room_extra_bed_adult',
'$room_extra_bed_child',
'$room_breakfast_incl',
'$update_date')";
$msg="เพิ่มข้อมูลผู้ใช้ลงในฐานข้อมูลเรียบร้อยแล้ว";
}
else if($id_p>0){
$sql="UPDATE hotel_room_rate SET
id_information='$id_information',
id_language='$id_language',
id_room ='$id_room',
room_period_from='$room_period_from',
room_period_to='$room_period_to',
room_actual_rate ='$room_actual_rate',
room_vender_rate='$room_vender_rate',
room_member_rate='$room_member_rate',
room_extra_bed_adult ='$room_extra_bed_adult,
room_extra_bed_child ='$room_extra_bed_child',
room_breakfast_incl ='$room_breakfast_incl',
update_date='$update_date' Where id_information='$id'";
$msg="อัปเดตข้อมูลผู้ใช้ลงในฐานข้อมูลเรียบร้อยแล้ว";
}
//echo $sql;
}
$sql_query = mysql_db_query("hotelthailand",$sql);
if ($sql_query)
//print"<br>เพิ่มข้อมูลผู้ใช้ลงในฐานข้อมูลเรียบร้อยแล้ว";
{
msg($msg);
?>
<meta http-equiv="refresh" content="0;url=show_room_rate.php" />
<?
}
else{
msg("ไม่สามารถอัปเดตข้อมูลได้");
}
// exit;
//if ($sql_query)
//print"<br>เพิ่มข้อมูลผู้ใช้ลงในฐานข้อมูลเรียบร้อยแล้ว";
//{
//msg($msg);
//}
//else{
// msg("ไม่สามารถอัปเดตข้อมูลได้");
}
?>
<title>Untitled Document</title>
<style type="text/css">
<!--
.style3 {font-family: "Cordia New"; font-size: 18px; }
.style4 {font-size: 18px}
.style5 {
font-size: 36px;
font-family: "Cordia New";
color: #FF00CC;
}
body,td,th {
font-family: Cordia New;
}
-->
</style>
</head>
<?
?>
<body>
<form id="form1" name="form1" method="post" action="">
<table width="95%" border="0" align="center">
<tr>
<td width="6%"> </td>
<td width="14%"> </td>
<td colspan="2"><div align="center"><span class="style5">Hotel Room Rate</span></div></td>
<td width="19%"> </td>
<td width="19%"> </td>
</tr>
<tr>
<td><span class="style4"></span></td>
<td><span class="style4">
<input type="hidden" name="id" id="id" value="<?=$id?>">
<input type="hidden" name="id_p" id="id_p" value="<?=$id_p?>"></span></td>
<td width="26%"><span class="style4"></span></td>
<td width="16%"><span class="style4"></span></td>
<td><span class="style4"></span></td>
<td><span class="style4"></span></td>
</tr>
<tr>
<td><span class="style4"></span></td>
<td><span class="style3">Period Form: </span></td>
<td><span class="style3">
<select name="dd" id="dd">
<option value="" selected="selected">-- d--</option>
<?
$dd =1;
$star=12;
while($dd <=$star){
$selecr='';
if ($row['room_period_form']==$dd){
$selecr=' selected="selected"';
}
?>
<option value="<?=$dd?><?=$selecr?>">
<?=$dd?>
</option>
<?
$dd++;
}
?>
</select>
<select name="mm" id="mm">
<option value="" selected="selected">-- m--</option>
<?
$mm =1;
$star=12;
while($mm <=$star){
$selecr='';
if ($row['room_period_form']==$mm){
$selecr=' selected="selected"';
}
?>
<option value="<?=$mm?><?=$selecr?>">
<?=$mm?>
</option>
<?
$mm++;
}
?>
</select>
<select name="yy" id="yy">
<option value="" selected="selected">-- y--</option>
<?
$yy =2009;
$star=2011;
while($yy<=$star){
$selecr='';
if ($row['room_period_form']==$yy){
$selecr=' selected="selected"';
}
?>
<option value="<?=$yy?><?=$selecr?>">
<?=$yy?>
</option>
<?
$yy++;
}
?>
</select>
</span></td>
<td><span class="style3">Period To: </span></td>
<td><span class="style3">
<select name="dd2" id="dd2">
<option value="" selected="selected">-- d--</option>
<?
$dd2=1;
$star=12;
while($dd2<=$star){
$selecr='';
if ($row['room_period_to']==$dd2){
$selecr='selected="selected"';
}
?>
<option value="<?=$dd2?><?=$selecr?>">
<?=$dd2?>
</option>
<?
$dd2++;
}
?>
</select>
<select name="mm2" id="mm2">
<option value="" selected="selected">--m--</option>
<?
$mm2=1;
$star=12;
while($mm2<=$star){
$selecr='';
if ($row['room_period_to']==$mm2){
$selecr=' selected="selected"';
}
?>
<option value="<?=$mm2?><?=$selecr?>">
<?=$mm2?>
</option>
<?
$mm2++;
}
?>
</select>
<select name="yy2" id="yy2">
<option value="" selected="selected">-- y--</option>
<?
$yy2=2009;
$star=2011;
while($yy2<=$star){
$selecr='';
if ($row['room_period_to']==$yy2){
$selecr=' selected="selected"';
}
?>
<option value="<?=$yy2?><?=$selecr?>">
<?=$yy2?>
</option>
<?
$yy2++;
}
?>
</select>
</span></td>
<td><span class="style4"></span></td>
</tr>
<tr>
<td><span class="style4"></span></td>
<td><span class="style4"></span></td>
<td><span class="style4"></span></td>
<td><span class="style4"></span></td>
<td><span class="style4"></span></td>
<td><span class="style4"></span></td>
</tr>
<tr>
<td><span class="style4"></span></td>
<td><span class="style4"></span></td>
<td><span class="style4"></span></td>
<td><span class="style4"></span></td>
<td><span class="style4"></span></td>
<td><span class="style4"></span></td>
</tr>
<?
$sql = "select * from hotel_roomtype where id_information='$id'";
$result= mysql_query($sql);
while ($rows= mysql_fetch_array($result)) {
$num++;
?>
<tr>
<td> </td>
<td><span class="style3">ประเภทห้อง</span></td>
<td><span class="style4">
<?=$rows['room_type']?>
</span></td>
<td><span class="style4">
<label>
<input name="room_actual_rate<?=$num?>" type="text" id="room_actual_rate<?=$num?>" value="<?= $row['room_actual_rate'];?>" />
</label>
</span></td>
<td>
<label></label> <input name="room_extra_bed_adult<?=$num?>" type="text" id="room_extra_bed_adult<?=$num?>" value="<?= $row['room_extra_bed_adult'];?>" /> </td>
<td><span class="style4"><input name="room_extra_bed_child<?=$num?>" type="text" id="room_extra_bed_child<?=$num?>" value="<?= $row['room_extra_bed_child'];?>" />
</span></td>
</tr>
<tr>
<td><span class="style4"></span></td>
<td> </td>
<td><span class="style4">
<input type="hidden" name="id_room<?=$num?>" id="id_room<?=$num?>" value="<?=$rows['id_room']?>">
</span></td>
<td> </td>
<td> </td>
<td><span class="style4"></span></td>
</tr>
<tr>
<td><span class="style4"></span></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td><span class="style4"></span></td>
</tr>
<?
}
?>
</table>
<input type="hidden" name="num" id="num" value="<?=$num?>">
<?
include("../disconnect.php");
?>
<span class="style4">
<input type="submit" name="button" id="button" value="save">
</span>
</form>
ทำ add ได้แล้ว แต่ต้องการให้ มัน edit ด้วยต้องทำไงค่ะ แนะนำด้วยนะค่ะ
|
| |
|
|
| |
| Date :
2009-09-01 17:33:40 |
By :
mam |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
edit ไม่ได้ขอ Database ด้วยครับ จะแก้ให้
|
| |
|
|
| |
| Date :
2010-01-18 10:21:46 |
By :
tim |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ขึ้น error ว่างัยครับ
|
| |
|
|
| |
| Date :
2010-01-18 10:26:22 |
By :
T&Parita |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 00
|
