Check if email is registered in the BD

Question

Check if email is registered in the BD

Asked 6 years, 10 months ago

Viewed 433 times

3

I’m doing a search in my BD to verify the existence of email, avoiding the registration of the same again, but I’m having problem in return, the script below sends and treats the return.

 if (sender.getFieldName() == 'Email') {
 if (sender.getValue()) {

     var emailExist = false;

     $.ajax({
         type: 'GET',
         url: 'AjaxBasedValidation.php',
         data: {
             checkEmail: sender.getValue()
         },
         async: false, 
         dataType: 'json',           
         success: function(dataResult) {
             emailExist = dataResult;
         }
     });

     editors['Email']
         .setState(emailExist ? 'warning' : 'success')
         .setHint(emailExist ? 'E-mail ' + sender.getValue() + ' já está cadastrado' : null);
 } else {
     editors['Email']
         .setState('normal')
         .setHint(null);
 }

}

The code you check in the BD:

    #Recebe o Email Postado
    $emailPostado = $_GET['checkEmail'];

    #Conecta banco de dados 
    $con = mysqli_connect(".", "", "", "");
    $sql = mysqli_query($con, "SELECT * FROM `usuarios` WHERE `Email` = '{$emailPostado}'") or print mysql_error();

    if($rcQuery == true){
        die('{"dataResult" : 0"}'); 
    } else {
        die('{"dataResult" : 1"}');
    }

All emails I inform the script is accusing that are already registered.

2 answers

2

Count the number of rows returned by the query with mysqli_num_rows(). See that in if the comparison is made with a variable that does not exist in the question code $rcQuery

$result = mysqli_query($con, "SELECT * FROM `usuarios` WHERE `Email` = '{$emailPostado}'");
$retorno['dataResult'] = ($result) ? mysqli_num_rows($result) : 0;
echo json_encode($retorno);

Hello @rray, I edited the question after your reply, thanks for the tip, I will test.

– adventistapr

2017/08/10 at 19:09
@adventistapr remember to convert the return of ajax into json, var retorno = JSON.parse(dataResult), then you can use. console.log(retorno.dataRresult);

– rray

2017/08/10 at 19:13
Hello @rray, could you give me an example of how to convert the return of ajax to json? I did it the way you gave me, but I don’t know if I did it right. I appreciate it.

– adventistapr

2017/08/11 at 10:32
@adventistapr what happened:? gave error?

– rray

2017/08/11 at 12:07
Hello @rray, still accuses that all e-mail are already registered

– adventistapr

2017/08/11 at 13:31
@adventistapr in javascript if you do console.log(dataResult); shows what?

– rray

2017/08/11 at 13:45
Hello @rray, thanks for the help, I redid the search and debugged the script, now everything is correct. Was missing in the return php, thanks for the hints.

– adventistapr

2017/08/11 at 19:44
@adventistapr tranquil ;) q good q hit the code

– rray

2017/08/11 at 19:46

Show 3 more comments

Browser other questions tagged php jquery mysql ajax

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

by Rafael Andrade • **186** points · Answer 1 · 2017-08-15T22:15:00+00:00

I know this question has already been answered, but I would like to leave a more secure solution in the case of sql statements aimed at string queries:

In the case of your select it would be safer to run the email queries as follows:

$result = mysqli_query($con, "SELECT * FROM `usuarios` WHERE `Email` LIKE \"%".$emailPostado."%\"");

Another thing, try to study about the class PDO, because these php functions mysql_* and mysqli_* are obsolete and no longer exist after php version 7.