Advertisement
GWibisono

QUERY aneh?

Jun 10th, 2012
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
  12. {
  13.  $noPage = 1;
  14. }
  15. $offset = ($noPage - 1) * $dataPerPage;
  16.  
  17. $query = "SELECT * FROM tmptoken LIMIT $offset, $dataPerPage";
  18. $result = mysql_query ($query)or die("sql:<br> $query<hr>".mysql_error());
  19. $no = 1;
  20.  
  21. echo "<table border='1'>";
  22. echo "<tr><td>No</td><td>Nama</td><td>Frekuensi</td></tr>";
  23. while($data = mysql_fetch_array($result))
  24. {
  25.    echo "<tr><td>".$no."</td><td>".$data['kata']."</td><td>".$data['frekuensi']."</td></tr>";
  26. $no++;
  27. }
  28. echo "</table>";
  29.  
  30. $query2   = "SELECT COUNT(*) AS kata FROM tmptoken";
  31. $result2 = mysql_query ($query2)or die("sql:<br> $query<hr>".mysql_error());
  32. /*
  33. APA INI?? MASA HASIL QUERY DI QUERY LAGI
  34. $hasil  = mysql_query($result2)or die("sql:<br> $query<hr>".mysql_error());
  35. */
  36. $data2    = mysql_fetch_array($result2); //$hasil);
  37. $jumData = $data2['kata'];
  38.  
  39. $jumPage = ceil($jumData/$dataPerPage);
  40.  
  41. if ($noPage > 1) echo  "<a href='".$_SERVER['PHP_SELF']."?page=".($noPage-1)."'>&lt;&lt; Prev</a>";
  42.  
  43. for($page = 1; $page <= $jumPage; $page++)
  44. {
  45.     if (
  46.         (($page >= ($noPage - 3))
  47.         && ($page <= $noPage + 3))
  48.         || ($page == 1)
  49.         || ($page == $jumPage)
  50.     )
  51.     {
  52.             if (($showPage == 1) && ($page != 2))  echo "...";
  53.             if (($showPage != ($jumPage - 1)) && ($page == $jumPage))  echo "...";
  54.             if ($page == $noPage) echo " <b>".$page."</b> ";
  55.             else echo " <a href='".$_SERVER['PHP_SELF']."?page=".$page."'>".$page."</a> ";
  56.             $showPage = $page;
  57.          }
  58. }
  59.  
  60. if ($noPage < $jumPage){
  61.     echo "<a href='".$_SERVER['PHP_SELF'].
  62.         "?page=".($noPage+1)."'>Next &gt;&gt;</a>";
  63. }
  64. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement