How can I put search option in my website??

[jalicia18]

(01-13-2011 11:22 AM)justinOrel Wrote:  Hey,

I am new in this section, I want to put a search option in my website,i heard about php scripts could help, but is there anyone who has already that script and share with me please...

Cheers

Table: Members
Fields: id | username | password | completename | country
Records:
1 | test | test123 | Testing | Philippines
2 | shin | shin10 | Shin Shin | India

PHP Script - Search

Quote:<?php
/* include your database connection here */
if($_GET[Search]=="Search")
{
$q = $_GET['q'];
$sql = "SELECT * FROM Members WHERE completename LIKE '%$q%' OR username LIKE '%$q%' ";
$result = mysql_query($sql);
$rows = mysql_num_rows($result);
if($rows<=0)
{
echo "No Result(s) Found";
}
else
{
while($found = mysql_fetch_array($result))
{
echo "Username: " . $found[username] . "<br>";
echo "Password: " . $found[password] . "<br>";
echo "FullName: " . $found[completename] . "<br>";
echo "Country: " . $found[country] . "<br>";
echo "<br>";
}
}
}
?>

Search Term: Shin

Quote:Username: shin
Password: shin10
Fullname: Shin Shin
Country: India

Simple Search Form

Quote:<form method="GET" action="">
Enter any keyword<br>
<input type="text" name="q" value=""><br>
<input type="submit" name="Search" value="Search">
</form>