PHPBuilder - Search Form in php



RSS Twitter
Snippets Other

Search Form in php

by: satish
|
October 2, 2009

Version: search1.0

Type: Full Script

Category: Other

License: GNU General Public License

Description: This is a search form in php.It searches the data from mysql.



<html>
    <head>
        <title>Search Test</title>
    </head>
    <body topmargin="0" leftmargin="0">
        <form action="" method="post">
            Search Term <input type="text" name="search"><br />
            <input type="submit" value="Search" name="Search">
        </form>
    </body>
</html>
<?php
if($_POST["search"]=="")
{
echo "please enter some text for search!";
}
else
{
$q=$_POST["search"];


$con = mysql_connect('localhost', 'root', '');
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("key", $con);

$sql="SELECT * FROM contact WHERE fname like '".$q."%'";

$result = mysql_query($sql);
if(!mysql_num_rows($result)>0)
{
echo "Not found!";

}
else
{
echo "<table border='1'>
<tr>
<th>Firstname</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['fname'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
}}

?>

Comment and Contribute

Your comment has been submitted and is pending approval.

Author:
satish

Comment:



Comment:

(Maximum characters: 1200). You have characters left.