Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- # UNTUK PAGING (PEMBAGIAN HALAMAN)
- $lim = 50;
- $hal = isset($_GET['hal']) ? $_GET['hal'] : 0;
- $pageSql = "SELECT * FROM Reservasi WHERE no_Reservasi NOT IN (SELECT nama FROM reservasi)";
- $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 Reservasi.*, pasien.nama, dokter.nm_dokter
- FROM reservasi, pasien, dokter
- WHERE reservasi.kd_pasien=pasien.kd_pasien AND reservasi.kd_dokter=dokter.kd_dokter
- AND pasien.nama LIKE '%".$_POST['txtCari']."%'
- AND reservasi.no_reservasi NOT IN (SELECT no_reservasi FROM Reservasi)
- ORDER BY (SUBSTR(reservasi.no_reservasi,6) + 0) ASC LIMIT $hal, $lim";
- }
- }
- else {
- $mySql = "SELECT reservasi.*, pasien.nama, dokter.nm_dokter
- FROM reservasi, pasien, dokter
- WHERE reservasi.kd_pasien=pasien.kd_pasien AND reservasi.kd_dokter=dokter.kd_dokter
- AND reservasi.no_reservasi NOT IN (SELECT no_reservasi FROM Reservasi)
- ORDER BY (SUBSTR(reservasi.no_reservasi,6) + 0) ASC LIMIT $hal, $lim";
- }
- } // End if($_GET) {
- ?>
- <table width="1110" height="192" border="0" class="table-border">
- <tr>
- <td colspan="2" align="right"><img src="images/data_reservasi.png" width="300" height="60" /></td>
- </tr>
- <tr> </tr>
- <tr>
- <td width="394"><form action="?page=Show-Reservasi" 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="20" maxlength="100" />
- <input name="btnSearch" type="submit" value="Cari" />
- </b>
- </form></td>
- <td width="511"><div align="center"><b>Jumlah Data :</b> <?php echo $jml; ?> </div></td>
- <td width="10"></td>
- <td width="102" align="right"><a href="?page=Add-Reservasi" target="_self"><img src="images/btn_add_data2.png" height="25" border="0" /></a> </td>
- <td width="10"> </td>
- </tr>
- <tr>
- <td colspan="2"><table class="table-list" width="104%" border="0" cellspacing="1" cellpadding="2">
- <tr>
- <th width="29" align="center" bgcolor="#CCCCCC"><b>No</b></th>
- <th width="77" align="center" bgcolor="#CCCCCC">No Reservasi </th>
- <th width="77" align="center" bgcolor="#CCCCCC">Daftar </th>
- <th width="87" align="center" bgcolor="#CCCCCC">Operasi </th>
- <th width="133" bgcolor="#CCCCCC"><b>Nama Pasien </b></th>
- <th width="121" bgcolor="#CCCCCC">Dignosa </th>
- <th width="147" bgcolor="#CCCCCC">Nama Dokter </th>
- <th width="104" align="center" bgcolor="#CCCCCC"><div align="center">Keterangan</div></th>
- <td colspan="3" 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 reservasi salah : ".mysql_error());
- $nomor = 0;
- while ($myData = mysql_fetch_array($myQry)) {
- $nomor++;
- $Kode = $myData['no_reservasi'];
- // gradasi warna
- if($nomor%2==1) { $warna=""; } else {$warna="#F5F5F5";}
- ?>
- <tr bgcolor="<?php echo $warna; ?>">
- <td align="center"><b><?php echo $nomor; ?></b></td>
- <td align="center"><b><?php echo $myData['no_Reservasi']; ?></b></td>
- <td align="center"><?php echo IndonesiaTgl($myData['tgl_daftar']); ?></td>
- <td align="center"><?php echo IndonesiaTgl($myData['tgl_periksa']); ?></td>
- <td><?php echo $mydata['nama']; ?></td>
- <td><b><?php echo $myData['diagnosa']; ?></b></td>
- <td><?php echo $myData['kd_dokter']; ?></td>
- <td align="center"><div align="center"><?php echo $myData['keluhan']; ?></div></td>
- <td width="45" align="center"><a href="?page=Add-Periksa&Kode=<?php echo $Kode; ?>" target="_self" alt="Periksa Dokter">Periksa</a></td>
- <td width="41" align="center"><a href="?page=Edit-Pendaftaran&Kode=<?php echo $Kode; ?>" target="_self" alt="Edit Data">Edit</a></td>
- <td width="51" align="center"><a href="?page=Delete-Pendaftaran&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 align="right"><div align="left"><b>Halaman ke :</b>
- <?php
- for ($h = 1; $h <= $max; $h++) {
- $list[$h] = $lim * $h - $lim;
- echo " <a href='?page=Show-Reservasi&hal=$list[$h]'>$h</a> ";
- }
- ?>
- </div></td>
- </tr>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement