<?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>