View difference between Paste ID: sD0suPnN and 5XqaDC5v

 <?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)";
+//$pageSql = "SELECT * FROM Reservasi WHERE no_Reservasi NOT IN (SELECT nama FROM reservasi)";
-$pageQry = mysql_query($pageSql, $koneksidb) or die ("error paging: ".mysql_error());
+//$pageQry = mysql_query($pageSql, $koneksidb) or die ("error paging: ".mysql_error());
-$jml = mysql_num_rows($pageQry);
+
 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) {
 
 
 
 $myQry = mysql_query($mySql, $koneksidb) or die ("Query reservasi salah : ".mysql_error());
 $jml = mysql_num_rows($myQry);
 $max = ceil($jml/$lim);
 ?>
 <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">&nbsp;</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
 
 $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&amp;Kode=<?php echo $Kode; ?>" target="_self" alt="Periksa Dokter">Periksa</a></td>
 <td width="41" align="center"><a href="?page=Edit-Pendaftaran&amp;Kode=<?php echo $Kode; ?>" target="_self" alt="Edit Data">Edit</a></td>
 <td width="51" align="center"><a href="?page=Delete-Pendaftaran&amp;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>