Advertisement
Guest User

1

a guest
Apr 21st, 2015
191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. <div class="bg_shop">
  2. <div class="bg_txt">
  3.  
  4. <?php
  5. $page = 1;
  6. $perPage = 10;
  7. if(!empty($_GET['page'])) $page = mysql_real_escape_string($_GET['page']);
  8.  
  9. $result = mysql_query("SELECT * FROM sms");
  10. $num_rows = mysql_num_rows($result);
  11.  
  12. $limit = ($page == 1 ? 0 : $page * $perPage - $perPage);
  13. $result = mysql_query("SELECT * FROM sms LIMIT ".$limit.", ".$perPage);
  14.  
  15. while($row = mysql_fetch_array($result)){
  16. echo "<div class=\"menu_body\">
  17. <img class=\"menu_img\" src=\"id/".$row['sms_img'].".png\" />
  18. <div class=\"menu\">
  19. <a href=\"?action=sms&key=".$row['id']."\" class=\"link\"><div class=\"menu_txt\">".$row['sms_title']."</div></a>
  20. </div>
  21. </div>";
  22. }
  23.  
  24. $pages = ceil($num_rows / $perPage);
  25. for($i = 0; $i < $pages; $i++){
  26. $x = $i + 1;
  27. echo "<a href=/?action=sklep&page=".$x."><font color=white>".$x."</font></a>";
  28. if($pages != $i)
  29. echo " | ";
  30. }
  31. ?>
  32.  
  33. </div>
  34. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement