Jquery validation plugin - check if email exists

Question

I'm trying to check on email field blur, if the email already exists in db. My code is now:

<script type="text/javascript">
    $(document).ready(function () {
        // Validation
        $("#soutez").validate({
            rules: {
                   email: {
                    required: true,
                    email: true,
                    remote: "check-email.php",
                },

            },
            messages:{
                email:'Email address exists.'
            },
            onkeyup: false,
            onblur: true,
      });

     });
</script>

And the php code is

$email= $_GET['email'];
echo $email;
$path = $_SERVER['DOCUMENT_ROOT'];

include_once $path . '/wp-config.php';
include_once $path . '/wp-load.php';
include_once $path . '/wp-includes/wp-db.php';
include_once $path . '/wp-includes/pluggable.php';
global $wpdb;

$email_exists = $wpdb->get_row('SELECT COUNT(*) as count from reg_form_new WHERE email = "'.$email.'"');

if ( $email_exists->count == 0 ) { echo 'true'; } else { echo 'false'; }

exit; }

The php code returns true/false correctly, but for some reason it doesn't work with the jQuery script. Anyone can tell me what I'm doing wrong? Thanks

is not that easy because e.g [email protected], [email protected], [email protected], [email protected], etc... are all the same email — A. Wolff
– A. Wolff, Commented Jun 18, 2013 at 22:25
Wouldn't the echo $email line make the return "<email address>true" instead of just "true" — Joe
– Joe, Commented Jun 18, 2013 at 22:46

Ryley · Accepted Answer · 2013-06-19 15:32:00Z

4

You have to echo exactly the string 'true' and nothing else if you want it to be allowed through. Anything else ('false',null,undefined, or any string) will be interpreted as invalid and if there is a string, that string will be displayed.

So check carefully that your php script is printing out only 'true' or 'false' for now. The script as you've shown it prints the email followed by 'true' or 'false'. This will always be interpreted as false.

Read the documentation of the remote method:

The response is evaluated as JSON and must be true for valid elements, and can be any false, undefined or null for invalid elements, using the default message; or a string, eg. "That name is already taken, try peter123 instead" to display as the error message.

Use Firebug or Chrome Inspector to verify that your response is correct.

answered Jun 19, 2013 at 15:32

Ryley

21.3k2 gold badges69 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

timmz · Accepted Answer · 2013-06-18 22:49:13Z

0

I'm not an expert in Jquery, you can to adapt the working function to your need:

$.ajax({
            url: "check-email.php",
            type:'GET',
            /*you my specify dataType: 'json', for example ...*/
            data: $("#soutez").serialize(), //email input id 
            success: function(res) { 
                switch(res) {
                    case ('true'):
                        alert("true");  
                        break;

                    case ('false'):
                        alert('false');
                        break;
                                    // other cases...

                }
            } 

      });

answered Jun 18, 2013 at 22:49

timmz

2,2523 gold badges24 silver badges29 bronze badges

3 Comments

user1049961 Over a year ago

I'm trying to use the jQuery validation plugin

timmz Over a year ago

What if the user disable the Javascript ?the best approach is to add a PHP validation, something like : if(!filter_var($email, FILTER_VALIDATE_EMAIL)) echo "Email Not Valid ! ";

user1049961 Over a year ago

I of course do have PHP validation after the form submission. What I want is to inform the user that the email exists when filling the form.

Collectives™ on Stack Overflow

Jquery validation plugin - check if email exists

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related