PHP SQL Search
PHP SQL Search is used to return the records details from the table based on
the search condition. The PHP SQL Search allows the user to put his search
text and choose a option from select box. The click on search button helps
the user to show the records details based on search text put by the user.
Understand with Example
This example illustrates how to create a search application in the PHP. To
access the records from table 'user' in the database we create a table user. The
select statement fetches the records from table 'user'.
Table: user
In this example we create a text box where user put his/her search term and
choose a option from select box. When user submit his/her query then we select
all list from database table where the query stream involve.
$find = strtoupper($find): The PHP strtoupper ( ) Function
convert the search text into upper case.
$find = strip_tags($find) : The string functions is used to
manipulate strings.
$find = trim ($find) : The PHP trim() function returns
a string without leading and trailing spaces.
Source Code of searchForm.php
<h2>Search Form</h2>
<form name="search" method="post" action="<?=$PHP_SELF?>">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="fname">First Name</option>
<Option VALUE="lname">Last Name</option>
<Option VALUE="designation">Designation</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
<?php
if ($searching =="yes"){
echo "<h3>Search Results</h3><p>";
if ($find == ""){
echo "<p>Please Enter a search term";
exit;
}
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());
$find = strtoupper($find);
$find = strip_tags($find);
$find = trim ($find);
$query = mysql_query("SELECT * FROM user WHERE upper($field) LIKE'%$find%'");
while($result = mysql_fetch_array($query)){
echo $result['fname'];
echo " ";
echo $result['lname'];
echo "<br>";
echo $result['designation'];
echo "<br>";
echo "<br>";
}
$matches=mysql_num_rows($query);
if ($matches == 0){
echo "Sorry, we can not find an entry to match your query<br><br>";
}
echo "<b>Searched For:</b> " .$find;
}
?>
|
Download Source Code
Output:
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
