jQuery Validate remote method usage to check if username already exists

Question

I want to validate if username exists in database using jQuery.validate so here's what I have so far:

jQuery:

    $("#signupForm").validate({
        rules: {
            username: {
                required: true,
                minlength: 3,
                remote: "check-username.php"
                }
            },
        messages: {
            username:{
                remote: "This username is already taken! Try another."
            }
        }
  });

check-username.php:

<?php

require_once "./source/includes/data.php";
header('Content-type: application/json');

$name = mysql_real_escape_string($_POST['username']);

$check_for_username = mysql_query("SELECT username FROM mmh_user_info WHERE username='$name'");

if (mysql_num_rows($check_for_username) > 0) {
    $output = true;
} else {
    $output = false;
}
echo json_encode($output);
?>

This code always shows an error that the username is taken even if it's not.

I'm using jQuery Mobile 1.9.1

Thanks in advance.

Can you explain the question a little bit more? Which part seems to work, and what doesn't? — CP510
– CP510, Commented May 16, 2013 at 0:27
On the registration page, it does not check if the user is taken. — Rounds
– Rounds, Commented May 16, 2013 at 0:28
Open the network tab. Is a request sent to the page "check-username.php" on submit? if so, what is the response code (200,404,500 etc.) and what is the response content? — Matanya
– Matanya, Commented May 16, 2013 at 1:28
Okay, I'm sorry about this, there was no requests sent to check-username.php the file was in the wrong place. I fixed it but now it always show that the username is taken even if it's not! — Rounds
– Rounds, Commented May 16, 2013 at 1:47

Rounds · Accepted Answer · 2013-05-16 11:38:50Z

8

I've managed to get this to work by changing the PHP technique I was using, here's my PHP:

<?php
require_once "./source/includes/data.php";
header('Content-type: application/json');
$request = $_REQUEST['username'];

$query = mysql_query("SELECT * FROM mmh_user_info WHERE username ='$username'");
$result = mysql_num_rows($query);
if ($result == 0){
$valid = 'true';}
else{
$valid = 'false';
}
echo $valid;
?>

Thanks everyone here for your help :)

answered May 16, 2013 at 11:38

Rounds

1,8994 gold badges19 silver badges30 bronze badges

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

1 Comment

user9437856 Over a year ago

5 years gone and still helpful to me.upvote from my side

Community · Accepted Answer · 2017-05-23 12:16:16Z

2

I have two resources for to look at.

Official example from the validate plugin: http://jquery.bassistance.de/validate/demo/milk/

jQuery forum solution: http://forum.jquery.com/topic/jquery-validation-plugin-remote-validation-problem-locks-up

The possible solution is that the response does not need to be json encoded as far as I can tell. Since json needs key value pairs, suppling just the value won't work. So try to just echo it out as 'true' or 'false' strings.

Second, the validate uses GET for the form submission method, not POST.

NOTE: JUST FOUND POSSIBLE SOLUTION QUESTION jQuery Remote validation

edited May 23, 2017 at 12:16

CommunityBot

11 silver badge

answered May 16, 2013 at 0:32

CP510

2,27216 silver badges16 bronze badges

1 Comment

CP510 Over a year ago

Well that does a bit actually. Unfortunatly I am not to knowledgable on jQuery Mobile. If anyone else is, they should feel free to correct us. :)

Collectives™ on Stack Overflow

jQuery Validate remote method usage to check if username already exists

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related