01.<link rel="stylesheet" href="mystyle.css">
02.<?php
03.$connect = mysqli_connect("localhost", "root", "1234", "ioonresort");
04.$output = '';
05.if(isset($_POST["query"]))
06.{
07. $search = mysqli_real_escape_string($connect, $_POST["query"]);
08. $query = "
09. SELECT * FROM customer
10. WHERE CustomerName LIKE '%".$search."%'
11. OR CustomerSurName LIKE '%".$search."%'
12. ";
13.}
14.else
15.{
16. $query = "
17. SELECT * FROM customer ORDER BY CustomerID";
18.}
19.$result = mysqli_query($connect, $query);
20.if(mysqli_num_rows($result) > 0)
21.{
22.
23. $output .= '<table border=1 width=900px>
24. <t>
25. <td align=center>รหัสลูกค้า</td>
26. <td align=center>ชื่อ</td>
27. <td align=center>นามสกุล</td>
28. <td align=center>แก้ไข</td>
29. <td align=center>ลบ</td>
30. </tr>';
31. while($show = mysqli_fetch_array($result))
32. {
33.
34. $output .= ' <tr>
35. <td align=center><h3>'.$show['CustomerID'].'</h3></td>
36. <td align=center><h3>'.$show['CustomerName'].'</h3></td>
37. <td align=center><h3>'.$show['CustomerSurName'].'</h3></td>
38. <td align=center><h2><a href ='Updatepriceovertime1.php?id=".$show['CustomerID']."'><div class=img-resize><img src=img/edit.png></a></div></h2></td>
39. <td align=center><h2><div class=img-resize><img src=img/delete.png></div></h2></td>
40. </tr>';
41. }
42. echo $output;
43.}
44.else
45.{
46. echo 'Data Not Found';
47.}
48.?>
Quote:
