<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<?php
error_reporting(E_ALL);
$servername = 'xxxxxx';
$username = 'xxxxxx';
$password = 'xxxxxx';
$database = 'xxxxxx';
$Fname = $_POST["first_name"];
$Sname = $_POST["second_name"];
$Addres1 = $_POST["address_line1"];
$Addres2 = $_POST["address_line2"];
$Addres3 = $_POST["address_line3"];
$Addres4 = $_POST["address_line4"];
$DofB = $_POST["date_of_birth"];
$Occup = $_POST["occupation"];
$Phone = $_POST["phone_no"];
$conn = mysqli_connect($servername,$username,$password,$database);
if($conn->connect_error){
echo "MySQL Connection Error";
}
$sql = "INSERT INTO Table_name VALUES('$Fname','$Sname','$Addres1','$Addres2','$Addres3','$Addres4',,'$Occup','$Phone')";
if($conn->query($sql)===TRUE){
echo "<p>Thank you ".$Fname." ".$Sname.", "."Your data has been sent.</p>";
}
else{
echo "<h1>Error Inserting Data</h1>";
}
$conn->close();
?>
</head>
</html>
