Search code redirect when nothing entered

[87dave87]

Hi,

I have written a fairly simple search script for a website I am working on, the search box works great, it shows the results and if it cannot find the text that is entered it redirects to a page telling the user that it cannot find information.

Now im stuck with the code to write incase the user doesn't enter anything into the search box.

This is my code for the current redirect: -

<?
$database="database";  

mysql_connect ("localhost", "user", "pass"); 
@mysql_select_db($database) or die( "Unable to select database"); 
$sql = "select emulator, version, os, platform, details from windows_atari2600 where emulator LIKE '%".mysql_real_escape_string($_POST["emusearch"])."%' OR platform LIKE '%".mysql_real_escape_string($_POST["emusearch"])."%' order by platform asc, emulator asc"; 
$result = mysql_query($sql); 
$num_rows = mysql_num_rows($result); 
if($num_rows < 1) 
{ 
    echo "<meta http-equiv='refresh' content='0; URL=/searchnoresults.php'>"; 
} 
else 
if(

   {
include ('http://www.emulators.cc/includes/head.php'); 
?> 

Im planning on putting the redirect code for when nothing is entered into the last 'If(' part.

Any help would be appreciated.

Thanks in advance. 🙂

[Piranha]

You should place that first, if they haven't entered anything it is better that nothing happens. So first check if there is anything in $_POST["emusearch"] and if there is then do what you do now. If it is empty then redirect.

[87dave87]

So this: -

@mysql_select_db($database) or die( "Unable to select database"); 
$sql = "select emulator, version, os, platform, details from windows_atari2600 where emulator LIKE '%".mysql_real_escape_string($_POST["emusearch"])."%' OR platform LIKE '%".mysql_real_escape_string($_POST["emusearch"])."%' order by platform asc, emulator asc"; 
if($emusearch ="")
{
    echo "<meta http-equiv='refresh' content='0; URL=/nothing_entered_into_searchbox'>"; 
}	
$result = mysql_query($sql); 
$num_rows = mysql_num_rows($result); 
if($num_rows < 1) 
{ 
    echo "<meta http-equiv='refresh' content='0; URL=/searchnoresults.php'>"; 
} 
else 
if(

   {
include ('http://www.emulators.cc/includes/head.php'); 
?> 

?

[Piranha]

Almost like I would do it. Just a few small changes:

@mysql_select_db($database) or die( "Unable to select database"); // Will you use that connection on the page you reconnect to? If not then place the if-statement before this row
if(!empty($_POST['emusearch']) // Changed to $_POST and empty() instead.
{
    echo "<meta http-equiv='refresh' content='0; URL=/nothing_entered_into_searchbox'>"; 
}	
else  // Without the else everything will be done even if there is no need for it
{
$sql = "select emulator, version, os, platform, details from windows_atari2600 where emulator LIKE '%".mysql_real_escape_string($_POST["emusearch"])."%' OR platform LIKE '%".mysql_real_escape_string($_POST["emusearch"])."%' order by platform asc, emulator asc"; // This could be after the if statement, there is no reason to so this string if you are not gonna use it.

$result = mysql_query($sql); 
$num_rows = mysql_num_rows($result); 
if($num_rows < 1) 
{ 
    echo "<meta http-equiv='refresh' content='0; URL=/searchnoresults.php'>"; 
} 
else 
if(

   {
include ('http://www.emulators.cc/includes/head.php'); 
}
?>