Search Record in database using PHP

Prev Tutorial Next Tutorial

How to Search Record from database using PHP

To search record from database first we take input from Html page, after complete this step write below query.


SELECT * from user WHERE id=$Html_filed_name 


Html page

<form action="" method="post" >

<input type="text" name="valueToSearch" placeholder="Search Record.."></br>
<input type="submit" name="search" value="Search Record..">


Connect to database


include 'db-connect.php';

mysql_select_db("tutorohx_rw", $conncection);

$valueToSearch = $_POST['valueToSearch'];

$sql = "SELECT * FROM user WHERE f_name=$valueToSearch ";
$result = mysql_query($sql, $connection);



if ($result)
  while($row = mysql_fetch_array($result))



Show record

<tr><th>ID</th><th>First Name</th><th>Last Name</th></tr>
<td><?php echo $row["f_name"]; ?></td>
<td><?php echo $row["l_name"]; ?></td>


Prev Tutorial Next Tutorial

Download Projects

Google Adsense Advertisements
Free Classified Site – Bedpage

Yahoo Advertisements