Search From MySQL Database in PHP

When User search form Database table

index.html

 <!DOCTYPE html>
<html lang="en">
<head>
  <title>Search Example</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/css/bootstrap.min.css">
</head>
<body>
<h2>Search Name :-</h2>
<div class="container">
  <form class="form-inline" method="post" action="search.php">
    <input type="text" name="firstname" class="form-control" placeholder="Firstname">
    <button type="submit" name="save" class="btn btn-primary">Search</button>
  </form>
</div>
</body>
</html>

search.php

 <?php
error_reporting(0);
$conn = mysqli_connect("localhost","root","","portal");
if(count($_POST)>0) {
$firstname=$_POST[firstname];
$result = mysqli_query($conn,"SELECT * FROM student where firstname='$firstname' ");
}
?>
<!DOCTYPE html>
<html>
<head>
<title> Retrive data</title>
<style>
table, th, td {
    border: 1px solid black;
}
</style>
</head>
<body>
<h2>User Name From Database</h2>
<table>
<tr>
<td>First_Name</td>
<td>Last Name</td>
<td>Email</td>


</tr>
<?php
$i=0;
while($row = mysqli_fetch_array($result)) {
?>
<tr>
<td><?php echo $row["firstname"]; ?></td>
<td><?php echo $row["lastname"]; ?></td>
<td><?php echo $row["email"]; ?></td>

</tr>
<?php
$i++;
}
?>
</table>
</body>
</html>

Output:-

This is my Database Table.

I am Searching First Name in Search box.

Result Display of Details..

Download Source code

Click Download

Next Topic

← prev next →

MYSQL Database

PHP Programs

PHP Projects

Search From MySQL Database in PHP

index.html

search.php

Download Source code