Advertisement
Guest User

Untitled

a guest
Aug 16th, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.58 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8"/>
  5.     <title>เพิ่มประเภทห้องพัก</title>
  6. </head>
  7. </html>
  8.  
  9. <body bgcolor="90EE90">
  10. <img src="img/004.png" align="middle"/>
  11. <table border="6" cellpadding="6" cellspacing="6">
  12.     <tr>
  13.     <td><b> Id </b></td>
  14.     <td><b> Name </b></td>
  15.     <td><b> Price </b></td>
  16.     <td><b> Detail </b></td>
  17.     <td><b> Image </b></td>
  18.     </tr>
  19.  
  20.     <?php
  21.  $hostname = "localhost";
  22.     $username = "admin2";
  23.     $password = "012757957";
  24.     $dbname = "customer";
  25.     $conn = mysqli_connect ($hostname, $username, $password, $dbname);
  26.     if (!$conn)
  27. die("ไม่สามารถติดต่อ MySQL ได้");
  28. //mysqli_select_db($conn, $dbname) or die("ไม่สามารถเปิดใช้งานฐานข้อมูล $db_name ได้");
  29.  
  30.             // $tbl_room = "customer";  
  31.             // $connect = mysqli_connect($hostname, $username, $password) or die("ติดต่อฐานข้อมูลไม่ได้");
  32.             // $dbname = mysqli_select_db($dbname) or die("เลือกฐานข้อมูลไม่ได้");
  33.             $sqli = "select * from tbl_room";
  34.             $dbquery = mysqli_query($conn, $sqli) or die ("ส่งคิวรีไม่ได้");
  35.  
  36.             $row=mysqli_fetch_array($dbquery,MYSQLI_ASSOC);
  37.              
  38.       echo"<tr>";  
  39. echo"<td>$row[rt_id]</td>";
  40. echo"<td>$rs[name]</td>";
  41. echo"<td>$rs[price]</td>";
  42. echo"<td>$rs[detail]</td>";
  43. echo"<td>$rs[image]</td>";
  44. echo"</tr>";
  45. mysqli_close($conn);
  46.  ?>
  47.  </body>
  48.  </table>
  49.  </body>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement