<h2 align="center">Daftar Produk</h2><form action="search1.php" method="post">
<input type="text" name="query" />
<select name="pencarian">
<option value="id_prdk">Id Produk
<option value="id_ktgr">Id Kategori
<option value="nm_prdk">Nama Produk
<option value="des_prdk">Deskripsi Produk
<option value="hrg">Harga
<option value="jmlh_stk">Jumlah Stok
<option value="gmb_prdk">Gambar Produk
<option value="gmb_iconprdk">Gambar Icon Produk
</select>
<input type="submit" name="submit" value="Cari" />
</form>
<?php
include ("koneksi.php");
$query = $_POST['query'];
$pencarian = $_POST['pencarian'];
if ($_POST['submit']) {
$query=mysql_query("select * from produk where $pencarian like '%$query%' ");
$cek=mysql_num_rows($query);
?>
<table border="1" bgcolor="#99CCCC" class="datatable">
<div align="left"><span class="style1">Hasil Pencarian</span>
</div>
<tr>
<th>*Id Produk*</th>
<th>**Id Kategori**</th>
<th>*Nama Produk*</th><th>*Deskripsi Produk*</th><th>*Harga*</th><th>*Jumlah Stok*</th><th>*Gambar Produk*</th><th>*Gambar Icon Produk*</th>
</tr>
<?php
if($cek){
while($row=mysql_fetch_array($query)){
?>
<tr bgcolor="#FFFFFF">
<td><?php echo $row['id_produk'];?></td>
<td><?php echo $row['id_ktgr'];?></td>
<td><?php echo $row['nm_prdk'];?></td>
<td><?php echo $row['des_prdk'];?></td>
<td><?php echo $row['hrg'];?></td>
<td><?php echo $row['jmlh_stk'];?></td>
<td><?php echo $row['gmb_prdk'];?></td>
<td><?php echo $row['gmb_iconprdk'];?></td>
</tr>
<?php
}
}else{
echo "Tidak ada data";
}
}else{
unset($_POST['submit']);
}
?>
Tidak ada komentar:
Posting Komentar