<?php session_start(); if($_SESSION['MM_UserName'] == "" && $_SESSION['Status'] != "3") { echo "<center>Please Login</center>"; echo '<META http-equiv="refresh" content="0;URL=form_login.php">'; exit(); } include("Myconnect.php"); $lgSQL = "SELECT * FROM member WHERE id_member = '".$_SESSION['MM_UserName']."' "; mysql_query("set character set utf8"); mysql_query("SET character_set_results=utf8"); mysql_query("SET character_set_client=utf8"); mysql_query("SET character_set_connection=utf8"); $lgobjQuery = mysql_query($lgSQL); $lgin = mysql_fetch_array($lgobjQuery); ?> <!DOCTYPE HTML> <html> <head> <title>PhotoArtWork</title> <meta name="description" content="website description" /> <meta name="keywords" content="website keywords, website keywords" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <!-- stylesheets --> <link href="css/style.css" rel="stylesheet" type="text/css" /> <link href="css/light.css" rel="stylesheet" type="text/css" /> <style type="text/css"> #site_content div .info { color: #000; } </style> </style> </script> <script type="text/javascript" src="js/jquery-1.7.2.min.js"></script> <script type="text/javascript"> $(function(){ $("span#showmenu1").mouseover(function(event){ x=event.pageX; y=event.pageY; x-=5; y-=5; $("ul.v_menu").css({ position:"absolute", left:x, top:y }); $("ul.v_menu").show(); }); $("ul.v_menu").hover(function(){ },function(){ $("ul.v_menu").hide(); }); $("ul.v_menu").click(function(){ $("ul.v_menu").hide(); }); }); </script> <script type="text/javascript"> function conf_logout() { if(confirm('ต้องการออกจากระบบใช่หรือไม่?')) { return true; }else{ return false; } } </script> <!-- modernizr enables HTML5 elements and feature detects --> <script type="text/javascript" src="js/modernizr-1.5.min.js"></script> </head> <body> <div id="main"> <div align="right"> <!-- begin header --> </div> <header> <div id="logo"> <h1 align="right">VASSANA<a href="#">DESIGN</a>HOTEL</h1></div> <nav> <ul class="sf-menu" id="nav"> <li class="selected"><a href="for_member.php"><strong>Home</strong></a></li> <li><a href="#"><strong>จัดการข้อมูลการจอง</strong></a> <ul> <li><a href="check-revent.php"><strong>เช็คห้องว่าง</strong></a></li> <li><a href="show_reservation2.php"><strong>ข้อมูลจองห้องพัก</strong></a></li> </ul> </li> <li><a href="form_edit_member.php?editstaff=<? echo"".$lgin['id_member']."";?>"><strong>แก้ไขข้อมูลส่วนตัว</strong></a></li> <li><a href="Contact1.php"><strong>contact</strong></a></li> </ul> </nav> </header> <div align="right"> <!-- end header --> <!-- end header --> </div> <div id="nav-right"> <div align="right"> <div align="right"><span style="font-family: 'Tahoma'; font-size: 13px; color: #000;"><img src="images/on.png" align="absmiddle" /> <? echo"".$lgin['Name']."";?>  <? echo"".$lgin['Surname']."";?> </span><a href="form_login.php" onclick="return confirm('ต้องการออกจากระบบใช่หรือไม่ !!!')"> <img src="images/logout_usermi.png" align="absmiddle" /><b> ออกจากระบบ</b></a></span></div> </div> <div align="right"> <!-- begin content --> </div> <div id="site_content"> <div align="right"> <div align="center"> <!-- end header --> <!-- begin content --> </div> <p align="center" class="info" style="font-family:TH SarabunPSK; font-size:48px">รายละเอียดจองห้องพัก<br> <?php include("Myconnect.php"); ?> </p> <div align="center"> <ul class="items"> <font color="#000000"> <? echo "id_person = ".$id_person;?> <table > <tr> <td bgcolor="#FF99FF"><div align="center"><strong>Persondetail_id</strong></div></td> <td bgcolor="#FF99FF"><div align="center"><strong>id_person</strong></div></td> <td bgcolor="#FF99FF"><div align="center"><strong>Id_room</strong></div></td> <td bgcolor="#FF99FF"><div align="center"><strong>dateStart</strong></div></td> <td bgcolor="#FF99FF"><div align="center"><strong>dateEnd</strong></div></td> <td bgcolor="#FF99FF"><div align="center"><strong>Price_room</strong></div></td> </tr> <?php include("Myconnect.php"); $ps_SQL = "SELECT * FROM persondetail where id_person = '".$id_person."'"; mysql_query("set character set utf8"); mysql_query("SET character_set_results=utf8"); mysql_query("SET character_set_client=utf8"); mysql_query("SET character_set_connection=utf8"); $ps_Query = mysql_query($ps_SQL) or die ("error_person"); $records = mysql_num_rows($ps_Query); while($pers = mysql_fetch_array($ps_Query)) { $Persondetail_id = $pers["Persondetail_id"]; $id_person = $pers["id_person"]; $Id_room = $pers["Id_room"]; ?> <tr> <td bgcolor="#CCCCCC"><div align="center"> <?=$Persondetail_id; ?> </div></td> <td bgcolor="#CCCCCC"><div align="center"> <?=$id_person; ?> </div></td> <td bgcolor="#CCCCCC"><div align="center"> <?=$Id_room; ?> </div></td> <? $strSQL = "SELECT * FROM person where id_person = '".$id_person."'"; mysql_query("set character set utf8"); mysql_query("SET character_set_results=utf8"); mysql_query("SET character_set_client=utf8"); mysql_query("SET character_set_connection=utf8"); $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); while($objResult = mysql_fetch_array($objQuery)) { ?> <td bgcolor="#CCCCCC"><div align="center"> <?=$objResult["dateStart"]; ?> </div></td> <td bgcolor="#CCCCCC"><div align="center"> <?=$objResult["dateEnd"];?> </div></td> <? $strSQL1 = "SELECT * FROM room where Id_room = $Id_room "; mysql_query("set character set utf8"); mysql_query("SET character_set_results=utf8"); mysql_query("SET character_set_client=utf8"); mysql_query("SET character_set_connection=utf8"); $objQuery1 = mysql_query($strSQL1) or die ("Error Query [".$strSQL."]"); while($objResult1 = mysql_fetch_array($objQuery1)) $sum = $objResult1['Price_room']; { ?> <td bgcolor="#CCCCCC"><div align="center"> <?=$objResult1["Price_room"]; }}}?> </div></td> </tr> </table> <p> </p> <form action="add_submitsleep.php" method="post" enctype="multipart/form-data" name="form" id="form" > <input name="id_person" id="hidAction" type="hidden" value="<?=$id_person;?>"> <table width="453" align="center"> <tr> <td width="195" height="36"><strong><font color="#000000">วันที่โอนเงิน:</font></strong></td> <td width="246"><label for="textfield3"></label> <input type="text" name="date" id="textfield3"></td> </tr> <tr> <td height="41"><strong><font color="#000000">เวลาที่โอน:</font></strong></td> <td><label for="textfield2"></label> <input type="text" name="time" id="textfield2"></td> </tr> <tr> <td height="41"><strong><font color="#000000">ธนาคารต้นทาง:</font></strong></td> <td><label for="textfield2"></label> <input type="text" name="frombank" id="textfield2"></td> </tr> <tr> <td height="41"><strong><font color="#000000">ธนาคารปลายทาง:</font></strong></td> <td><label for="textfield2"></label> <input type="text" name="tobank" id="textfield2"></td> </tr> <tr> <td height="41"><strong><font color="#000000">ยอดโอน:</font></strong></td> <td><label for="textfield2"></label> <input type="text" name="price" id="textfield2"></td> </tr> <tr> <td height="41"><strong><font color="#000000">เลขที่โอนและเลขที่บัญชี:</font></strong></td> <td><label for="textfield2"></label> <input type="text" name="numberbank" id="textfield2"></td> </tr> <tr> <td height="41"><strong><font color="#000000">รูป:</font></strong></td> <td><input type="file" name="file" /> <input name="hidAction" id="hidAction" type="hidden" value="Add"></td> </tr> </table> <p> <input class="submit" type="submit" name="btn" value="submit" /> <input class="submit" type="reset" name="btn" value="reset" /> </p> </form> <p> </p> </ul> </font> </div> </div> <!-- end content --> <!-- begin footer --> <footer> <p> </p> <p><img src="images/twitter.png" alt="twitter" /> <img src="images/facebook.png" alt="facebook" /> <img src="images/rss.png" alt="rss" /></p> </footer> <!-- end footer --> </div> <!-- javascript at the bottom for fast page loading --> <script type="text/javascript" src="js/jquery.min.js"></script> <script type="text/javascript" src="js/jquery.easing-sooper.js"></script> <script type="text/javascript" src="js/jquery.sooperfish.js"></script> <!-- initialise sooperfish menu --> <script type="text/javascript"> $(document).ready(function() { $('ul.sf-menu').sooperfish(); }); </script> </body> </html>
<?php session_start(); if($_SESSION['MM_UserName'] == "" && $_SESSION['Status'] != "3") { echo "<center>Please Login</center>"; echo '<META http-equiv="refresh" content="0;URL=form_login.php">'; exit(); } include("Myconnect.php"); $lgSQL = "SELECT * FROM member WHERE id_member = '".$_SESSION['MM_UserName']."' "; mysql_query("set character set utf8"); mysql_query("SET character_set_results=utf8"); mysql_query("SET character_set_client=utf8"); mysql_query("SET character_set_connection=utf8"); $lgobjQuery = mysql_query($lgSQL); $lgin = mysql_fetch_array($lgobjQuery); ?> <!DOCTYPE HTML> <html> <head> <title>PhotoArtWork</title> <meta name="description" content="website description" /> <meta name="keywords" content="website keywords, website keywords" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <!-- stylesheets --> <link href="css/style.css" rel="stylesheet" type="text/css" /> <link href="css/light.css" rel="stylesheet" type="text/css" /> <style type="text/css"> #site_content div .info { color: #000; } </style> </style> </script> <script type="text/javascript" src="js/jquery-1.7.2.min.js"></script> <script type="text/javascript"> $(function(){ $("span#showmenu1").mouseover(function(event){ x=event.pageX; y=event.pageY; x-=5; y-=5; $("ul.v_menu").css({ position:"absolute", left:x, top:y }); $("ul.v_menu").show(); }); $("ul.v_menu").hover(function(){ },function(){ $("ul.v_menu").hide(); }); $("ul.v_menu").click(function(){ $("ul.v_menu").hide(); }); }); </script> <script type="text/javascript"> function conf_logout() { if(confirm('ต้องการออกจากระบบใช่หรือไม่?')) { return true; }else{ return false; } } </script> <!-- modernizr enables HTML5 elements and feature detects --> <script type="text/javascript" src="js/modernizr-1.5.min.js"></script> </head> <body> <div id="main"> <div align="right"> <!-- begin header --> </div> <header> <div id="logo"> <h1 align="right">VASSANA<a href="#">DESIGN</a>HOTEL</h1></div> <nav> <ul class="sf-menu" id="nav"> <li class="selected"><a href="for_member.php"><strong>Home</strong></a></li> <li><a href="#"><strong>จัดการข้อมูลการจอง</strong></a> <ul> <li><a href="check-revent.php"><strong>เช็คห้องว่าง</strong></a></li> <li><a href="show_reservation2.php"><strong>ข้อมูลจองห้องพัก</strong></a></li> </ul> </li> <li><a href="form_edit_member.php?editstaff=<? echo"".$lgin['id_member']."";?>"><strong>แก้ไขข้อมูลส่วนตัว</strong></a></li> <li><a href="Contact1.php"><strong>contact</strong></a></li> </ul> </nav> </header> <div align="right"> <!-- end header --> <!-- end header --> </div> <div id="nav-right"> <div align="right"> <div align="right"><span style="font-family: 'Tahoma'; font-size: 13px; color: #000;"><img src="images/on.png" align="absmiddle" /> <? echo"".$lgin['Name']."";?>  <? echo"".$lgin['Surname']."";?> </span><a href="form_login.php" onclick="return confirm('ต้องการออกจากระบบใช่หรือไม่ !!!')"> <img src="images/logout_usermi.png" align="absmiddle" /><b> ออกจากระบบ</b></a></span></div> </div> <div align="right"> <!-- begin content --> </div> <div id="site_content"> <div align="right"> <div align="center"> <!-- end header --> <!-- begin content --> </div> <p align="center" class="info" style="font-family:TH SarabunPSK; font-size:48px">รายละเอียดจองห้องพัก<br> <?php include("Myconnect.php"); ?> </p> <div align="center"> <ul class="items"> <font color="#000000"> <p><? echo "รหัสการจองห้องพัก : ".$id_person;?></p> <table width="532" > <tr> <td width="104" bgcolor="#FF99FF"><div align="center"><strong>รหัสการจองห้องพัก</strong></div></td> <td width="22" bgcolor="#FF99FF"><div align="center"><strong>ห้อง</strong></div></td> <td width="99" bgcolor="#FF99FF"><div align="center"><strong>ชื่อผู้จอง</strong></div></td> <td width="51" bgcolor="#FF99FF"><div align="center"><strong>วันที่เข้าพัก</strong></div></td> <td width="70" bgcolor="#FF99FF"><div align="center"><strong>วันที่ย้ายออก</strong></div></td> <td width="52" bgcolor="#FF99FF"><div align="center"><strong>ราคาห้อง</strong></div></td> </tr> <?php include("Myconnect.php"); $ps_SQL = "SELECT * FROM persondetail where id_person = '".$id_person."'"; mysql_query("set character set utf8"); mysql_query("SET character_set_results=utf8"); mysql_query("SET character_set_client=utf8"); mysql_query("SET character_set_connection=utf8"); $ps_Query = mysql_query($ps_SQL) or die ("error_person"); $records = mysql_num_rows($ps_Query); while($pers = mysql_fetch_array($ps_Query)) { $Persondetail_id = $pers["Persondetail_id"]; $id_person = $pers["id_person"]; $Id_room = $pers["Id_room"]; ?> <tr> <td bgcolor="#CCCCCC"><div align="center"> <?=$id_person; ?> </div></td> <td bgcolor="#CCCCCC"><div align="center"> <?=$Id_room; ?> </div></td> <? $strSQL = "SELECT * FROM person where id_person = '".$id_person."'"; mysql_query("set character set utf8"); mysql_query("SET character_set_results=utf8"); mysql_query("SET character_set_client=utf8"); mysql_query("SET character_set_connection=utf8"); $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); while($objResult = mysql_fetch_array($objQuery)) { ?> <td bgcolor="#CCCCCC"><div align="center"> <?=$objResult["tiname_ps"]; ?> <?=$objResult["fname_ps"]; ?> <?=$objResult["lname_ps"]; ?> </div></td> <td bgcolor="#CCCCCC"><div align="center"> <?=$objResult["dateStart"]; ?> </div></td> <td bgcolor="#CCCCCC"><div align="center"> <?=$objResult["dateEnd"];?> </div></td> <? $strSQL1 = "SELECT * FROM room where Id_room = $Id_room "; mysql_query("set character set utf8"); mysql_query("SET character_set_results=utf8"); mysql_query("SET character_set_client=utf8"); mysql_query("SET character_set_connection=utf8"); $objQuery1 = mysql_query($strSQL1) or die ("Error Query [".$strSQL."]"); while($objResult1 = mysql_fetch_array($objQuery1)) { ?> <td bgcolor="#CCCCCC"><div align="center"> <?=$objResult1["Price_room"]; }}}?> </div></td> </tr> <tr> <td> </td> </tr> </table> <p> </p> <form action="add_submitsleep.php" method="post" enctype="multipart/form-data" name="form" id="form" > <input name="id_person" id="hidAction" type="hidden" value="<?=$id_person;?>"> <table width="453" align="center"> <tr> <td width="195" height="36"><strong><font color="#000000">วันที่โอนเงิน:</font></strong></td> <td width="246"><label for="textfield3"></label> <input type="text" name="date" id="textfield3"></td> </tr> <tr> <td height="41"><strong><font color="#000000">เวลาที่โอน:</font></strong></td> <td><label for="textfield2"></label> <input type="text" name="time" id="textfield2"></td> </tr> <tr> <td height="41"><strong><font color="#000000">ธนาคารต้นทาง:</font></strong></td> <td><label for="textfield2"></label> <input type="text" name="frombank" id="textfield2"></td> </tr> <tr> <td height="41"><strong><font color="#000000">ธนาคารปลายทาง:</font></strong></td> <td><label for="textfield2"></label> <input type="text" name="tobank" id="textfield2"></td> </tr> <tr> <td height="41"><strong><font color="#000000">ยอดโอน:</font></strong></td> <td><label for="textfield2"></label> <input type="text" name="price" id="textfield2"></td> </tr> <tr> <td height="41"><strong><font color="#000000">เลขที่โอนและเลขที่บัญชี:</font></strong></td> <td><label for="textfield2"></label> <input type="text" name="numberbank" id="textfield2"></td> </tr> <tr> <td height="41"><strong><font color="#000000">รูป:</font></strong></td> <td><input type="file" name="file" /> <input name="hidAction" id="hidAction" type="hidden" value="Add"></td> </tr> </table> <p> <input class="submit" type="submit" name="btn" value="submit" /> <input class="submit" type="reset" name="btn" value="reset" /> </p> </form> <p> </p> </ul> </font> </div> </div> <!-- end content --> <!-- begin footer --> <footer> <p> </p> <p><img src="images/twitter.png" alt="twitter" /> <img src="images/facebook.png" alt="facebook" /> <img src="images/rss.png" alt="rss" /></p> </footer> <!-- end footer --> </div> <!-- javascript at the bottom for fast page loading --> <script type="text/javascript" src="js/jquery.min.js"></script> <script type="text/javascript" src="js/jquery.easing-sooper.js"></script> <script type="text/javascript" src="js/jquery.sooperfish.js"></script> <!-- initialise sooperfish menu --> <script type="text/javascript"> $(document).ready(function() { $('ul.sf-menu').sooperfish(); }); </script> </body> </html>
$sum = 0; while($objResult1 = mysql_fetch_array($objQuery1)) $sum = $sum+$objResult1["Price_room"]; { ?> <td bgcolor="#CCCCCC"><div align="center"> <?=$objResult1["Price_room"]; }}}?> </div></td> </tr> <tr> <td><?php echo $sum; ?> </td> </tr> </table>
$sum = 0; while($objResult1 = mysql_fetch_array($objQuery1)) { $sum = $sum+$objResult1["Price_room"]; ?> <td bgcolor="#CCCCCC"><div align="center"> <?=$objResult1["Price_room"]; }}}?> </div></td> </tr> <tr> <td><?php echo $sum; ?> </td> </tr> </table>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
Load balance : Server 01
Load balance : Server 01
