Form Cari tidak Mencari tapi Menuju halaman Index.
Anggiat · May 25, 2012
Saya mempunyai sebuah halaman web dengan scrip sbb
<html>
<head>
<title>Untitled Document</title>
<style type="text/css">
<!--
.style2 {font-size: 12px}
-->
</style>
</head>
<body>
<table width="450" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="27" colspan="5"><img src="images/atas%20siswa.gif" width="430" height="26"></td>
</tr>
<tr>
<td height="27" colspan="5" align="center"><br><div class="assalam">
<h1>DAFTAR SISWA </h1>
</div></td>
</tr>
<tr>
<td height="27" colspan="5"><hr></td>
</tr>
<tr>
<td height="27" colspan="5"><div align="center">
<table width="98%" border="0" cellspacing="0" cellpadding="0"><form action="?act=cari_siswa" name="form1" method="post">
<tr>
<td width="41%"><div align="right">Cari Nama Siswa: </div></td>
<td width="37%"><input name="nama" type="text" id="nama" size="20"></td>
<td width="22%"><input type="submit" name="cari_siswa" value="Cari"></td>
</tr></form>
</table>
</div></td>
</tr>
<tr>
<td colspan="5"><hr></td>
</tr>
<?php
include_once('koneksi/konek.php');
$dataPerPage = 15;
if(isset($_GET['page']))
{
$noPage = $_GET['page'];
}
else
$noPage = 1;
$offset = ($noPage - 1) * $dataPerPage;
$sql_siswa = "SELECT tabel_siswa.id,tabel_siswa.nis,tabel_siswa.nama,tabel_siswa.tempat_lahir,tabel_siswa.tanggal_lahir,tabel_siswa.alamat,tabel_siswa.foto,tabel_jurusan.jurusan FROM tabel_siswa INNER JOIN tabel_jurusan ON tabel_siswa.id_jurusan=tabel_jurusan.id_jurusan where tabel_jurusan.status='Aktif' AND tabel_siswa.status='Aktif' ORDER BY tabel_jurusan.id_jurusan ASC limit $dataPerPage";
$qr_siswa = mysql_query($sql_siswa,$connect) or die ("Salah query".mysql_error());
while($hs_siswa=mysql_fetch_array($qr_siswa))
{
$id=$hs_siswa[0];
//$gambar = $_REQUEST['gambar'];
$gambar=$hs_siswa[6];
?>
<tr>
<td width="150" rowspan="6"><span class="style2">
<?php
if (empty($gambar))
{
echo "<img src='admin/images/siswa/noimage.jpg' width=150 height=150>";
}
else
{
echo "<img src='admin/images/siswa/$gambar' width=150 height=150>";
}
?>
</span></td>
<td height="6" colspan="4"></td>
</tr>
<tr>
<td width="8"> </td>
<td width="80" height="20"><font size="2" face="Tahoma">NIS</font></td>
<td width="16"><div align="left">:</div></td>
<td width="184"><font size="2" face="Tahoma"><?php echo "$hs_siswa[1] "; ?></font></td>
</tr>
<tr>
<td> </td>
<td height="21"><font size="2" face="Tahoma">Nama</font></td>
<td><div align="left">:</div></td>
<td><font size="2" face="Tahoma"><?php echo "$hs_siswa[2] "; ?></font></td>
</tr>
<tr>
<td> </td>
<td height="24"><font size="2" face="Tahoma">T T L </font></td>
<td><div align="left">:</div></td>
<td><font size="2" face="Tahoma"><?php
$tgllahir=$hs_siswa[4];
$tgllhr = substr($tgllahir,8,2);
$blnlhr = substr($tgllahir,5,2);
$thnlhr = substr($tgllahir,0,4);
$tgllahir = $tgllhr.'-'.$blnlhr.'-'.$thnlhr;
echo "$hs_siswa[3], $tgllahir "; ?></font></td>
</tr>
<tr>
<td> </td>
<td height="24"><font size="2" face="Tahoma">Alamat</font></td>
<td><div align="left">:</div></td>
<td><font size="2" face="Tahoma"><?php echo "$hs_siswa[5] "; ?></font></td>
</tr>
<tr>
<td> </td>
<td height="24"><font size="2" face="Tahoma">Jurusan</font></td>
<td><div align="left">:</div></td>
<td><font size="2" face="Tahoma"><?php echo "$hs_siswa[7] "; ?></font></td>
</tr>
<tr>
<td colspan="5"><hr></td>
</tr>
<tr>
<td colspan="5"></td>
</tr>
<?php } ?>
</table>
<?php
$query = "SELECT COUNT(*) AS jumData FROM tabel_siswa INNER JOIN tabel_jurusan ON tabel_siswa.id_jurusan=tabel_jurusan.id_jurusan where tabel_jurusan.status='Aktif' AND tabel_siswa.status='Aktif'";
$hasil = mysql_query($query);
$data = mysql_fetch_array($hasil);
$jumData = $data['jumData'];
$jumPage = ceil($jumData/$dataPerPage);
echo "<table border=0 align='center'>";
echo "<tr>";
echo "<td align='center'>";
if ($noPage > 1) echo "<a href='".$_SERVER['PHP_SELF']."?page=".($noPage-1)."'><< Prev </a>";
for($page = 1; $page <= $jumPage; $page++)
{
if ((($page >= $noPage - 3) && ($page <= $noPage + 3)) || ($page == 1) || ($page == $jumPage))
{
$showPage = $page;
if (($showPage == 1) && ($page != 2)) echo " ... ";
if (($showPage != ($jumPage - 1)) && ($page == $jumPage)) echo " ... ";
if ($page == $noPage)
{
echo "[ ";
echo "<b>" .$page. "</b>";
echo " ]";
}
else
{
echo "[ ";
echo "<a href='".$_SERVER['PHP_SELF']."?page=".$page."'>" .$page. "</a>";
echo " ]";
}
//$showPage = $page;
}
}
if ($noPage < $jumPage) echo "<a href='".$_SERVER['PHP_SELF']."?page=".($noPage+1)."'> Next >></a>";
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='center'>";
echo "Jumlah Data = $jumData";
echo "</td>";
echo "</tr>";
echo "</table>";
?>
</body>
</html>