Verifies Registered User

Question

Verifies Registered User

Asked 5 years, 3 months ago

Viewed 53 times

0

I’m using this topic as an example of implementation.

It works, gives me the message that there is already a registered email, BUT if I click register it registers anyway, ignoring the message.

I need a way to force the user to type another email again

checkEmail.html

<script language="javascript">
var email = $("#email"); 
    email.blur(function() { 
        $.ajax({ 
            url: 'verificaEmail.php', 
            type: 'POST', 
            data:{"email" : email.val()}, 
            success: function(data) { 
            console.log(data); 
            data = $.parseJSON(data); 
            $("#resposta").text(data.email);
        } 
    }); 
}); 
</script>

verificaEmail.php

<?php
if(isset($_POST['email'])){ 

#Recebe o Email Postado
$emailPostado = $_POST['email'];

$con = mysqli_connect("localhost", "root", "", "outrasintencoes");
$sql = mysqli_query($con, "SELECT * FROM usuarios WHERE email = '{$emailPostado}'") or print mysql_error();

if(mysqli_num_rows($sql)>0) 
    echo json_encode(array('email' => 'Ja existe um usuario cadastrado com este email')); 
else 
    echo json_encode(array('email' => 'Usuário valido.' )); 
}
?>

Tip! It makes it much easier to answer, if you put the reference link just to situate your question, but you also need to put your code to know where the error is

– Cedric S.

2019/03/21 at 12:14

1 answer

Browser other questions tagged php mysql ajax pdo

You are not signed in. Login or sign up in order to post.

by Vinicius De Jesus • **686** points · Answer 1 · 2019-03-21T15:31:19+00:00

As I would:

PHP

#Recebe o Email Postado
$emailPostado = $_POST['email'];

$con = mysqli_connect("localhost", "root", "", "outrasintencoes");
$sql = mysqli_query($con, "SELECT * FROM usuarios WHERE email = '{$emailPostado}'") or print mysql_error();

if(mysqli_num_rows($sql)>0) 
    echo json_encode(array('existe' => 'S', 'email' => '[email protected]')); 
else 
    echo json_encode(array('existe' => 'N')); 
}
?>

JS

<script language="javascript">
var email = $("#email"); 
    email.blur(function() { 
        $.ajax({ 
            url: 'verificaEmail.php', 
            type: 'POST', 
            data:{"email" : email.val()}, 
            success: function(data) { 
            console.log(data); 
            data = $.parseJSON(data); 
            if(data.existe == 'S'){
             //Beleza dx ele fazer o cadastro
            }else{
             //Deixa o campo vermelho, disabilita o submit, avisa que email já está sendo usado
            }
        } 
    }); 
}); 
</script>