Pagination not working

[dennismonsewicz]

ok....

 

I have this code:

 

$var = $_POST['q'];
		  $varhighlight = "<span class='yellowhighlight'>" . $var . "</span>";
		  
		  $trimmed = trim($var); //trim whitespace from the stored variables
		  
			/*
			// PHP Code that is used to write to a text file. Is not working right now, so is down at the moment
			$myFile = "results.txt";
			$fh = fopen($myFile, 'a') or die("can't open file");
			$stringData = $trimmed;
			fwrite($fh, $stringData); 
			*/

		// rows to return
		$limit=5; 

		// check for an empty string and display a message.
		if ($trimmed == "")
		  {
		  echo "<p class='contenttext'>Please enter a search...</p>";
		  include "../includes/footer.php";
		  exit;
		  }

		// check for a search parameter
		if (!isset($var))
		  {
		  echo "<p>We dont seem to have a search parameter!</p>";
		  exit;
		  }

		//connect to your database ** EDIT REQUIRED HERE **
		mysql_connect("localhost","DB_username","DB_password"); //(host, username, password)

		//specify database ** EDIT REQUIRED HERE **
		mysql_select_db("DB_name") or die("Unable to select database"); //select which database we're using

		// Build SQL Query  
			$query = "(select * from hrlanding where product like \"%$trimmed%\" or description like \"%$trimmed%\" order by product) union (select * from thlanding where product like \"%$trimmed%\" or description like \"%$trimmed%\" order by product)"; // EDIT HERE and specify your table and field names for the SQL query

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

		// If we have no results, offer a google search as an alternative

		if ($numrows == 0)
		  {
		  echo "<h4 class='contenttext'>Results</h4>";
		  echo "<p class='contenttext'>Sorry, your search: <span class='yellowhighlight'> <b>"" . $trimmed . ""</b> </span> returned zero results</p>";

		/*// google
		 echo "<p><a href=\"http://www.google.com/search?q=" 
		  . $trimmed . "\" target=\"_blank\" title=\"Look up 
		  " . $trimmed . " on Google\">Click here</a> to try the 
		  search on google</p>";*/
		  include "../includes/footer.php";
		  exit;
		  }

		// next determine if s has been passed to script, if not use 0
		  if (empty($s)) {
		  $s=0;
		  }

		// get results
		  $query .= " limit $s,$limit";
		  $result = mysql_query($query) or die("Couldn't execute query");

		// display what the person searched for
		echo "<p class='contenttext'>You searched for: <b>"" . $varhighlight . ""</b></p>";

		// begin to show results set
		echo "<p class='contenttext'>Results (Click a product below to view more information) <br /><br />";
		$count = 1 + $s ;

		// now you can display the results returned
		  while ($row= mysql_fetch_array($result)) {
		  $title = $row["product"];
		  $rowid = $row["rowid"];
		  $company = $row["company"];
		  $description = $row["description"];
		  $web = $row["web"];

		  echo "$count.) <a href='$PHP_SELF/$company/". $company ."dbcase.php?action=view&id=$rowid'>$title</a><br />";
		  echo "Web Address: <a href='$web' target='_blank'>". $web ."</a><br />";
		  echo "Description: " . $description . "<br />";
		  echo "Company: " . $company . "<br /><br />";
		  $count++ ;
		  }

		$currPage = (($s/$limit) + 1);

		//break before paging
		  echo "<br />";

		  // next we need to do the links to other results
		  if ($s>=1) { // bypass PREV link if s is 0
		  $prevs=($s-$limit);
		  print " <a href=\"$PHP_SELF?s=$prevs&q=$var\"><< 
		  Prev 10</a>&nbsp ";
		  }

		// calculate number of pages needing links
		  $pages=intval($numrows/$limit);

		// $pages now contains int of pages needed unless there is a remainder from division

		  if ($numrows%$limit) {
		  // has remainder so add one page
		  $pages++;
		  }

		// check to see if last page
		  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

		  // not last page so give NEXT link
		  $news = $s + $limit;

		  echo " <a href=\"$_SERVER[$PHP_SELF]?s=". $news . "&q=" . $trimmed . "\">Next 10 >></a>";
		  }

		$a = $s + ($limit) ;
		  if ($a > $numrows) { $a = $numrows ; }
		  $b = $s + 1 ;
		  echo "<p class='contenttext'>Showing results $b to $a of $numrows</p>";

 

It displays the next page link and it is linked correctly but when you click on next it reloads the page and displays please enter a search....

 

Any ideas on how to get it to display the rest of the results?

[JacobYaYa]

print " <a href=\"$PHP_SELF?s=$prevs&q=$var\"><< 

 

$_POST['q] is not being passed to the other pages. You need to change your search form to method="GET" and the references to $_POST['q'] to $_GET['q'].

[dennismonsewicz]

ok now it refreshes the page but does not display the next set of results....

 

any other ideas?

[dennismonsewicz]

anyone else got any ideas?