searchbox

<form action="searched.php" method="post">

<input type="search" name="search">

<input type="submit" name="submit" value="search">

</form>



<?php
$con=mysqli_connect("localhost","root","","oops");
//$id=$_GET['id'];
$search=$_POST['search'];
$query="select * from oop where lname='$search'";
$sql=mysqli_query($con,$query);
while ($row = mysqli_fetch_assoc($sql)) {
        echo $row['fname'];
        echo $row['lname'];
        echo $row['salary'];
    }
//header("Location: view.php");
?>