alifcintaibu

paging

Jun 10th, 2012
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.51 KB | None | 0 0
  1. <?php
  2. include('koneksi.php');
  3. include('index_inputan.php');
  4.  
  5. $dataPerPage = 5;
  6.  
  7. if(isset($_GET['page']))
  8. {
  9.     $noPage = $_GET['page'];
  10. }
  11. else $noPage = 1;
  12.  
  13. $offset = ($noPage - 1) * $dataPerPage;
  14.  
  15. $query = "SELECT * FROM tmptoken LIMIT $offset, $dataPerPage";
  16. $result = mysql_query ($query);
  17. $no = 1;
  18. echo "<table border='1'>";
  19. echo "<tr><td>No</td><td>Nama</td><td>Frekuensi</td></tr>";
  20. while($data = mysql_fetch_array($result))
  21. {
  22.    echo "<tr><td>".$no."</td><td>".$data['kata']."</td><td>".$data['frekuensi']."</td></tr>";
  23. $no++;
  24. }
  25. echo "</table>";
  26.  
  27. $query2   = "SELECT COUNT(*) AS kata FROM tmptoken";
  28. $result2 = mysql_query ($query2);
  29. $hasil  = mysql_query($result2);
  30. $data2    = mysql_fetch_array($hasil);
  31. $jumData = $data2['kata'];
  32.  
  33. $jumPage = ceil($jumData/$dataPerPage);
  34.  
  35. if ($noPage > 1) echo  "<a href='".$_SERVER['PHP_SELF']."?page=".($noPage-1)."'>&lt;&lt; Prev</a>";
  36.  
  37. for($page = 1; $page <= $jumPage; $page++)
  38. {
  39.          if ((($page >= $noPage - 3) && ($page <= $noPage + 3)) || ($page == 1) || ($page == $jumPage))
  40.          {
  41.             if (($showPage == 1) && ($page != 2))  echo "...";
  42.             if (($showPage != ($jumPage - 1)) && ($page == $jumPage))  echo "...";
  43.             if ($page == $noPage) echo " <b>".$page."</b> ";
  44.             else echo " <a href='".$_SERVER['PHP_SELF']."?page=".$page."'>".$page."</a> ";
  45.             $showPage = $page;
  46.          }
  47. }
  48.  
  49. if ($noPage < $jumPage) echo "<a href='".$_SERVER['PHP_SELF']."?page=".($noPage+1)."'>Next &gt;&gt;</a>";
  50. ?>
Advertisement
Add Comment
Please, Sign In to add comment