01.<?php
02.$sqli = "SELECT * FROM customer";
03.
04.if ($_GET["Search_cus"] != "") {
05. $sqli .= " WHERE cus_name like '%" . $_GET["Search_cus"] . "%' or cus_surname like '%" . $_GET["Search_cus"] . "%'";
06. }
07.
08.$sqli .= " order by cus_id Asc Limit $start,$row ";
09.
10. $result = mysqli_query($con, $sqli);
11. $totalRows_prd = mysqli_num_rows($result);
12. if ($totalRows_prd > 0) {
13. while ($cus = mysqli_fetch_assoc($result)) {
14. ?>
15.
16. <tbody align='center'>
17. <tr>
18. <td> <?php echo $cus['cus_id']; ?></td>
19.
20. <td><?php echo $cus['cus_perfix']; ?> <?php echo $cus['cus_name']; ?> <?php echo $cus['cus_surname']; ?></td>
21.
22. <td><?php echo $cus['cus_email']; ?></td>
23.
24. <td><?php echo $cus['cus_number']; ?></td>
25.
26. <td><?php echo $cus['cus_address']; ?></td>
27.
28.<td><?php echo $cus['cus_district']; ?></td>
29.
30. <td><?php echo $cus['cus_prefecture']; ?></td>
31.<td><?php echo $cus['cus_province']; ?></td>
32. <td><?php echo $cus['cus_zip_code']; ?></td>
33.
34. </tr>
35. </tbody>
36. <?php
37. }
38. } else {
39. ?>
40. <h4 align='center'>
41. <script>alert('ไม่มีรายชื่อลูกค้าที่ต้องการ');window.location = 'Manage_Cus.php';</script>;
42.
43. </h4>
44. <?php
45. }
46. ?>
