Please assist with pagination

[binto]

Please help with pagination. I have tried using the codes I found here without success.

My problems:
1. Search result returns only one item
2. Prev and Next buttons do not go to next or prev page.

Thank you
Here is my code:

<?
// how many rows to show per page
$rowsPerPage = 5;
// by default we show first page
$pageNum = 1;
// if $GET['page'] defined, use it as page number
if(isset($GET['page']))
{
$pageNum = $_GET['page'];
}
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;

$selectQuery = "SELECT * FROM tbl_product where itemName like '%$search%'or itemDesc like '%$search%'or itemDesc2 like '%search%' order by itemName, itemDesc DESC LIMIT 0,5";
$selectResult=kal_query($selectQuery);

while($row=newFetch($selectResult))
{	   
   $id_product=$row->id_product;
   $itemName=$row->itemName;
   $DeptName=$row->DeptName;
   $itemDesc=$row->itemDesc;
   $itemDesc2=$row->itemDesc2;
   $itemimage=$row->itemImage;
   $id_company=$row->id_company;
   $companyname=$row->companyname;
   $subcat=$row->subcat;
   $var1="logo_".$id_company;
   //echo $var1;	   

if( $itemimage)
{
$Str1 = "www/$id_company/$itemimage";
}
$linkitemlogo="<img border='0' src='$Str1' width='65' height='65'></a>";

$linkItemNm="<a href='showproduct.php?s=".rawurlencode($search)."&id_product=$id_product&itemName=".rawurlencode($itemName)."'  class='prod_link2'>$linkitemlogo</a>";

// how many rows we have in database
$selectQuery = "SELECT COUNT(*) AS numrows FROM tbl_product where itemName like '%$search%'or itemDesc like '%$search%'or itemDesc2 like '%$search%'";
$selectResult=kal_query($selectQuery);
$rowCount = kal_fetch_array($selectResult,MYSQL_ASSOC) or kal_error();
$numrows = $rowCount['numrows'];

// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);

//$self = $_SERVER['PHP_SELF'];

// creating 'previous' and 'next' link
// plus 'first page' and 'last page' link

// print 'previous' link only if we're not
// on page one
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " <a href='search.php?page=$page'>[Prev]</a> ";

$first = " <a href='search.php?page=1'>[First Page]</a> "; 

}
else
{
$prev = ' [Prev] '; // we're on page one, don't enable 'previous' link
$first = ' [First Page] '; // nor 'first page' link
}

// print 'next' link only if we're not
// on the last page
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " <a href='search.php?page=$page'>[Next]</a> ";
$last = " <a href='search.php?page=$maxPage'>[Last Page]</a> ";
}
else
{
$next = ' [Next] '; // we're on the last page, don't enable 'next' link
$last = ' [Last Page] '; // nor 'last page' link
}

// print the page navigation link
$pageLink= "$first . $prev . Showing page <strong>$pageNum</strong> of <strong>$maxPage</strong> pages . $next . $last";
}
?>

[paulnaj]

Hi binto,

I think you're going to find no-one willing to answer your question ... I personally can't be bothered to read through it all and even if I could, I wouldn't be able to help you because I can't test code this end without connecting to your db.

The best thing is for you to at least try and isolate where the bug is occurring by doing some standard debug routines.

Let me know if you want some help on doing this.

Paul 😉

[binto]

Hello Paul,

Thank you for responding.

I have a feeling the bug id with the get page.

// if $GET['page'] defined, use it as page number
if(isset($GET['page']))
{
$pageNum = $_GET['page'];
}

The query is returning results and the next buton indicates page2, page3, etc.However, clicking doesn't take me to page to page2, page3 etc.

Thank you

[pseudonym]

if (empty($_GET['p']))
{
	$p = 1;
    $limitvalue = 0;
}
else 
{ 
    $p = $_GET['p'];
	$limitvalue = $p * $perPage - ($perPage);
}