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

Google Advertisements
Download Projects

Google Adsense Advertisements

Buy 3 Year Old Domain,, @$200

Buy This Ad Space @$50 per Month, Ad Size 300X250 Contact on: WhatsApp no. 8882538826

Yahoo Advertisements