Newsletter.php

<?php

$email = $_POST['email'];

if(!empty($email))
{

    $host = "localhost";
    $dbUsername = "root";
    $dbPassword = "";
    $dbname = "pronago";

    $conn = new mysqli($host, $dbUsername, $dbPassword, $dbname);
    if (mysqli_connect_error()) {
        die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error());
    }

    else {
        $SELECT = "SELECT email From newsletter Where email = ? Limit 1";
        $INSERT = "INSERT Into newsletter (email) values(?)";

        $stmt = $conn->prepare($SELECT);
        $stmt->bind_param("s", $email);
        $stmt->execute();
        $stmt->bind_result($email);
        $stmt->store_result();
        $stmt->store_result();
        $stmt->fetch();
        $rnum = $stmt->num_rows;
        if ($rnum==0) {
         $stmt->close();
         $stmt = $conn->prepare($INSERT);
         $stmt->bind_param("s", $email);
         $stmt->execute();
         echo "New record inserted sucessfully";
        } else {
         echo "Someone already register using this email";
        }
        $stmt->close();
        $conn->close();
       }

}
else
{
    die();
}

?>