bucket
11-02-2009, 11:02 PM
<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');
include("inc/config.php");
$pagenum = (isset($_GET['pagenum'])) ? (int) $_GET['pagenum'] : 1;
$data = mysql_query("SELECT * FROM accounts") or die(mysql_error());
$rows = mysql_num_rows($data);
$page_rows = 4;
$last = ceil($rows/$page_rows);
if ($pagenum < 1)
{
$pagenum = 1;
}
elseif ($pagenum > $last)
{
$pagenum = $last;
}
$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows;
$data_p = mysql_query("SELECT * FROM accounts $max") or die(mysql_error());
while($info = mysql_fetch_array( $data_p ))
{
echo "Username: ";
Print $info['username'];
echo "<br>";
echo "Password: ";
Print $info['password'];
echo "<br>----";
echo "<br>";
}
echo "<p>";
echo " --Page $pagenum of $last-- <p>";
if ($pagenum == 1)
{
}
else
{
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1'> <<-First</a> ";
echo " ";
$previous = $pagenum-1;
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'> <-Previous</a> ";
}
echo " ---- ";
if ($pagenum == $last)
{
}
else {
$next = $pagenum+1;
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next'>Next -></a> ";
echo " ";
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last ->></a> ";
}
?>
----
Now I need help with another thing, How would I do it so instead of it posting it like this when im at the first page:
---- Next -> Last ->>
To like this:
| 1 | 2 | 3| Last ->>
Like it adds a number based on how many pages, its like instead of using the Next -> thing clicking over and over again to get to like page 5.
Same thing with the rest of the pages:
<<-First | 1 | 2 | 3| Last ->>
And the last page:
<<-First | 1 | 2 | 3|
Does anyone know how to do this? I want number pages instead of clicking to get to the next page or the page before.
error_reporting(E_ALL);
ini_set('display_errors', '1');
include("inc/config.php");
$pagenum = (isset($_GET['pagenum'])) ? (int) $_GET['pagenum'] : 1;
$data = mysql_query("SELECT * FROM accounts") or die(mysql_error());
$rows = mysql_num_rows($data);
$page_rows = 4;
$last = ceil($rows/$page_rows);
if ($pagenum < 1)
{
$pagenum = 1;
}
elseif ($pagenum > $last)
{
$pagenum = $last;
}
$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows;
$data_p = mysql_query("SELECT * FROM accounts $max") or die(mysql_error());
while($info = mysql_fetch_array( $data_p ))
{
echo "Username: ";
Print $info['username'];
echo "<br>";
echo "Password: ";
Print $info['password'];
echo "<br>----";
echo "<br>";
}
echo "<p>";
echo " --Page $pagenum of $last-- <p>";
if ($pagenum == 1)
{
}
else
{
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1'> <<-First</a> ";
echo " ";
$previous = $pagenum-1;
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'> <-Previous</a> ";
}
echo " ---- ";
if ($pagenum == $last)
{
}
else {
$next = $pagenum+1;
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next'>Next -></a> ";
echo " ";
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last ->></a> ";
}
?>
----
Now I need help with another thing, How would I do it so instead of it posting it like this when im at the first page:
---- Next -> Last ->>
To like this:
| 1 | 2 | 3| Last ->>
Like it adds a number based on how many pages, its like instead of using the Next -> thing clicking over and over again to get to like page 5.
Same thing with the rest of the pages:
<<-First | 1 | 2 | 3| Last ->>
And the last page:
<<-First | 1 | 2 | 3|
Does anyone know how to do this? I want number pages instead of clicking to get to the next page or the page before.