Advertisement
eyuprog

Simple Paging PHP MySQL

Dec 20th, 2013
222
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.13 KB | None | 0 0
  1. //Simple Paging data PHP Mysql
  2. // Heru Rahmat Akhnuari
  3. // http://www.ilmuprogrammer.com
  4.  
  5. //paging.php
  6. <style>
  7. .pagin {
  8. padding: 10px 0;
  9. font:bold 11px/30px arial, serif;
  10. }
  11. .pagin * {
  12. padding: 2px 6px;
  13. color:#0A7EC5;
  14. margin: 2px;
  15. border-radius:3px;
  16. }
  17. .pagin a {
  18.         border:solid 1px #8DC5E6;
  19.         text-decoration:none;
  20.         background:#F8FCFF;
  21.         padding:6px 7px 5px;
  22. }
  23.  
  24. .pagin span, a:hover, .pagin a:active,.pagin span.current {
  25.         color:#FFFFFF;
  26.         background:-moz-linear-gradient(top,#B4F6FF 1px,#63D0FE 1px,#58B0E7);
  27.            
  28. }
  29. .pagin span,.current{
  30.     padding:8px 7px 7px;
  31. }
  32. .content{
  33.     padding:10px;
  34.     font:bold 12px/30px gegoria,arial,serif;
  35.     border:1px dashed #0686A1;
  36.     border-radius:5px;
  37.     background:-moz-linear-gradient(top,#E2EEF0 1px,#CDE5EA 1px,#E2EEF0);
  38.     margin-bottom:10px;
  39.     text-align:left;
  40.     line-height:20px;
  41. }
  42. .outer_div{
  43.     margin:auto;
  44.     width:600px;
  45. }
  46. #loader{
  47.     position: absolute;
  48.     text-align: center;
  49.     top: 75px;
  50.     width: 100%;
  51.     display:none;
  52. }
  53.  
  54. </style>
  55. <?php
  56. function paginate($reload, $page, $tpages, $adjacents) {
  57.     $prevlabel = "&lsaquo; Prev";
  58.     $nextlabel = "Next &rsaquo;";
  59.     $out = '<div class="pagin green">';
  60.  
  61.    
  62.  
  63.     if($page==1) {
  64.         $out.= "<span>$prevlabel</span>";
  65.     } else if($page==2) {
  66.         $out.= "<a href='".$reload."page=".($page-1)."'>$prevlabel</a>";
  67.     }else {
  68.         $out.= "<a href='".$reload."page=".($page-1)."'>$prevlabel</a>";
  69.  
  70.     }
  71.    
  72.    
  73.     if($page>($adjacents+1)) {
  74.         $out.= "<a href='".$reload."page=1'>1</a>";
  75.     }
  76.    
  77.     if($page>($adjacents+2)) {
  78.         $out.= "...\n";
  79.     }
  80.  
  81.    
  82.  
  83.     $pmin = ($page>$adjacents) ? ($page-$adjacents) : 1;
  84.     $pmax = ($page<($tpages-$adjacents)) ? ($page+$adjacents) : $tpages;
  85.     for($i=$pmin; $i<=$pmax; $i++) {
  86.         if($i==$page) {
  87.             $out.= "<span>$i</span>";
  88.         }else if($i==1) {
  89.             $out.= "<a href='".$reload."page=$i'>$i</a>";
  90.         }else {
  91.             $out.= "<a href='".$reload."page=$i'>$i</a>";
  92.         }
  93.     }
  94.  
  95.    
  96.  
  97.     if($page<($tpages-$adjacents-1)) {
  98.         $out.= "...\n";
  99.     }
  100.  
  101.    
  102.  
  103.     if($page<($tpages-$adjacents)) {
  104.         $out.= "<a href='".$reload."page=$tpages'>$tpages</a>";
  105.     }
  106.  
  107.    
  108.  
  109.     if($page<$tpages) {
  110.         $out.= "<a href='".$reload."page=".($page+1)."'>$nextlabel</a>";
  111.     }else {
  112.         $out.= "<span>$nextlabel</span>";
  113.     }
  114.     $out.= "</div>";
  115.     return $out;
  116. }
  117. ?>
  118.  
  119. /////viewdata.php//////////
  120. $page = (isset($_REQUEST['page']) && !empty($_REQUEST['page']))?$_REQUEST['page']:1;
  121. $sql1="Select count(id_user) as numrows from userlogin";
  122. $sql2="Select * from userlogin";
  123. $per_page = 3;
  124. $adjacents  = 3;
  125. $offset = ($page - 1) * $per_page;
  126. $qCount=mysql_query($sql1);
  127. $row     = mysql_fetch_array($qCount);
  128. $numrows = $row['numrows'];
  129. $total_pages = ceil($numrows/$per_page);
  130. $querydata = mysql_query($sql2." LIMIT $offset,$per_page");
  131.  
  132. <table width="100%" border="0" cellspacing="0" cellpadding="0" class="table table-striped">
  133.   <tr>
  134.     <td>Username</td>
  135.      <td>Password</td>
  136.   </tr>
  137.   <?php
  138.  
  139.   while($s=mysql_fetch_array($querydata))
  140.   {
  141.      
  142.   ?>
  143.   <tr>
  144.     <td><?php echo $s['username_field']; ?></td>
  145.      <td><?php echo $s['password_field']; ?></td>      
  146.   </tr>
  147.   <?php
  148.   }
  149.   ?>
  150. </table>
  151. echo paginate("?mod=user&", $page, $total_pages, $adjacents);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement