Advertisement
sanca

samping

Jan 25th, 2014
321
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.94 KB | None | 0 0
  1. <table>
  2.  
  3. <?php
  4.  
  5. include("admin/koneksi.php");
  6.  
  7. $sqlCount = mysql_query("select kd_bk from buku");
  8.  
  9. $banyakData = mysql_num_rows($sqlCount);
  10.  
  11. $page = isset($_GET['page']) ? $_GET['page'] : 1;
  12.  
  13. $limit = 8;
  14.  
  15. $limitbaris=4;
  16.  
  17. $mulai_dari = $limit * ($page - 1);
  18.  
  19. $sql_limit = "select * from buku order by kd_bk desc limit $mulai_dari, $limit";  
  20.  
  21. $hasil = mysql_query($sql_limit);
  22.  
  23. //menampilkan data
  24.  
  25. while($data = mysql_fetch_array($hasil)){  
  26.  
  27.  ?>
  28.  
  29.  <td><a href="det_buku.php?kd=<?php echo $data['kd_bk']  ?>"><img src="admin/buku/<?php echo $data['gambar']?>"width='185' height="220" /><br />
  30.  
  31. <?php echo $data ['jdl_bk'] ?></a><br /><br />
  32.     </td>
  33.  
  34.  <?php
  35.  }
  36. ?>
  37.  
  38. </table>
  39.  
  40. <!-- PAGINATION -->
  41. <?php
  42. $banyakHalaman = ceil($banyakData / $limit);
  43. echo 'Halaman: ';
  44. for($i = 1; $i <= $banyakHalaman; $i++){
  45.  if($page != $i){
  46.  echo '[<a href="buku.php?page='.$i.'">'.$i.'</a>] ';
  47.  }else{
  48.  echo "[$i] ";
  49.  }
  50. }
  51. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement