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.

Syntax

SELECT * from user WHERE id=$Html_filed_name 

search.html

Html page

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

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

search-db.php

Connect to database

<?php

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);

?>

<?php

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

?>

show-detail.php

Show record

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

<?php
 }
} 
?>
</table>

Prev Tutorial Next Tutorial

Advertisements
Download Projects

Advertisements

Download WhatsApp Status Video

Buy This Ad Space Only $50 per Month, Ad Size 300X250 Contact on: [email protected] WhatsApp no. 8882538826

Google Adsense Advertisements