Help on what should be a simple thing

sirbeavis

Im having problems with the code below, I can get the page to post limited number of results, I can even get it to find all the results for my search, but when I hit next it states "no records found"...

How does one make a search form that will run a script, this script must show the results of the form in ID desc order with a limit of 10 per page and a next and back feature..

Copy of my Search page form post

This is the PHP im using to post the results (it was the one that worked best so far, from all the ones i have found here.)

<?
$this_document = $_SERVER['SCRIPT_NAME'];

$db_addr = 'localhost'; // address of MySQL server.
$db_user = ''; // Username to access server.
$db_pass = ''; // Password access server.
$db_name = '***'; // Name of database to connect to.
$connect = @mysql_connect("$db_addr", "$db_user", "$db_pass");

$page = $GET['page'];
$limit = $GET['limit'];

if (!($connect)) // If no connect, error and exit().
{
echo("Unable to connect to the database server.");
exit();
}

if (!(@mysql_select_db($db_name))) // If can't connect to database, error and exit().
{
echo("Unable to locate the $db_name database.");
exit();
}

if (!($limit)){
$limit = 10; // Default results per-page.
}

if ( !$page or $page < 0 ) {
$page = 0; // Default page value.
}

$numresults = mysql_query("SELECT * from ### WHERE cs_positionstate LIKE '$cs_positionstate' AND cs_fullpart LIKE '$cs_fullpart' AND (cs_status = '$cs_status' or cs_status = 'both')"); // the query.

$numrows = mysql_num_rows($numresults); // Number of rows returned from above query.

if ($numrows == 0){
echo("No results found matching your query"); // modify the "Not Found" error for your needs.
exit();
}

$pages = intval($numrows/$limit); // Number of results pages.
// $pages now contains int of pages, unless there is a remainder from division.

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

$current = intval($page/$limit) + 1; // Current page number.

if (($pages < 1)) {
$total = 1; // If $pages is less than one, total pages is 1.
} else {
$total = $pages; // Else total pages is $pages value.
}

$first = $page + 1; // The first result.

if (!((($page + $limit) / $limit) >= $pages) && $pages != 1) {
$last = $page + $limit; //If not last results page, last result equals $page plus $limit.
} else {
$last = $numrows; // If last results page, last result equals total number of results.
}
//escape from PHP mode.
?>

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table width="100%" border="0" cellpadding="2">

<tr>
<td width="323" align="left">Results
per-page: <a href="<?=$this_document?>?query=<?=$query?>&page=<?=$page?>&limit=5">5</a>
| <a href="<?=$this_document?>?query=<?=$query?>&page=<?=$page?>&limit=10">10</a>
| <a href="<?=$this_document?>?query=<?=$query?>&page=<?=$page?>&limit=20">20</a>
| <a href="<?=$this_document?>?query=<?=$query?>&page=<?=$page?>&limit=50">50</a> 
</td>
<td colspan="2" align="left"> </td>
</tr>
<tr>
<td align="left">Showing
Results 
<?=$first?>
 - 
<?=$last?>
 of 
<?=$numrows?>
</td>
<td width="324" align="left">Page

<?=$current?>
 of 
<?=$total?>
</td>
<td width="324" align="left"> </td>
</tr>
<tr>
<td colspan="3" align="left" valign="top"> 
<div align="left"></div>
 
<?

//$limitnum = 15;
if ($page != 0) { // Don't show back link if current page is first page.
$back_page = $page - $limit;
echo("<a href=\"$this_document?query=$query&page=$back_page&limit=$limit\">back</a>\n");
}

for ($i=1; $i <= $pages; $i++) // loop through each page and give link to it.
{
$ppage = $limit*($i - 1);
if ($ppage == $page) {
echo("$i\n");
} // If current page don't give link, just text.
//elseif ($ppage < $page - $limitnum || $ppage > $page + $limitnum){}
else {
echo("<a href=\"$this_document?query=$query&page=$ppage&limit=$limit\">$i</a>\n");
}
}

if (!((($page+$limit) / $limit) >= $pages) &&
$pages != 1) { // If last page don't give next link.
$next_page = $page + $limit;
echo(" <a href=\"$this_document?query=$query&page=$next_page&limit=$limit\">next</a>");
}
?>
</td>
</tr>
<tr>
<td colspan="3" align="left"> </td>
</tr>
<tr>
<td colspan="3" align="left">
<?
//Go back into PHP mode.
// Now we can display results

$results = mysql_query("SELECT * from ### WHERE cs_positionstate LIKE '$cs_positionstate' AND cs_fullpart LIKE '$cs_fullpart' AND (cs_status = '$cs_status' or cs_status = 'both') ORDER BY cs_id DESC LIMIT $page, $limit");
echo "<TR bgcolor=\"#4f5c38\">
<TD align=\"center\">Domain Name</TD>
<TD align=\"center\">Date Submitted</TD>
<TD align=\"center\">Asking Price</TD></TR>\n";

for($i = 0; $i < $limit; $i++){
for ($count = 1; $row = mysql_fetch_assoc ($results);++$count) {
if ($count & 1) {
$color = "#9aa486";
$font = "white";
} else {
$color = "#c8cfc6";
$font = "black";
}
$printthis = "<tr>
<td bgcolor=\"$color\">$row[cs_id]</td>
<td bgcolor=\"$color\">$row[cs_post]</td>
<td bgcolor=\"$color\">$row[cs_jobtitle]</td>
</tr>";
print $printthis;
}
}
?>
</td>
</tr>
</table>
</body>
</html>

ScubaKing22

It sounds like your after pagination. Try searching this forum, as there are probably hundreds of posts about it. I've also included a pagination class I found on the internet that should help you out considerably.

sirbeavis

All the scripts and help on this page dont work, ive been searching all over even the file you posted does not work for me, I think it has somthing to do with the form posting and the script not remembering what was posted on the first page...

ScubaKing22

The code that I use I found on these forums. It was created by Batman:

// limit value for number of records to be shown per page 
// query database to find total number of records to display 
$limit = 5;  

$query_count = "select * from ".$prefix."store_inventory where (description like '%$search%' or title like '%$search%')";  

$result_count = mysql_query($query_count);  

$totalrows = mysql_num_rows($result_count);  

if(empty($page))  

$page = 1;  

$limitvalue = $page * $limit - ($limit);  

$query = "select * from ".$prefix."store_inventory where (description like '%$search%' or title like '%$search%') LIMIT $limitvalue, $limit ";  

$result = mysql_query($query) or die("Error: " . mysql_error());  

$count_result = mysql_num_rows($result);  

// Display links at the top to indicate current page and number of pages displayed 
$numofpages = ceil($totalrows / $limit); 
echo"<br><p><b>$totalrows</b> result(s) for: \"$search\"</p>"; 
$from=$limit*$page-$limit+1; 
$to=$from + $count_result-1; 

// start 123 next>> table 
echo "<table align=\"center\" width=\"90%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"> 
            <tr><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"left\">";if($numofpages>1){echo"Showing: $from - $to</td><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"right\"><b>Go to page:</b> ";}  

// display previous link if page is not 1 
if($page != 1){  

$pageprev = $page - 1;  

echo("<a href=\"$PHP_SELF?page=$pageprev&search=$search\"><< PREV</a>&nbsp;");  

}  

// display page nos if not 1 
for($i = 1; $i <= $numofpages; $i++){  

if($numofpages>1){ 
if($i == $page)  

echo("&nbsp;".$i."&nbsp;");  

else 
echo("&nbsp;<a href=\"$PHP_SELF?page=$i&search=$search\">$i</a>&nbsp;");  

}} 

// display next page link if there is more than one 
if(($totalrows - ($limit * $page)) > 0){  

$pagenext = $page + 1;  

echo("<a href=\"$PHP_SELF?page=$pagenext&search=$search\">NEXT >></a>");  

} 
// end 123 next>> table 
echo"</td></tr></table><br>";

sirbeavis

His is not working the first 5 records show with a statement

"400 result(s) for:"

If I hit next or back it will say 0 results... Im sure it has somthing to do with the form information being lost on the clicks (when I click on next, the form data is lost)

sirbeavis

I used the batman script with the search code hard coded in for example $state=OR and it works fine...