djlfreak Posted May 28, 2010 Share Posted May 28, 2010 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> Link to comment https://forums.phpfreaks.com/topic/203188-search-of-database-returns-error-403-access-forbidden/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.