Advertisement
HaLo2FrEeEk

Pagination for RaH RaH

Feb 10th, 2011
188
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.26 KB | None | 0 0
  1. <?php
  2. $page = @$_GET['page'];
  3. if(!$page || !is_numeric($page) || $page < 0) {
  4.   $page = 0;
  5.   }
  6. $rpp = 100;
  7.  
  8. mysql_connect('localhost', '', '') or die('Error connecting to MySQL');
  9. mysql_select_db('');
  10.  
  11. $result = mysql_query("SELECT COUNT(*) FROM gamertags");
  12. $rowCount = mysql_result($result, 0);
  13. $numPages = floor($rowCount / $rpp);
  14. echo "There are ".$rowCount." Gamertags in the database!<br>\n";
  15. echo "Showing page ".($page + 1)." of ".($numPages + 1).", ".$rpp." results per page.<br>\n";
  16.  
  17. echo (($page > 0) ? "<a href=\"?page=".($page - 1)."\"><< Previous</a>" : "");
  18. echo (($page > 0 && $page < $numPages) ? "&nbsp;&nbsp;|&nbsp;&nbsp;" : "");
  19. echo (($page < $numPages) ? "<a href=\"?page=".($page + 1)."\">Next >></a>" : "");
  20. echo "<br><hr>\n";
  21.  
  22. $result = mysql_query("SELECT timestamp, gamertag FROM gamertags ORDER BY gamertag ASC LIMIT ".($page * $rpp).", ".($rpp));
  23.  
  24. while ($row = mysql_fetch_assoc($result)) {
  25.   echo "<i>(".$row['timestamp'].")</i>&nbsp;=>&nbsp;".$row['gamertag']."<br>\n";
  26.   }
  27. echo "<br>\n";
  28.  
  29. echo (($page > 0) ? "<a href=\"?page=".($page - 1)."\"><< Previous</a>" : "");
  30. echo (($page > 0 && $page < $numPages) ? "&nbsp;&nbsp;|&nbsp;&nbsp;" : "");
  31. echo (($page < $numPages) ? "<a href=\"?page=".($page + 1)."\">Next >></a>" : "");
  32. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement