form:::

<?php
$db ='sanjeev';  $host ='localhost'; $user='root'; $pass='';
$pdo = new PDO('mysql:dbname='.$db.'; host='.$host,$user,$pass);
	if(isset($_POST['register'])){
		extract($_POST);
		$sql ="INSERT INTO form(id, firstname, surname, username, password, email, gender)
		VALUE('', '$firstname','$surname','$username', '$password','$email', '$gender')";
		if ($pdo->query($sql))
			echo "<h4>inserted sucessfully</h4>";
		else
			echo "<h4>not inserted</h4>";


	echo "<h1>'Register here:'</h1>";
}
  ?>

  <form action="" method="POST">
  	<label>Firstname:</label> <input type="text" name="firstname"><br><br>
  	<label>Surname:</label> <input type="text" name="surname"><br><br>
  	<label>Username:</label> <input type="text" name="username"><br><br>
  	<label>Password:</label> <input type="password" name="password"><br><br>
  	<label>Email:</label> <input type="email" name="email"><br><br>
  	<label>Gender:</label>
	<input type="radio" name="gender" value="male">Male
	<input type="radio" name="gender" value="female">Female<br><br>
  	<input type="submit" name="register" value="register">
  </form>



person::::
<?php
	$db ='sanjeev';  $host ='localhost'; $user='root'; $pass='';
	$pdo = new PDO('mysql:dbname='.$db.'; host='.$host,$user,$pass);

	if(isset($_POST['search'])){
		$key=$_POST['key'];
		$result = $pdo->query("SELECT * FROM tbl_person WHERE surname LIKE '%$key%'");
		echo "<ul>";
		foreach ($result as $row) {
			echo '<li>'.$row['firstname'].' '.$row['surname'].' was born in '.$row['birthdate'].' has email id '. $row['email']. '</li>';
		}
			echo '</ul>';
	}
?>

<form action="" method="POST">
	<input type="text" name="key"><br><br>
	<input type="submit" name="search" value="Search">
</form>