Jump to content

[SOLVED] PHP Search Function Help


ajg199

Recommended Posts

Keep getting the error:

 

Parse error: syntax error, unexpected T_VARIABLE in /var/www/html/sship/search.php on line 21

 

Thank you for any help!

 

AJ

<html>
<h2>Search</h2>
<form method="post" action="<?php echo $PHP_SELF; ?>">
Search for: <input type="text" name="formfind" /> in
<Select NAME="formfield">
<Option VALUE="SCHOL_NAME">Name</option>
<Option VALUE="UWM_SCHOOL">School</option>
<Option VALUE="AMT">Amount</option>
<Option VALUE="REQ">Requirements</option>
<Option VALUE="DLINE">Deadline</option>
<Option VALUE="CONTACT_NAME">Contact</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
</html>

<?
require_once ('mysql_connect.php');
//This is only displayed if they have submitted the form
$find = (_$POST['formfield']);
if ((_POST['$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;
}


// 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 sship WHERE upper($field) LIKE '%$find%'");

//And we display the results
while($result = mysql_fetch_array( $data, MYSQL_ASSOC ))
{
echo $result['SCHOL_NAME '];
echo " ";
echo $result['UWM_SCHOOL'];
echo "<br>";
echo $result['AMT'];
echo "<br>";
echo $result['REQ'];
echo "<br>";
echo $result['DLINE'];
echo "<br>";
echo $result['CONTACT_NAME'];
echo "<br>";
echo $result['CONTACT_PH'];
echo "<br>";
echo $result['CONTACT_EMAIL'];
echo "<br>";
echo $result['WEBSITE'];
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;
}
?>

 

EDITED BY WILDTEEN88: Please use code tags (


) when posting code

 

Link to comment
https://forums.phpfreaks.com/topic/156008-solved-php-search-function-help/
Share on other sites

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.