Stuck with next and previous pagination problems

jamesmiddz

Hi,

I recently found a great bit of code on the net for pagination. The only problem is, this bit of code worked well in a fixed setup. I had to modify it for my needs, and it's not doing what I'd hoped it would do.

Basically, when I run a search query across my table (covering multiple fields) the code gives me the page results ie. <<previous 1 2 3 next>> (great!). But as soon as I click on Next - even more pages appear ie <<previous 1 2 3 4 5 6 7 8 9 10 next>> (not so great).

Now, I'm sure that I have over looked something. If you can spot it, please let me know.

Here's the code.

form.php

search1.php

<?php
// file to be included
include 'config.php';
$gensearch = $_GET['general'] ;

//Check if the page number is defined else set it to one. Standard Procedure. 🙂
if(!isset($GET['page'])){
$page = 1;}
else {$page = $GET['page'];
}
//Calclate the offsets
$from = (($page * $max_results) - $max_results);
// Creat the query to be performed and then perform it.
$sql = mysql_query("$query_list LIMIT $from, $max_results");
// pre_result output
echo $pre_result;

while($row = mysql_fetch_array($sql)){ // loop through the result of the page.

include("template.inc");
}

//post_result outpur
echo $post_result;

// Calculate the total number of results.
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM countries WHERE county like \"%$gensearch%\" OR accom like \"%$gensearch%\" OR postcode like \"%$gensearch%\" "),0);

// Calculate the total number of pages. ceil() is used to round the page number to the higher integer.
$total_pages = ceil($total_results / $max_results);
// The real stuff. Creats the Navigation Menu
//Set font style for navigation area

echo "<div class=\"text\"><center>$nav_title<br>";
// Create the Previous link.
if($page > 1){
$prev = ($page - 1);
echo "<a class=\"nav\" href=\"".$SERVER['PHP_SELF']."?$httpvar=$prev&county=$gensearch&accom=$gensearch&postcode=$gensearch\">$pre_style</a> ";
}
//Creat the navigation page numbers.
for($i = 1; $i <= $total_pages; $i++){
if(($page) == $i){ // make sure the link is not given to the page being viewed
echo "$i ";
} else {
echo "<a class=\"nav\" href=\"".$SERVER['PHP_SELF']."?$httpvar=$i&county=$gensearch&accom=$gensearch&postcode=$gensearch\">$i</a> ";
}
}
// Create the next link.
if($page < $total_pages){
$next = ($page + 1);

echo "<a class=\"nav\" href=\"".$_SERVER['PHP_SELF']."?$httpvar=$next&county=$gensearch&accom=$gensearch&postcode=$gensearch\">$next_style</a>";

}
echo "</center></div>";
echo $post_nav;
?>

config.php

<?
$gensearch = $_GET['general'] ;
//General Configuration Variables
$max_results = 20; // Define the number of results per page
$next_style = 'Next'; // The look for the next button
$pre_style = 'Previous';//The look for the previous button
$extra_var =''; //end with & if used. this is the variable you will pass if required.

//WARNING do not modify the $httpvar.
$httpvar = $extra_var.'page';

$pre_result='';
$post_result='';
$post_nav='';
$nav_title='Pages Available';

//Database configuration; // please change the variables below as required// a must
$user="shmootcase_co_u";
$pass="*";
$host="localhost";
$db="*";

//Database connection. Do not modify below this.
$conn = mysql_connect($host,$user,$pass);
mysql_select_db($db,$conn);
// mysql query to be performed
$query_list = "SELECT * FROM countries WHERE county like \"%$gensearch%\" OR accom like \"%$gensearch%\" OR postcode like \"%$gensearch%\" ";

$numresults=mysql_query($query_list);
$numrows=mysql_num_rows($numresults);

if ($numrows == 0)
{
echo "<h4>Results</h4>";
echo "<p>Sorry, your search returned no results</p>";
}

template.inc

<? echo " <a href=\"../details.php?id=".$row['id']."\">MORE"; ?><br>
Name:<? echo $row["holsite"]; ?><br>
img src="../../secure/ul/<? echo $row["thumb"]; ?>" border="1"><br>
Town:<? echo $row["town"]; ?><br>
County:<? echo $row["county"]; ?><br>

Thanks, Regards James M.

PallaviDalvi

am not sure if ur really looking for this... but i have a peice of code that takes care of pagenation... but i find it a bit more simpler to understand than the one u posted. am posting it here...maybe it helps u in any way... or else.... sorry for wasting time! 🙂

this file is named result.php

<?
error_reporting(E_ALL);
define("ROWS_ON_PAGE",5);
if (isset($_REQUEST['page_num']))
	$page_num=$_REQUEST['page_num'];
else
	$page_num=1;
$conn=mysql_connect();
$db=mysql_select_db("test") ;

$query=mysql_query("select First_Name ,Middle_Name, City,Address,Email  from person order by Person_ID");
$total_rows=ceil(mysql_num_rows($query)/ROWS_ON_PAGE);


?>
<BODY >
<table width=100%>
	<tr >
		<td colspan=3></td>
		<td align=right>
			<?
			for ($i=1;$i <= $total_rows;$i++)
			{
				if ($i !=$page_num)
					echo "<a href='result.php?page_num=". $i . "' >" .$i . "</a>&nbsp;";
				else
					echo $i . "&nbsp;";  //no link for current page
			}
			?>
		</td>
	</tr>
	<tr bgcolor=#cccccc>
		<td width=20% >Name</td>
		<td width=20%>City</td>
		<td width=20%>Address</td>
		<td width=20%>Email</td>
	</tr>
	<?
		$num_rows=0;
		if ($page_num == 1)
			$rec_start=0;
		else
			$rec_start=ROWS_ON_PAGE * ($page_num-1) ;

	mysql_data_seek($query,$rec_start);
	while ($rows=mysql_fetch_array($query))
	{
		echo "<tr>";
			echo"<td>";
				echo $rows['First_Name'] ,$rows['Middle_Name'];
			echo "</td>";
			echo"<td>";
				echo $rows['City'];
			echo "</td>";
			echo"<td>";
				echo $rows['Address'];
			echo "</td>";
			echo"<td>";
				echo $rows['Email'];
			echo "</td>";

		echo "</tr>";
		$num_rows++;
		if ($num_rows == ROWS_ON_PAGE)
			break;
}
?>
</table>

jamesmiddz

Thanks, I'll try this out.

I suppose you wouldnt know how to alter this so that it looks into multiple fields and for more complex searches would you?

Regards, James

PallaviDalvi

my guess is that no matter what level of complexity the data retrieval assumes... the display part remains the same. what changes is just the query part. so the php part before <body> wud undergo a change...rest shud remain as it is.

jamesmiddz

I have found the script that you provided to be pretty good and neat. The only thing is, if I use the search term 'LIKE' i.e;

select * from countries where country like \"%$general%\" or theme like \"%$general%\" order by id

Things go wrong. I reveive a page of results....If I click on the next number, the list will suddenly grow.

The other problem I've been having while using this script is when a page comes up to show '0' results, I get the message 'Warning: mysql_data_seek(): Offset 0 is invalid for MySQL result index 3 (or the query data is unbuffered) '.

Apart from this, I think that this is a very good bit of coding.

Kind Regards, James

PallaviDalvi

Hi James... well the code was definitely not complete in all forms. it was just an outline i had. moreover i tried using 'like' in my queries and the page worked fine... dont know why it works funny at ur side. have taken care of the case when there are no results.

<BODY >
<?
if ($total_rows != 0)
{
?>
<table width=100%>
	<tr >
		<td colspan=3></td>
		<td align=right>
			<?
			for ($i=1;$i <= $total_rows;$i++)
			{
				if ($i !=$page_num)
					echo "<a href='". $_SERVER['PHP_SELF'] . "?page_num=". $i . "' >" .$i . "</a>&nbsp;";
				else
					echo $i . "&nbsp;";
			}
			?>
		</td>
	</tr>
	<tr bgcolor=#cccccc>
		<td width=20% >Name</td>
		<td width=20%>City</td>
		<td width=20%>Address</td>
		<td width=20%>Email</td>
	</tr>
	<?
		$num_rows=0;
		if ($page_num == 1)
			$rec_start=0;
		else
			$rec_start=ROWS_ON_PAGE * ($page_num-1) ;

	mysql_data_seek($query,$rec_start);
	while ($rows=mysql_fetch_array($query))
	{
		echo "<tr>";
			echo"<td>";
				echo $rows['First_Name'] ,$rows['Middle_Name'];
			echo "</td>";
			echo"<td>";
				echo $rows['City'];
			echo "</td>";
			echo"<td>";
				echo $rows['Address'];
			echo "</td>";
			echo"<td>";
				echo $rows['Email'];
			echo "</td>";

		echo "</tr>";
		$num_rows++;
		if ($num_rows == ROWS_ON_PAGE)
			break;
}
?>
</table>
<?
}
else
{
	echo "<center><font>Sorry no matching records found</font></center>";
}
?>
</BODY>

hope that works for u ...