Kode PHP Untuk Pencarian Data di data base
<form action="list2.php">
search <input type="text" name="cari">
</form>
<br>
<?php
$cari = $_GET['cari'];
$query = "SELECT * FROM absen WHERE nama LIKE '%" . $cari . "%'";
$database = mysql_connect("localhost","root","2610");
mysql_select_db("guru", $database);
$result = mysql_query($query, $database);
echo "<table border='1'>";
echo "<tr><td>No</td> <td>NIS</td> <td>Nama</td></tr>";
for($i=0; $row = mysql_fetch_row($result); $i++){
echo "<tr><td>$row[0]</td> <td>$row[1]</td> <td>$row[2]</td></tr>";}
echo "</table>";
?>
search <input type="text" name="cari">
</form>
<br>
<?php
$cari = $_GET['cari'];
$query = "SELECT * FROM absen WHERE nama LIKE '%" . $cari . "%'";
$database = mysql_connect("localhost","root","2610");
mysql_select_db("guru", $database);
$result = mysql_query($query, $database);
echo "<table border='1'>";
echo "<tr><td>No</td> <td>NIS</td> <td>Nama</td></tr>";
for($i=0; $row = mysql_fetch_row($result); $i++){
echo "<tr><td>$row[0]</td> <td>$row[1]</td> <td>$row[2]</td></tr>";}
echo "</table>";
?>
nyaha kicak, list2'a mna? o.O
Makasih atas infonya gan. Mau nanya ni, kalau pencarianya di munculkan langsung dalam bentuk form bukan bentuk tabel gimana gan, tolong pencerahanya gan..
Silahkan isi Komentar Anda