<?php

$host= 'localhost';
$user= 'root';
$pass= '';
$db= 'subscribedb';

$name = $_POST['name'];
$email = $_POST['email'];

$con=mysqli_connect($host,$user,$pass,$db) ;
if ($con) {
    /*echo 'Connected Successfully to subscribedb database';*/

    $sql = "INSERT INTO userlist (NameSurname, Email) values ('$name', '$email')";

    /*$queryemail = mysqli_query ("SELECT * FROM userlist WHERE Email='$email'");*/

    $queryemail = "Select * from userlist where Email = '$email';";
    $resultemail = mysqli_query($queryemail);

    if (mysqli_num_rows ($resultemail) > 0 ){
        echo 'Email address already exits';
    } elseif (mysqli_query($con,$sql)) {
        echo "New Record created successfully";
    }
}