<?include "conninfo.php";
$fn = $_POST["fname"];
$sn = $_POST["sname"];
$ff = $_POST["ffood"];
$job = $_POST["job"];

$query="INSERT INTO people(firstname,surname,favfood,job)
VALUES(?,?,?,?)";

$stmt=mysqli_stmt_init($link);
mysqli_stmt_prepare($stmt,$query);

mysqli_stmt_bind_param($stmt,"sssi",$fn,$sn,$ff,$job);
mysqli_stmt_execute($stmt);

echo "Thank you, record has been added";


?>