<?php
session_start();
$host="localhost";
$username="root";
$password="";
$db_name="usertest";
$tbl_name="users";
mysqli_connect($host,$username,$password,$db_name)or die("cannot connect");
$email=$_POST['email'];
$password=$_POST['password'];
if (filter_var($email, FILTER_VALIDATE_EMAIL)){
$sql="select 'Email' from 'USER' where 'Email'='$email'";
$result=mysqli_query($sql);
$count=mysqli_num_rows($result);
if($count>0){
echo ("lalalalalala");
}else{
$sql="INSERT INTO $tbl_name ('Email','PASS')VALUES('$email','$password')";
$result=mysqli_query($sql);
if($result){
header("location:header.php");
}else{
echo "ERROR MySql";
}
mysqli_close();
}
}else{
echo"lalalalalalalaaa2";
}
?>