<?php

if ($_SERVER["REQUEST_METHOD"] == "POST") {

    $u_name = test_input($_POST["name"]);
    $u_email = test_input($_POST["email"]);
    $u_subject = test_input($_POST["subject"]);
    $u_comment = test_input($_POST["comment"]);

}

function test_input($data) {
  $data = trim($data);
  $data = stripslashes($data);
  $data = htmlspecialchars($data);
  return $data;
}

$servername = "sql107.byethost5.com";
$username = "b5_19310328";
$password = "ilovecupcakes";
$dbname = "b5_19310328_cupcakes";

$conn = new mysqli ($servername,$username, $password,$dbname);

    if (empty($u_name) && empty($u_email)){
        die("Please enter name and email");
    }
    if (empty($u_name)){
        die("Please enter your name");
    }
     if (empty($u_email) || !filter_var($u_email, FILTER_VALIDATE_EMAIL)){
        die("Please enter valid email address");
    }

$sql = "INSERT INTO contact (name, email, subject, message)VALUES ('".$u_name."','".$u_email."','".$u_subject."','".$u_message."');";

if ($conn->query ($sql)== true){
     echo "Thank You For Contacting Us <br>";
}
else{
    echo"error". $sql . "<br>". $conn->error;
}

$conn ->close();

?>