Contoh Code Show PHP(Dengan Search)

---

<?php
error_reporting (0);
$host='localhost';
$user='root';
$pass='';

$conn=mysql_connect($host,$user,$pass);
mysql_select_db("coba",$conn) or die("koneksi gagal")
?>
<a href='Siswa_add.php'>TAMBAH DATA</a>
<table border='1'>
<tr>
<td>No.</td>
<td>NISN</td>
<td>Kode KK</td>
<td>Nama Siswa</td>
<td>Alamat Siswa</td>
<td>Tgl Lahir</td>
<td>Foto Siswa</td>
<td>Opsi</td>
</tr>
<?php
$show='select * from siswa';
$result=mysql_query($show);
while($data=mysql_fetch_array($result))
{
$no++;
?>
<tr>
<td><?php echo $no; ?>.</td>
<td><?php echo $data['NISN']; ?></td>
<td><?php echo $data['Kode_KK']; ?></td>
<td><?php echo $data['Nama_siswa']; ?></td>
<td><?php echo $data['Alamat_siswa']; ?></td>
<td><?php echo $data['Tgl_lahir']; ?></td>
<td><img src='Foto_siswa/<?php echo $data['Foto_siswa']; ?>' height='50px'><?php echo $data['Foto_siswa']; ?></td>
<td><a href="Siswa_edit.php?id=<?php echo $data['NISN']; ?>">EDIT</a>|<a href='Siswa_delete.php?id=<?php echo $data['NISN']; ?>'>DELETE</a></td>
</tr>
<?php
}
?>
</table>

---