PHP search script problem

[xcali]

Hello dear php members!

I have a problem with a script that searches the database for users.

After user types in the text, the results page doesn't show up for some reason.

 

My current code is:

<?
if ($searching =="yes")
{ echo "<h2>Results</h2><p>";
if ($find == "")
{ echo "<p>You forgot to enter a search term";
exit;
}
mysql_connect("xxxxxxxxx", "xxxxx", "xxxxx") or die(mysql_error());
mysql_select_db("xxxxx") or die(mysql_error());
$find = strtoupper($find);
$find = strip_tags($find);
$find = trim ($find);
$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'");
while($result = mysql_fetch_array( $data ))
{
echo $result['first_name'];
echo " ";
echo $result['last_name'];
echo "<br>";
echo "<br>";
}
$anymatches=mysql_num_rows($data);
if ($anymatches == 0)
{ echo "Sorry, but we can not find an entry to match your query<br><br>"; }
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="first_name">First Name</option>
<Option VALUE="last_name">Last Name</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>

 

 

may someone please guide me what i did wrong?

[DyslexicDog]

Where does the $field variable get set?

[DyslexicDog]

hmmm can't edit....

 

I looked a little deeper at your code. You should turn on your error reporting to start with for testing. Give this code a try see if kicks any errors back.

 

<?php
if ($_POST['searching'] == "yes")
{ echo "<h2>Results</h2><p>";
if ($find == "")
{ echo "<p>You forgot to enter a search term";
exit;
}
mysql_connect("xxxxxxxxx", "xxxxx", "xxxxx") or die(mysql_error());
mysql_select_db("xxxxx") or die(mysql_error());
$find = strtoupper($find);
$find = strip_tags($find);
$find = trim ($find);
$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'");
while($result = mysql_fetch_array( $data ))
{
echo $result['first_name'];
echo " ";
echo $result['last_name'];
echo "<br>";
echo "<br>";
}
$anymatches=mysql_num_rows($data);
if ($anymatches == 0)
{ echo "Sorry, but we can not find an entry to match your query<br><br>"; }
echo "<b>Searched For:</b> " .$find; }
?>



<h2>Search</h2>
<form name="search" method="post" action="<?=$_SERVER['PHP_SELF']?>">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="first_name">First Name</option>
<Option VALUE="last_name">Last Name</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>

[xcali]

thank you very much for your reply

i did run the code

each time i do - it comes back with:

"Results

 

You forgot to enter a search term"

even though i did eneter criteria : /

still wondering what could be wrong with it :s

[benjaminbeazy]

change

if ($find == "")

to

if ($_POST['find'] == "")

[xcali]

uuuu getting somewhere

so now if i dont enter anything it says "You forgot to enter a search term" which is good

but then whatever else i enter it says "Sorry, but we can not find an entry to match your query" - no matter if it does exist in the database or not :/

so far thank you everyone for helping out !

[benjaminbeazy]

try this...

<?php
if ($_POST['searching'] == "yes")
{ echo "<h2>Results</h2><p>";
$find = $_POST['find'];
$field = $_POST['field'];
if ($find == "")
{ echo "<p>You forgot to enter a search term";
exit;
}
mysql_connect("xxxxxxxxx", "xxxxx", "xxxxx") or die(mysql_error());
mysql_select_db("xxxxx") or die(mysql_error());
$find = strtoupper($find);
$find = strip_tags($find);
$find = trim ($find);
$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'");
while($result = mysql_fetch_array( $data ))
{
echo $result['first_name'];
echo " ";
echo $result['last_name'];
echo "<br>";
echo "<br>";
}
$anymatches=mysql_num_rows($data);
if ($anymatches == 0)
{ echo "Sorry, but we can not find an entry to match your query<br><br>"; }
echo "<b>Searched For:</b> " .$find; }
?>



<h2>Search</h2>
<form name="search" method="post" action="<?=$_SERVER['PHP_SELF']?>">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="first_name">First Name</option>
<Option VALUE="last_name">Last Name</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>

 

[xcali]

nice !!!

it has couple of bugs i need to change but it works well !!

 

Thank you very much !!!!!!!

[benjaminbeazy]

no prob. remember whenever you post to a script through a form that you have to declare the variables as $var = $_POST['var'] or something similar