Jump to content

Search of database returns Error 403 Access Forbidden


djlfreak

Recommended Posts

I'm working on a site in production environment and the following code returns Error 403 - Access Forbidden. I'm using the correct localhost, user and password. What could be causing this? Is it a problem with the database or the php code?

 <?php  //This is only displayed if they have submitted the form  
if ($searching =="yes")  
{  
echo "<h2>Results</h2><p>";   
//If they did not enter a search term we give them an error  
if ($find == "")  {  echo "<p>You forgot to enter a search term"; 
exit;  }  
// Otherwise we connect to our Database  
mysql_connect('localhost', 'root', '') or die(mysql_error()); 
mysql_select_db('dvdff2') or die(mysql_error()); 

// We preform a bit of filtering  
$find = strtoupper($find);  
$find = strip_tags($find);  
$find = trim ($find);   
//Now we search for our search term, in the field the user specified  
$data = mysql_query("SELECT * FROM tbl_product WHERE upper($field) LIKE'%$find%'");   
//And we display the results  while($result = mysql_fetch_array( $data ))  
{  
echo $result['pd_name'];  
echo " ";  echo $result['pd_dir'];  
echo "<br>";  
echo $result['pd_cast'];  
echo "<br>";  
echo "<br>";  }   
//This counts the number or results - and if there wasn't any it gives them a little 
//message explaining that  
$anymatches=mysql_num_rows($data);  
if ($anymatches == 0)  
{  
echo "Sorry, but we can not find an entry to match your query<br><br>";  
}   
//And we remind them what they searched for  
echo "<b>Searched For:</b> " .$find;  
}  
?> 

<h2>Search</h2>  <form name="search" method="post" action="<?=$PHP_SELF?>"> 
Seach for: <input type="text" name="find" /> in  
<Select NAME="field">
<Option VALUE="pd_name">Title</option> 
<Option VALUE="pd_dir">Director</option> 
<Option VALUE="pd_cast">Actors</option>
</Select> 
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" /> 
</form>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.