1. <?php
2. include 'config.php';
3. ?>
4. <h3>Membuat Form Pencarian Dengan PHP MySQL - RajaPutraMedia.Com</h3>
5. <form action="index.php" method="get">
6. <label>Cari :</label>
7. <input type="text" name="cari">
8. <input type="submit" value="Cari">
9. </form>
10. <?php
11. if(isset($_GET['cari'])){
12. $cari = $_GET['cari'];
13. echo "<b>Hasil pencarian : ".$cari."</b>";
14. }
15. ?>
16. <table border="1">
17. <tr>
18. <th>No</th>
19. <th>Nama</th>
20. </tr>
21. <?php
22. if(isset($_GET['cari'])){
23. $cari = $_GET['cari'];
24. $data = mysql_query("select * from mhs where nama like '%".$cari."%'");
25. }
26. else{
27. $data = mysql_query("select * from mhs");
28. }
29. $no = 1;
30. while($d = mysql_fetch_array($data)){
31. ?>
32. <tr>
33. <td><?php echo $no++; ?></td>
34. <td><?php echo $d['nama']; ?></td>
35. </tr>
36. <?php
37. }
38. ?>
39. </table>