<?php

$name = $_POST['name'];

$email = $_POST['email'];

$newsletter = $_POST['newsletter'];

$gender = $_POST['gender'];



if (!empty($name) || !empty($email) || !empty($newsletter) || !empty($gender)) {

    $host = "localhost";

    $dbUsername = "root";

    $dbPassword = "";

    $dbname = "website";



    $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 register Where email = ? Limit 1";

            $INSERT = "INSERT Into register (name, email, newsletter, gender) values(?, ?, ?, ?)";



            $stmt = $conn->prepare($SELECT);

            $stmt->bind_param("s", $email);

            $stmt->execute();

            $stmt->bind_result($email);

            $stmt->store_result();

            $rnum = $stmt->num_rows;



            if ($rnum==0) {

                $stmt->close();



                $stmt-> $conn->prepare($INSERT);

                $stmt->bind_param("ssis", $name, $email, $newsletter, $gender);

                $stmt->execute();

                echo New "record inserted successfullys";

            } else {

             echo "Allready registerd!"

            }

            $stmt->close();

            $conn->close();

    }



} else{

    echo "All fields are required!";

    die();

}

?>