Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <strong>PENCARIAN:</strong><br>
- <form action="<?$_SERVER['PHP_SELF']?>" method="post" name="pencarian" id="pencarian">
- <input type="text" name="search" id="search">
- <input type="submit" name="submit" id="submit" value="CARI">
- </form>
- <?php
- // konfigurasi
- $db_host = "localhost"; // nama host
- $db_user = "root"; // username mysql
- $db_pass = "0l4lupa3N"; //password isi sesuai seting server Anda.
- $db_name = "yudo"; // karena nama database yang kita buat adalah pencarian
- // koneksi ke database
- $link = mysql_pconnect ($db_host, $db_user, $db_pass) or die ("Ga bisa connect");
- mysql_select_db ($db_name) or die ("Ga bisa select database");
- ?>
- <table width="600" align="center" bgcolor="#CC9900" border="1">
- <tr>
- <th>No</th>
- <th>Nama</th>
- <th>JK</th>
- <th></th>
- </tr>
- <?php
- // menampilkan data
- if ((isset($_POST['submit'])) AND ($_POST['search'] <> "")) {
- $search = $_POST['search'];
- $sql = mysql_query("SELECT * FROM siswa WHERE nama LIKE '%$search%' ") or die(mysql_error());
- //menampilkan jumlah hasil pencarian
- $jumlah = mysql_num_rows($sql);
- if ($jumlah > 0) {
- echo '<p>Ada '.$jumlah.' data yang sesuai.</p>';
- while ($res=mysql_fetch_array($sql)) {
- $nomor++;
- echo "<tr>";
- echo "<td>".$nomor."</td>";
- echo "<td>".$res['nama']."</td>";
- echo "<td>".$res['sex']."</td>";
- }
- echo "</table><br>";
- }
- else {
- // menampilkan pesan zero data
- echo 'Maaf, hasil pencarian tidak ditemukan.';
- }
- }
- else { echo 'Masukkan dulu kata kuncinya';}
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement