Untitled

<html>
<body>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "data";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$name = $_POST["studentname"];
$fname = $_POST["fathername"];
$pdadd = $_POST["paddress"];
$psadd = $_POST["personaladdress"];
$sex = $_POST["sex"];
$city = $_POST["city"];
$course = $_POST["course"];
$district = $_POST["district"];
$state = $_POST["state"];
$pincode = $_POST["pincode"];
$emailid = $_POST["emailid"];
$dob = $_POST["dob"];
$mobileno = $_POST["mobileno"];

$sql = "INSERT INTO student_form (name, father_name, postal_address, personal_address, sex, city, course, district, state, pincode, email_id, dob, mobile_no)
VALUES ('$name','$fname', '$pdadd', '$psadd', '$sex', '$city', '$course', '$district', '$state', '$pincode', '$emailid', '$dob', '$mobileno')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

?>

</body>
</html>