01.<?php
02.$sql=" select * from tb_delivery order by deli_datejob desc ";
03.
04.if(isset($_POST['search']))
05. {
06. $txt_search=$_POST['txt_search'];
07. $sql.=" where";
08. $sql.=" deli_name like '%".$txt_search."%'";
09. $sql.=" or";
10. $sql.=" deli_detail like '%".$txt_search."%'";
11. }
12.
13.
14. $result = $conn->query($sql);
15. if ($result->num_rows > 0) {
16.
17. while($row = $result->fetch_assoc()) {
18. echo "<tr>";
19.
20. echo "<td>" . $row["deli_wan"]. "</td>";
21. echo "<td>" . $row ["deli_datejob"]. "</td>";
22. echo "<td>" . $row["deli_name"]. "</td>";
23. echo "<td>" . $row["deli_detail"]. "</td>";
24.
25. }
26. }
27.
28.?>
