Search form redisplay

[jemq]

I have a simple search form. it displays the results fine.
What I want to do is to redisplay the search form before displaying the results so the user can search again and again.

The code is as follows.

<?php
// Include our login information
include('db_login.php');
// Connect
$connection = mysql_connect($db_host, $db_username, $db_password);
if (!$connection){
die ("Could not connect to the database: <br />". mysql_error( ));
}

// Select the database
$db_select=mysql_select_db($db_database);
if (!$db_select) {
die ("Could not select the database: <br />". mysql_error( ));
}

$search = htmlentities($_POST["search"]);
$apcode = htmlentities($_POST["apcode"]);
$self = htmlentities($_SERVER['PHP_SELF']);
if ($search === '' ){
	echo ('<form action="'.$self.'" method="POST"> <label>Search Value  <input type="text" 								
			name="search" / </label> <br>
			<input type="submit" name="description" value="Search Text" /> <br> 
			</form>');
	}
else {
	if ($_POST['description']) {
		echo "Your search text is: <strong>$search</string><br>";
		// Assign the query
			$srch="%".$search."%"; 
			$query = "SELECT * FROM allpet_twb WHERE description LIKE '$srch' OR allpetcode LIKE '$srch'";
		// Execute the query
			$result = mysql_query( $query );
			if (!$result){
				die ("Could not query the database: <br />". mysql_error( ));
				}
			}
	if ($_POST['apcode']) {
		echo "Your Product Code text is: <strong>$search</string><br>";
		// Assign the query
			$srch="%".$search."%"; 
			$query = "SELECT * FROM allpet_twb WHERE allpetcode LIKE '$srch'";
		// Execute the query
			$result = mysql_query( $query );
			if (!$result){
				die ("Could not query the database: <br />". mysql_error( ));
				}
			}
		}

		// Setup the Table
			echo "<table width='0' border='1' cellpadding='1'>";
			echo "<tr>";
				echo "<th scope='col'>TWB Code</th>";
				echo "<th scope='col'>Allpet Code</th>";
				echo "<th scope='col'>Description</th>";
				echo "<th scope='col'>Cost Ex $</th>";
				echo "<th scope='col'>Cost Inc $</th>";
				echo "<th scope='col'>Retail $</th>";
				echo "<th scope='col'>Wholesale $</th>";
				echo "<th scope='col'>PRRR $</th>";
			echo "</tr>";		
		// Fetch and display the results
			while ($result_row = mysql_fetch_row(($result))){
					echo"<tr>";
					    DISPLAY RESULTS HERE
				  echo"</tr>";
					}

echo "</table>";
?>

[leatherback]

ehm.. What is your question?

If you just want to display the form..
echo $form;
would work if you get your form in $form. Or else you could create a function that will spit out the form.

[jemq]

Sorry, did not explain that very well.

What happens is that the user types in some text and presses the SUBMIT button.
A new page comes up displaying the results of the search. However, there is no longer the text box and SUBMIT button. So the user has to press BACK and do another search. What I want is when the user presses SUBMIT. The code will display the text area and SUBMIT button and also the results. That way the user can search again and again from the one page.

Thanks

[igorlopez]

Well basically you answered your own question

A new page comes up displaying the results of the search.

Why do you need to put the result on a new page when you most likely could keep it all on the same page.

[jemq]

I do not put the results on a new page. The code above automatically creates a new page upon displaying its results. I cannot tell where it does this and I do not know the answer to the question otherwise I would not have posted the question in the first place.

I know I am new at this and I may seem stupid but your answers are not helping me. I do not require a complete coding solution but some suggestive feedback instead of negative feedback would be welcome.

[igorlopez]

Please, this was not meant as a negative feedback.
As far as the code you posted i did not go through it. Too much to read and not knowing the structure, i.e. is this the php page used to produce the web page or is it just code in the middle or what....

Anyway constructive feedback is this:
It appears that you are only populating the form when search is empty

if ($search === '' ){
echo ('<form action="'.$self.'" method="POST"> <label>Search Value <input type="text"
name="search" / </label> <br>
<input type="submit" name="description" value="Search Text" /> <br>
</form>');
}

which will explain why the user needs to back to an empty page in order to press submit again.
Hence my previous comment, the result is put up a newly designed page without the submit button is still valid.

Maybe a solution is just to remove the check for an empty search like this (note not tested on server, just copy and paste)

echo ('<form action="'.$self.'" method="POST"> <label>Search Value <input type="text"
name="search" / </label> <br>
<input type="submit" name="description" value="Search Text" /> <br>
</form>');

if ($_POST['description']) {
	echo "Your search text is: <strong>$search</string><br>";
	// Assign the query
	$srch="%".$search."%";
	$query = "SELECT * FROM allpet_twb WHERE description LIKE '$srch' OR allpetcode LIKE '$srch'";
	// Execute the query
	$result = mysql_query( $query );
	if (!$result){
		die ("Could not query the database: <br />". mysql_error( ));
	}
}
if ($_POST['apcode']) {
	echo "Your Product Code text is: <strong>$search</string><br>";
	// Assign the query
	$srch="%".$search."%";
	$query = "SELECT * FROM allpet_twb WHERE allpetcode LIKE '$srch'";
	// Execute the query
	$result = mysql_query( $query );
	if (!$result){
		die ("Could not query the database: <br />". mysql_error( ));
	}
}