HELP with Paging

BarryJ

Before I go into this I should you that I have done all the searches for this topic, but have no answer, results, but no answer, so I'm putting the topic here.

I have tried a number of paging scripts and classes without success. The scripts all run fine for the first page, but when you select another page the result is a blank page and the paging navigation has gone. What I don't know is if this is a php configuration problem or just faulty code. It seems to me that when you go to the next page there is nothing in the session to perhaps re-run the query to get the next number of results.

To see what I mean go to

www.homestarrg.com/buyers/mls_full_search_dev2.php

and just put in a dollar value for the property and choose a county and town, multiple, if necessary, and when you get the result go to the bottom of the page and click page 2 or something.

I could really do with some help on this.

Drakla

And you're reading in the page value, yes? And how are you propagating what query they chose? Is that stored in the session, as it's not part of the query string.

BarryJ

I don't quite understand what you are asking, can you explain?

BarryJ

When you look at the source after the query has been run, this is an extract of what you see from the page navigation.

Don't know if that helps.

halojoy

can you post the beginning of your page:

mls_search_results_dev.php
it is there the evalutating of variable $page =
is being done, I suppose

<?php

// this is beginng of php source code for my page
// 'mls_search_results_dev.php'

if ( isset( $_GET[ "page" ] ) ) {

$chosen_page = $_GET[ "page" ];
echo "you clicked page number: $chosen_page";

}

?>

BarryJ

At the beginning of the page I have the class.

class Pager
{
function getPagerData($numHits, $limit, $page)
{
$numHits = (int) $numHits;
$limit = max((int) $limit, 1);
$page = (int) $page;
$numPages = ceil($numHits / $limit);

       $page = max($page, 1); 
       $page = min($page, $numPages); 

       $offset = ($page - 1) * $limit; 

       $ret = new stdClass; 

       $ret->offset   = $offset; 
       $ret->limit    = $limit; 
       $ret->numPages = $numPages; 
       $ret->page     = $page; 

       return $ret; 
   }

}

Farther down the document I add other code to reference the class

			//****Start Paging Code****//
			// get the pager input values 
			$page = $_GET['page']; 
			$limit = 10; 
			$result = mysql_query("select count(*) from tBRSfeed WHERE $whereclause"); 
			$total = mysql_result($result, 0, 0); 

			// work out the pager values 
			$pager  = Pager::getPagerData($total, $limit, $page); 
			$offset = $pager->offset; 
			$limit  = $pager->limit; 
			$page   = $pager->page; 
			//****End Paging Code Part 1****//

			//$rst=Query("SELECT * FROM tBRSfeed WHERE $whereclause ORDER BY town ASC");
			//$total_results = mysql_num_rows($rst); 
			//**** Pager Code 2 ****//
			$query = "SELECT * FROM tBRSfeed WHERE $whereclause ORDER BY town ASC LIMIT $offset, $limit"; 
			$result = mysql_query($query); 				
			//**** End Pager Code 2 ****//

And then this for the page navigation.

			<?php
			//**** Pager Code 3 ****//
			// output paging system (could also do it before we output the page content) 
			if ($page == 1) // this is the first page - there is no previous page 
				echo "Previous"; 
			else            // not the first page, link to the previous page 
				echo "<a href=\"mls_search_results_dev.php?page=" . ($page - 1) . "\">Previous</a>"; 

			for ($i = 1; $i <= $pager->numPages; $i++) { 
				echo " | "; 
				if ($i == $pager->page) 
					echo "Page $i"; 
				else 
					echo "<a href=\"mls_search_results_dev.php?page=$i\">Page $i</a>"; 
			} 

			if ($page == $pager->numPages) // this is the last page - there is no next page 
				echo "Next"; 
			else            // not the last page, link to the next page 
				echo "<a href=\"mls_search_results_dev.php?page=" . ($page + 1) . "\">Next</a>"; 
			//**** Pager Code 3 Ends****//
			?>

BarryJ

I have removed the paging code, so as to get on with things. Thanks for the input from all.

topsub

I wil post my code to page data

this is for the content, The best way to make an include file with the layout of the page. I dont have time to make the code basic, so filter threw it, if you have trouble just post i will help you when i have time to check back

		<?

//************ this is teh total number of row in ur sql
	$countness = $totalRows;
//*************
	$lmt = $_GET['c'];
	$amount = 20;
	if(!$lmt)
	{
		$lmt=0;
	}

$countnum=0;
while ($lmt < $countness) 
{
	if($countnum < $amount)
		{

//***** only change stuff between here  ********

		      //database variable here.  where the mysql_query part is
			$db = $database 
                          //do this for how every many fields you have
			$cId=mysql_result($db,$lmt,"company_id");
			$name=mysql_result($db,$lmt,"name");

			include('inc/viewCompanyFull.php');


//*************************************

			 ++$countnum; 
		 } 
	++$lmt; 
} 
?>

this is for the paging system

    <?
	// PAGE SPLITTER [page links only]

$i=0;
$numnum = $countness/$amount ;
while ($i < $numnum)
{
	$newnum = $i*$amount ;
	$pagenum = $i+1; 

// on this page i just have the variable with the link
		include('inc/numberPage.php');
		++$i;
	}


?>

this is the inlcude for the paging system. I have this very dynamtic for my whole admin system I use path info when i build sites to create friend urls

<?
$page = explode("&",$_SERVER['REQUEST_URI']); 
$total = count( $page );

if($c == '' )
	{
		$final = $total;
	}
else
	{
		$final = $total -1;
	}

?>
    <td width="8" align="left">
		<a href="<? 

for ($y=0; $y < $final; $y++)
	{
		echo $page[$y]."&amp;" ;
	} 


?>c=<?php echo $newnum; ?>"><? echo "$pagenum"; ?></a> 
    </td>