[RESOLVED] reset a search form

jrough

How do you sense a change in a search form?
I have my posted columns that can be searched on.
I have 6 input boxes to search on, one is a required field.
I only display 100 records at a time so a session var holds the number of records for the current sql search. I don't have user sessions just that session var for the total number of records in the sql.

And this code finds the current page.

if( $page=='' ){
      $nRecs=nrows($sql);
        echo $nRecs ." number of Recs";
        $_SESSION['recs']=$nRecs;
       $page =1;

   $startPage=100;
}else{
    $startPage=$page *100;
}

$sqlLimit="LIMIT $startPage,100  ";

$sql.=  $sqlOrder." ". $sqlLimit ;

I have this $page var at the beginning of my function to see whether the page was requrested by the user or not.
$page=$_GET['page'];

How do I sense a change in the search box from the user? Say the user ends on page 12 from search 1 . If I submit a new search and decide I'm done editing page 12 in the first search. What currently happens is I have to delete the page=12 name/value pair in the get url.
Even then then it doesn't pull the new query properly. It is still stuck on the old query. How do I sense the search box values changed so I can pull a new query?
I don't want a reset button. Is this php or Javascript?
thanks,
So I need something like if the user changes the search reset the page to ' '.

thanks,

dagon

there seems no reason to use a session(this is causing the issue) simply add the page number to the url

search.php?page=1
search.php?page=2

etc. use the page number to tell the mysql page the start and end page.

that's how its usually done, look at the google results links. (google uses start=* same idea)

jrough

I'm sorry I left this part out,
after the do while that displays the sql I do have a page= in the url

$noPages=$SESSION['recs']/2;
echo $SESSION['recs'];
for ( $p=1;$p<=$noPages;$p++ ) {

echo " <a href='$me?page=$p'>$p</a>\n";

}

I need the session var to store the total number of records to do the division for the
SQL LIMIT . So the results change for each search with different criteria so I have to store the total number somewhere then this calculation figures out where to go when the user clicks the page number at the bottom of the results. it starts on 1 if no page is selected. But as i say, when a new search criteria is posted it doesn't reset. THANKS,

dagon

you don't need the session, you can get the total on each query

dagon



	$limit_start= ($page_num * $page_limit) - $page_limit;

	$query="SELECT SQL_CALC_FOUND_ROWS foo.* from foo
WHERE *YOUR SEARCH*
		LIMIT $limit_start,$page_limit ";

	$result= mysql_query('SELECT FOUND_ROWS( )');
	$total= mysql_fetch_row($result);

//get the table rows as normal

FOUND_ROWS()

jrough

🙂Thanks it looks easier already. I'm confused on 2 things.

Where do I pull the sql query?

I did it here with the limit in the first $result.

Then as I understand it the 2nd result is without the limit?

The other question is the $sql query gets a syntax error because it has a minus sign displaying at the end of the query where the LIMIT should be
ie, LIMIT -100,100 instead of LIMIT 100,100.
How to get rid of the minus sign? Shouldn't the limit_start calculation expand out and also if the page is 1, and the page_limit is 100, multipled is 100 and subtracted from 100 is 0 so I'm not sure if you meant total pages there instead of the selected page? But if so then the sql limit is pulled before the total number of pages gets calculated?

thank you so much.

 $page_limit=100;
   $page=$_GET['page'];
   if($_POST['search_bu'] && $page==''  ){$page=1;}

$sql="SELECT SQL_CALC_FOUND_ROWS xxxxxxx ";
$sqlOrder="ORDER BY $order ";
$sql.=$sqlWhere;
$limit_start= ($page * $page_limit) -$page_limit;

$sqlLimit= "LIMIT $limit_start,$page_limit ";
$sql.=  $sqlOrder ." " .$sqlLimit ;

   $result= mysql_query($sql);

$result= mysql_query('SELECT FOUND_ROWS()');
$noPages= mysql_num_rows($result);

   DO WHILE LOOP  TO DISPLAY DATA

for ( $p=1;$p<=$noPages;$p++ ) {

echo " <a href='$me?page=$p'>$p</a>\n";
}

jrough

thanks for your answer. I got it.