Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $page = @$_GET['page'];
- if(!$page || !is_numeric($page) || $page < 0) {
- $page = 0;
- }
- $rpp = 100;
- mysql_connect('localhost', '', '') or die('Error connecting to MySQL');
- mysql_select_db('');
- $result = mysql_query("SELECT COUNT(*) FROM gamertags");
- $rowCount = mysql_result($result, 0);
- $numPages = floor($rowCount / $rpp);
- echo "There are ".$rowCount." Gamertags in the database!<br>\n";
- echo "Showing page ".($page + 1)." of ".($numPages + 1).", ".$rpp." results per page.<br>\n";
- echo (($page > 0) ? "<a href=\"?page=".($page - 1)."\"><< Previous</a>" : "");
- echo (($page > 0 && $page < $numPages) ? " | " : "");
- echo (($page < $numPages) ? "<a href=\"?page=".($page + 1)."\">Next >></a>" : "");
- echo "<br><hr>\n";
- $result = mysql_query("SELECT timestamp, gamertag FROM gamertags ORDER BY gamertag ASC LIMIT ".($page * $rpp).", ".($rpp));
- while ($row = mysql_fetch_assoc($result)) {
- echo "<i>(".$row['timestamp'].")</i> => ".$row['gamertag']."<br>\n";
- }
- echo "<br>\n";
- echo (($page > 0) ? "<a href=\"?page=".($page - 1)."\"><< Previous</a>" : "");
- echo (($page > 0 && $page < $numPages) ? " | " : "");
- echo (($page < $numPages) ? "<a href=\"?page=".($page + 1)."\">Next >></a>" : "");
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement