Ini mas skripnya
<form name="form1" method="get" action="">
NIM : <input type="text" name="nim" id="nim"/> <br/>
NAMA : <input type="text" name="nama" id="nama"/> <br/>
<input type="submit" value="Search" name="search"/>
</form>
<?php
if(isset($_GET['search'])){
$conn = mysql_connect("localhost", "root", "");
mysql_select_db("coba");
$nim = $_GET['nim'];
$nama = $_GET['nama'];
$sql = "select * from siswa where nama like '%$nama%' and
ayah like '%$ayah%'";
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0){
?>
<table>
<tr>
<td>NIM</td>
<td>NAMA</td>
</tr>
<?php
while($siswa = mysql_fetch_array($result)){?>
<tr>
<td><?php echo $siswa['nim'];?></td>
<td><?php echo $siswa['nama'];?></td>
</tr>
<?php }?>
</table>
<?php
}else{
echo 'Data not found!';
}
}
?>
kalw lbih dri 3, dtmbah apanya
2.misal kategori nim dn nama itu jka di isi dua"nya bsa tmpil, jka di isi salah satu gk tmpil.
Tidak ada komentar:
Posting Komentar