<!doctype html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Document</title> </head> <body> <table width="700" border="0" align="center" cellpadding="0" cellspacing="2"> <tr bgcolor="#0000ff"> <td width="100"><div align="center">ลำดับที่</div></td> <td width="200"><div align="center">หมายเลขห้อง</div></td> <td width="200"><div align="center">ประเภทห้อง</div></td> <td width="200"><div align="center">รูปภายในห้อง</div></td> <td width="200"><div align="center">รายละเอียด</div></td> <td width="200"><div align="center">ราคา</div></td> <td width="200" align="center" >สถานะ</div></td> </tr> <form name="form1" method="post" action="show_check.php"> <?php include("Myconnect.php"); // Start date $dateStart=$_POST['dateStart']; $dateEnd=$_POST['dateEnd']; date_default_timezone_set('UTC'); include("Myconnect.php"); $no=0; $strSQL = "SELECT * FROM room"; $objQuery = mysql_query($strSQL); while($objResult = mysql_fetch_array($objQuery,MYSQLI_ASSOC)) { $strSQL2 = "SELECT * FROM person WHERE ( '$dateStart' BETWEEN dateStart and dateEnd) AND (Id_room = '".$objResult["Id_room"]."' )"; $objQuery2 = mysql_query($strSQL2); $objResult2 = mysql_fetch_array($objQuery2,MYSQLI_ASSOC); if(!$objResult2) { $Id_room=$objResult["Id_room"]; $sql2="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"); $result2 = mysql_query($sql2) ; $row2=mysql_fetch_array($result2,MYSQLI_ASSOC); $Id_room=$row2["Id_room"]; $Id_type=$row2["Id_type"]; $Detail_room=$row2["Detail_room"]; $Price_room=$row2["Price_room"]; $sql3="select * from roomtype where Id_type='$Id_type'"; $result3 = mysql_query($sql3) ; $row3=mysql_fetch_array($result3,MYSQLI_ASSOC); $Title_room=$row3["Title_room"]; $images=$row3["images"]; $no+=1; if($no%2==0) $bg="#ooccff"; else $bg="#e3fbfa"; ?> <tr bgcolor="<?=$bg;?>"> <td width="100"><div align="center"><?=$no;?></div></td> <td width="200"><div align="center"><input type="checkbox" name="room_text" value="" /> <?=$row2["Id_room"];?></div></td> <td width="200"><div align="center"><?=$Title_room;?></div></td> <td width="200"><div align="center"><img src="img/<?=$row3["images"];?>" width="100 " height="100" border="0" alt=""></div></td> <td width="200"><div align="center"><?=$row2["Detail_room"];?></div></td> <td width="200"><div align="center"><?=$row2["Price_room"];?></div></td> <td width="200" align="center">ว่าง</div></td> </tr> <?php } // } // echo "<br>"; $dateStart = date ("Y-m-d", strtotime("+1 day", strtotime($dateStart))); } ?> </table> <input class="submit" type="submit" name="btn" id="btn" value="SEARCH" /> </form> </body> </html>
<html> <head> <title>ThaiCreate.Com PHP & MySQL Tutorial</title> </head> <body> <script language="JavaScript"> function onSave() { if(confirm('Do you want to save ?')==true) { return true; } else { return false; } } </script> <form name="frmMain" action="save.php" method="post" OnSubmit="return onSave();"> <? $objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database"); $objDB = mysql_select_db("mydatabase"); $strSQL = "SELECT * FROM customer"; $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); ?> <table width="600" border="1"> <tr> <th width="91"> <div align="center">CustomerID </div></th> <th width="98"> <div align="center">Name </div></th> <th width="198"> <div align="center">Email </div></th> <th width="97"> <div align="center">CountryCode </div></th> <th width="59"> <div align="center">Budget </div></th> <th width="71"> <div align="center">Used </div></th> <th width="30"> <div align="center">Select </div></th> </tr> <? while($objResult = mysql_fetch_array($objQuery)) { ?> <tr> <td><div align="center"><?=$objResult["CustomerID"];?></div></td> <td><?=$objResult["Name"];?></td> <td><?=$objResult["Email"];?></td> <td><div align="center"><?=$objResult["CountryCode"];?></div></td> <td align="right"><?=$objResult["Budget"];?></td> <td align="right"><?=$objResult["Used"];?></td> <td align="center"><input type="checkbox" name="chkEmail[]" value="<?=$objResult["Email"];?>"></td> </tr> <? } ?> </table> <? mysql_close($objConnect); ?> <input type="submit" name="btnSave" value="Save"> </form> </body> </html>
<html> <head> <title>ThaiCreate.Com PHP & MySQL Tutorial</title> </head> <body> <? $objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database"); $objDB = mysql_select_db("mydatabase"); for($i=0;$i<count($_POST["chkEmail"]);$i++) { if($_POST["chkEmail"][$i] != "") { $strSQL = "INSERT INTO table_name (Mail) VALUES ('".$_POST["chkEmail"][$i]."')"; $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); } } echo "Record Insert."; mysql_close($objConnect); ?> </body> </html>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
Load balance : Server 00
Load balance : Server 00
