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 = "dbperpus";
- $vcari = $_POST['kode'];
- $koneksi = new mysqli($db_host, $db_user, $db_pass, $db_name);
- if($koneksi->connect_error)
- {
- echo "koneksi ke database Gagal..";
- }
- //else echo "koneksi Berhasil";
- $cek=mysqli_select_db($koneksi,$db_name);
- ?>
- <h1 align="center" class="style1"><strong>DATA FINDCODE </strong><strong></strong></h1>
- <!-- ///////////////////////////// Script untuk membuat tabel///////////////////////////////// -->
- <table Width='800' border='1' align="center">
- <tr>
- <th> kode </th>
- <th> Judul </th>
- <th>Penulis</th>
- </tr>
- <?php
- // Perintah untuk menampilkan data
- $hasil=MySQLi_query ($koneksi,"SELECT * FROM tbbuku WHERE judul LIKE '%$vcari%'") or die(mysqli_error());
- // perintah untuk membaca dan mengambil data dalam bentuk array
- while ($data = mysqli_fetch_array ($hasil)){
- echo "
- <tr>
- <td>".$data['kode']."</td>
- <td>".$data['judul']."</td>
- <td>".$data['penulis']."</td>
- </tr>
- ";
- }
- ?>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement