<?php
require 'conn.php';

//get values
$vorname = $_POST["vorname"];
$nachname = $_POST["nachname"];
$email = $_POST["email"];


//insert data into mysql
$sql="INSERT INTO testtbl(vorname, nachname, email)VALUES('$vorname', '$nachname', '$email')";


if (mysqli_query($conn, $sql)){
echo "New record created";

//get values for the email headers
$empfaenger = "info@centifa.ch";
$betreff = "die Mail-Funktion";
$from = "From: $vorname $nachname < $email >";
$header = "$from\r\nReply-to: $email";
$text = "eine Kontaktanfrage ist gerade eingegangen";

//send the Email
mail($empfaenger, $betreff, $text, $header);

sleep(0);
header('location: http://centifa.cqt24.ch/db/');
exit;
}
else{
echo "error";
}

$conn->close();

?>