Pagination Script

[Dysan]

I am currently developing a pagination script. The following code is what I have so far, but for some reason, the code in bold throws up errors. Why is this?

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("db", $con);

$perpage = 2;

$start = (isset($GET['id'])) ? $GET['id'] : 0;

$TotalRec = mysql_result(mysql_query("SELECT COUNT(*) FROM person"), 0);

$select = "SELECT * FROM person LIMIT $start, $perpage";
$result = mysql_query($select) or die(mysql_error());

Dislay your rows here in the loop

while($row = mysql_fetch_array($result))
{
echo $row['name']." ";
echo $row['age']." ";
echo $row['sex'].'<br />';
}

if($start == 0)
{
echo "PREVIOUS";
}
else
{
echo '<a href=\"./display.php?id="' . ($start - $perpage) . '"\">PREVIOUS</a>"';
}

$page = ($_GET['id'] / $perpage) + 1;
$total = ceil($TotalRec / $perpage);

if($start + $perpage >= $TotalRec)
{
echo "NEXT";
}
else
{
echo '<a href=\"./display.php?id="' . ($start + $perpage) . '"\">NEXT</a>';
}

echo '</div>';
?>

[laserlight]

What errors does it throw up? Also, kindly indent your code properly and post it within php bbcode tags.

[Dysan]

OK, I now have the following code, that limits the records displayed to only 5 per page. How do I add page number links to the script, so a user can go to a particular page directly?

e.g.

PREVIOUS |1|2|3|4|5|6|7|8|9| NEXT

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
  die('Could not connect: ' . mysql_error());
}

mysql_select_db("wb", $con);

$perpage = 5;

$start = (isset($_GET['id'])) ? $_GET['id'] : 0;

$TotalRec = mysql_result(mysql_query("SELECT COUNT(*) FROM person"), 0);

$select = "SELECT * FROM person LIMIT $start, $perpage";
$result = mysql_query($select) or die(mysql_error());

# Dislay your rows here in the loop
while($row = mysql_fetch_array($result))
{
  echo $row['name']." ";
  echo $row['age']." ";
  echo $row['sex'].'<br />';
}

if($start == 0)
{
  echo "PREVIOUS";
}
else
{
echo '<a href="display.php?id=' . ($start - $perpage) . '">'."PREVIOUS".'</a>';
}

$page = ($_GET['id'] / $perpage) + 1;
$total = ceil($TotalRec / $perpage);

if($start + $perpage >= $TotalRec)
{
  echo "NEXT";
}
else
{
echo '<a href="display.php?id=' . ($start + $perpage) . '">'."NEXT".'</a>';
}
?>

[daredevil14]

Well if you want to display each page number link ( e.g : 1 - 2 - 3.... ) beside the : ( first - prev - next - last ) links... you should use a For Loop Statement, to display each page until we reach the final page... ex :

<?php

for ( $page = 0; $page <= $maxpage; $page++ )
  {
  if ( $page == $pagenum )
    {
    $nav .= " $page ";
    }
    else
    {
    $nav .= " <a href=\"$self?page=$page\">$page</a> ";
    }
  }

?>

our page == 0, increase it until we reach the final page, if it is equal to the pagenum, then don't link it because we're already in it, else link it and query the page number with it... you just change my variables names to yours....

Cheers