mau tanya tentang search di php dong...
begini ini script php saya....
<?php
include_once "library/inc.sesadmin.php";
include_once "library/inc.library.php";
# UNTUK PAGING (PEMBAGIAN HALAMAN)
$lim = 50;
$hal = isset($_GET['hal']) ? $_GET['hal'] : 0;
$pageSql = "SELECT * FROM pasien";
$pageQry = mysql_query($pageSql, $koneksidb) or die ("error paging: ".mysql_error());
$jml = mysql_num_rows($pageQry);
$max = ceil($jml/$lim);
if($_GET) {
# Jika tombol Cari/Search diklik, maka pencarian dilakukan
if(isset($_POST['btnSearch'])){
if($_POST) {
$mySql = "SELECT * FROM pasien WHERE nama LIKE '%".$_POST['txtCari']."%' ORDER BY (SUBSTR(no_telpon,4) + 0) ASC LIMIT $hal, $lim";
}
}
else {
$mySql = "SELECT * FROM pasien ORDER BY (SUBSTR(no_telpon,3) + 0) ASC LIMIT $hal, $lim";
}
} // End if($_GET) {
?>
<table width="900" border="0" class="table-border">
<tr>
<td colspan="2" align="right"><img src="images/data_pasien.png" width="300" height="80" /></td>
</tr>
<tr>
<td colspan="2"></td>
</tr>
<tr>
<td><form action="?page=Show-Pasien" method="post" name="form1" target="_self" id="form1">
<b>Cari Nama Pasien :
<input name="txtCari" type="text" value="<?php echo isset($_POST['txtCari']) ? $_POST['txtCari'] : '';?>" size="40" maxlength="100" />
<input name="btnSearch" type="submit" value="Cari" />
</b>
</form></td>
<td align="right"><a href="?page=Pasien-Jenis" target="_self"><img src="images/btn_add_data2.png" height="25" border="0" /></a></td>
</tr>
<tr>
<td colspan="2">
<table class="table-list" width="100%" border="0" cellspacing="1" cellpadding="2">
<tr>
<th width="25" align="center" bgcolor="#CCCCCC"><b>No</b></th>
<th width="98" bgcolor="#CCCCCC">Kode RM </th>
<th width="152" bgcolor="#CCCCCC"><b>Nama Pasien </b></th>
<th width="273" bgcolor="#CCCCCC">Alamat & Kota </th>
<th width="90" align="center" bgcolor="#CCCCCC">No Telpon </th>
<th width="90" align="center" bgcolor="#CCCCCC">Gol Darah </th>
<th width="60" align="center" bgcolor="#CCCCCC">Status </th>
<td colspan="4" align="center" bgcolor="#CCCCCC"><b>Tools</b><b></b></td>
</tr>
<?php
# Tampilkan data pasien, SQL-nya ada di halaman atas
$myQry = mysql_query($mySql, $koneksidb) or die ("Query pasien salah : ".mysql_error());
$nomor = 0;
while ($myRow = mysql_fetch_array($myQry)) {
$nomor++;
$Kode = $myRow['kd_pasien'];
$cekSql = "SELECT pasien.kd_pasien FROM pasien, periksa, rawatinap
WHERE pasien.kd_pasien=periksa.kd_pasien AND periksa.no_periksa=rawatinap.no_periksa
AND pasien.kd_pasien='$myRow[kd_pasien]' AND rawatinap.status='1'";
$cekQry=mysql_query($cekSql, $koneksidb) or die ("Eror Query".mysql_error());
// gradasi warna
if($nomor%2==1) { $warna=""; } else {$warna="#F5F5F5";}
// Status
if(mysql_num_rows($cekQry) >= 1){
$statusI = "RI";
$warnaI = "#FF9900";
} else {
$statusI = "F";
$warnaI = $warna;
}
?>
<tr bgcolor="<?php echo $warna; ?>"> <td align="center"><b><?php echo $nomor; ?></b></td>
<td><b><?php echo $myRow['kd_pasien']; ?></b></td>
<td><?php echo $myRow['nama']; ?></td>
<td><?php echo $myRow['alamat_lengkap'].", <b>Kota:</b> ".$myRow['nm_kota']; ?></td>
<td align="center"><?php echo $myRow['no_telpon']; ?></td>
<td align="center"><?php echo $myRow['gol_darah']; ?></td>
<td align="center" bgcolor="<?php echo $warnaI; ?>"><?php echo $statusI; ?></td>
<td width="50" align="center"><a href="?page=Add-Pendaftaran&Kode=<?php echo $Kode; ?>" target="_self" alt="Register/Daftar">Daftar</a></td>
<td width="50" align="center"><a href="?page=Edit-Pasien&Kode=<?php echo $Kode; ?>" target="_self" alt="Edit Data">Edit</a></td>
<td width="50" align="center"><a href="?page=Delete-Pasien&Kode=<?php echo $Kode; ?>" target="_self" alt="Delete Data" onclick="return confirm('Yakin akan menghapus data ini ?')">Delete</a></td>
</tr>
<?php } ?>
</table></td>
</tr>
<tr>
<td><b>Jumlah Data :</b> <?php echo $jml; ?> </td>
<td align="right"><b>Halaman ke :</b>
<?php
for ($h = 1; $h <= $max; $h++) {
$list[$h] = $lim * $h - $lim;
echo " <a href='?page=Show-Pasien&hal=$list[$h]'>$h</a> ";
}
?></td>
</tr>
</table>
<br />
<table width="250" border="0" class="table-list">
<tr>
<td colspan="2" bgcolor="#CCCCCC"><b>KETERANGAN STATUS </b></td>
</tr>
<tr>
<td width="12"><b>F</b></td>
<td width="178">: Free (Sehat) </td>
</tr>
<tr>
<td><b>RI</b></td>
<td>: Rawat Inap (Sedang dirawat) </td>
</tr>
</table>
itu search berdasarkan nama.... saya mau search itu bisa berdasarkan nama dan nomor hp.... sudah utak-atik gak ketemu caranya....
tolong dong saran²nya dari agan² disini....
terima kasih sebelumnya yaa...
Tidak ada komentar:
Posting Komentar