Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //membuat koneksi ke database
- $db_host = "localhost";
- $db_user = "root";
- $db_pass = "";
- $db_name = "dbuas";
- $vcari = $_POST['cari'];
- $koneksi = mysql_connect ($db_host, $db_user, $db_pass, $db_name);
- $cek=mysql_select_db($db_name);
- ?>
- <h1 DATA BARANG </h1>
- <table Width='800' border='1' align="center">
- <tr>
- <th> kode </th>
- <th> nama </th>
- <th>jenis</th>
- <th>harga</th>
- </tr>
- <?php
- // Perintah untuk menampilkan data
- $hasil=MySQL_query ("SELECT * FROM tbwelsa WHERE jenis LIKE '%$vcari%'");
- // perintah untuk membaca dan mengambil data dalam bentuk array
- while ($data = mysql_fetch_array ($hasil)){
- echo "
- <tr>
- <td>".$data['kode']."</td>
- <td>".$data['nama']."</td>
- <td>".$data['jenis']."</td>
- <td>".$data['harga']."</td>
- </tr>
- ";
- }
- ?>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement