Advertisement
Guest User

Untitled

a guest
Jan 20th, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. include "set.php";
  2. $num = 5;
  3.  
  4. $page = $_GET['page'];
  5.  
  6. $result = mysql_query("SELECT COUNT(*) FROM products");
  7. $posts = mysql_result($result, 0);
  8.  
  9. $total = intval(($posts - 1) / $num) + 1;
  10.  
  11. $page = intval($page);
  12.  
  13. if(empty($page) or $page < 0) $page = 1;
  14. if($page > $total) $page = $total;
  15.  
  16. $start = $page * $num - $num;
  17.  
  18. $result = mysql_query("SELECT * FROM products LIMIT $start, $num");
  19.  
  20. while ( $postrow[] = mysql_fetch_array($result))
  21. echo "<table>";
  22.  
  23. for($i = 0; $i < $num; $i++)
  24. {
  25. echo "<tr>
  26. <td>".$postrow[$i]['title']."</td>
  27. <td>".$postrow[$i]['price']."</td></tr>";
  28. }
  29. echo "</table>";
  30.  
  31. if ($page != 1) $pervpage = '<a href= ./page?page=1><<</a>
  32. <a href= ./page?page='. ($page - 1) .'><</a> ';
  33.  
  34. if ($page != $total) $nextpage = ' <a href= ./page?page='. ($page + 1) .'>></a>
  35. <a href= ./page?page=' .$total. '>>></a>';
  36.  
  37. if($page - 2 > 0) $page2left = ' <a href= ./page?page='. ($page - 2) .'>'. ($page - 2) .'</a> | ';
  38. if($page - 1 > 0) $page1left = '<a href= ./page?page='. ($page - 1) .'>'. ($page - 1) .'</a> | ';
  39. if($page + 2 <= $total) $page2right = ' | <a href= ./page?page='. ($page + 2) .'>'. ($page + 2) .'</a>';
  40. if($page + 1 <= $total) $page1right = ' | <a href= ./page?page='. ($page + 1) .'>'. ($page + 1) .'</a>';
  41.  
  42. echo $pervpage.$page2left.$page1left.'<b>'.$page.'</b>'.$page1right.$page2right.$nextpage;
  43.  
  44. <?php
  45. for ($i = 1; $i< $total; $i++) {
  46. if ($i == $page) {
  47. ?>
  48. <span class="page_active"><?php=$i?></span>
  49. <?php
  50. } else {
  51. if($i == 1) echo "<span><a href='/'>$i</a></span>";
  52. else echo "<span><a href='./page?=$i/'>$i</a></span>";
  53. }
  54. }
  55. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement