Php pagination

SecondVersion said:

I've come up with something, but please note, that it is not tested. I am so tired, there are prolly errors, lol. >.<

PHP:

<?php

//Database Details
$dbhost = "localhost";
$dbuser = "username";
$dbpass = "password";
$dbname = "database";

//Connect
$db = mysql_connect("$dbhost", "$dbuser", "$dbpass") or die(mysql_error());
//Select Db
mysql_select_db("$dbname", $db) or die(mysql_error());

$query = mysql_query("SELECT * FROM table_name");
$total_rows = mysql_num_rows($query);
if(empty($page))
{
$page = 1;
}

//Maximum number of results
$max_results = 10;

$limit = $page * $max_results - ($max_results);

$query  = mysql_query("SELECT * FROM table_name LIMIT $limit, $max_results");
$result = mysql_query($query) or die("Error: " . mysql_error());

if($total_rows == 0)
{
echo "No data to display";
}

while($row = mysql_fetch_array($result))
{
$var = $row["filed"]);
//Etc... :)
echo $var;
//Etc... :)
}
if($page != 1)
{
$prev = $page--;
echo "<a href='yourpage.php?page=$prev'>Previous '.$limit.'</a>";
}
else
{
echo "Previous ".$limit." ");
}

$pages = $total_rows / $limit;

for($i = 1; $i <= $pages; $i++)
{
if($i == $page)
{
echo $i." ";
}
else
{
echo "<a href='yourpage.php?page=$i'>$i</a>";
}
}
if(($total_rows % $limit) != 0)
{
if($i == $page)
{
echo $i." ";
}
else
{
echo "<a href='yourpage.php?page=$i'>$i</a>";
}
}
if(($total_rows - ($limit * $page)) > 0)
{
$next = $page++;
echo "<a href='yourpage.php?page=$next'>Next '.$limit.'</a>";
}
else
{
echo "Next ".$limit;
}

?>

Click to expand...

PoorDoggie said:

lol - nice one! Thanks... great help. I used your script as a basis for my paignation thing. Seeing someone else's script kinda helps! Thanks a lot.

Click to expand...