01.<?php include('header.php'); ?>
02. <div class="content-wrapper">
03.
04. <br/>
05. <center>
06. <form method="post">
07. ค้นหา:<input type="text" name="txt_search" placeholder="" />
08. <input type="submit" name="search" value="ค้นหา"/>
09. </form>
10. </center>
11. <section class="content-header">
12. <h1>
13. ข้อมูลลูกค้า
14. </h1>
15. </section>
16. <section class="content">
17. <div class="CSSTableGenerator" >
18. <table >
19. <tr>
20. <td>ลำดับ</td>
21. <td>ชื่อลูกค้า</td>
22. <td>พนักงาน</td>
23. </tr>
24. <?php
25. $sql=" select * from tb_enquire";
26. if(isset($_POST['search']))
27. {
28. $txt_search=$_POST['txt_search'];
29. $sql.=" where";
30. $sql.=" member_fname like '%".$txt_search."%'";
31. }
32. $result=$cls_con->select_base($sql);
33. while($row =mysqli_fetch_array($result))
34. {
35. ?>
36. <tr>
37. <td><?=$row['member_id'];?></td>
38. <td><?=$row['member_fname'];?></td>
39. <td><?=$row['employee_id'];?></td>
40. </tr>
41. <?php } ?>
42. </table>
43. </div>
44. </section>
45. </div>
46.
47.<?php include('footer.php'); ?>
