$id='';
$name=(empty($_POST['name']))    ? NULL : $_POST['name'];
$lastname=(empty($_POST['lastname']))    ? NULL : $_POST['lastname'];
$phone=(empty($_POST['phone']))    ? NULL : $_POST['phone'];
$address = (empty($_POST['']))    ? NULL : $_POST['address'];
$ip = $_SERVER["REMOTE_ADDR"];
$countryip = getCountryFromIP($ip, " NamE ");
$country = (empty($_POST['country']))    ? NULL : $_POST['country'];
$rdate = $_POST['rdate'];
$bdate = $_POST['bdate'];
$city =(empty( $_POST['city']))    ? NULL : $_POST['city'];
$email=(empty($_POST['email']))    ? NULL : $_POST['email'];
$pwd  =(empty($_POST['password'])) ? NULL : $_POST['password'];
$pwd=sha1($pwd);
if ($email && $conn){
    $sql='SELECT * FROM Usuarios WHERE email=?';
    $stmt = $conn->prepare($sql);
    if($stmt){
        $stmt->bind_param("s",$email);
        $stmt->execute();
        $stmt->store_result();
        $filas=$stmt->num_rows;
        if($filas>0){
            echo "ya hay una cuenta creada con tu email";
        }
        else
        {
            $sql2='INSERT INTO Usuarios(id,name,lastname,email,phone,address,password,IP,countryip,country,rdate,bdate,city) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)';
            $stmt2 = $conn->prepare($sql2);
            if($stmt2){
                $stmt2->bind_param("ssssissssssss",$id,$name,$lastname,$email,$phone,$address,$pwd,$ip,$countryip,$country,$rdate,$bdate,$city);
                if ($stmt2->execute()) {
                    echo $id,$name,$lastname,$email,$phone,$email,$address,$pwd,$ip,$countryip,$country,$rdate,$bdate,$city;
                }
                else{

                    $arrMensaje=array("mensaje"=>"No se cumplieron los criterios o clave duplicada " . $stmt2->error);
                echo $id,$name,$lastname,$email,$phone,$email,$address,$pwd,$ip,$countryip,$country,$rdate,$bdate,$city;
                echo "mm";
                }
            }
            else{
    echo "Falta alguno de los datos del POST o la conexi贸n es nula";
    echo $conn->error;

            }
        }
    }
}
else
{
    echo "Falta alguno de los datos del POST o la conexi贸n es nula";
}