Advertisement
Guest User

hasilcari

a guest
Jan 25th, 2018
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. <?php
  2. //membuat koneksi ke database
  3. $db_host = "localhost";
  4. $db_user = "root";
  5. $db_pass = "";
  6. $db_name = "dbuas";
  7. $vcari = $_POST['cari'];
  8. $koneksi = mysql_connect ($db_host, $db_user, $db_pass, $db_name);
  9. $cek=mysql_select_db($db_name);
  10. ?>
  11. <h1 DATA BARANG </h1>
  12.  
  13. <table Width='800' border='1' align="center">
  14. <tr>
  15. <th> kode </th>
  16. <th> nama </th>
  17. <th>jenis</th>
  18. <th>harga</th>
  19. </tr>
  20.  
  21. <?php
  22. // Perintah untuk menampilkan data
  23. $hasil=MySQL_query ("SELECT * FROM tbwelsa WHERE jenis LIKE '%$vcari%'");
  24.  
  25. // perintah untuk membaca dan mengambil data dalam bentuk array
  26. while ($data = mysql_fetch_array ($hasil)){
  27. echo "
  28. <tr>
  29. <td>".$data['kode']."</td>
  30. <td>".$data['nama']."</td>
  31. <td>".$data['jenis']."</td>
  32. <td>".$data['harga']."</td>
  33. </tr>
  34. ";
  35.  
  36. }
  37.  
  38. ?>
  39. </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement