Php unable to determine userid availability with jQuery Validate

Question

I have a problem with using jQuery validate remote function with php. I try to check the user id with query whether the user id is exist or not. But it alway show user is in used.

Here is my jQuery validate code:

userID: {
                    required: true,
                    minlength: 5,
                    remote : {
                        url: "checkUserId.php",
                        type: "post"
                    }
                },

Here is my php checking code:

<?php
     include "session.php";
     include 'dbConnect.php';

     global $conn;

     $requestedID  = $_POST['userID'];

     $query = "SELECT * FROM Users WHERE _userID = '$requestedID'";
     $result = sqlsrv_query($conn,$query);

     $row_count = sqlsrv_num_rows($result);
     if($row_count === false){
         echo 'false';
     }
     else if($row_count >=0){
         echo 'true';
     }
?>

Anything I did wrong in my query?

Have you tried debugging $_POST to ensure that the correct value is being passed through by jQuery? — scrowler
– scrowler, Commented Apr 28, 2015 at 1:59
The column is _userID or userid? Also passing user provided data directly to the sql opens you to injections. — chris85
– chris85, Commented Apr 28, 2015 at 2:00
@chris85 Its okay, ignore the injections first. Please stick to the question please... — Marcus Tan
– Marcus Tan, Commented Apr 28, 2015 at 2:02

kenken · Accepted Answer · 2015-04-28 02:55:39Z

2

Change your if else condition.

if($row_count == 0){
echo 'true';
}else{
echo 'false';
}

true = not exist, false = exist

edited Apr 28, 2015 at 2:55

answered Apr 28, 2015 at 2:08

kenken

617 bronze badges

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

5 Comments

kenken Over a year ago

did you tried to echo $row_count? what's the result?

Marcus Tan Over a year ago

how to echo the result as i using remote... it does not show anything on my echo

kenken Over a year ago

yeah right, but you can access directly through the browser your php file(checkUserId.php) to see the result.

Marcus Tan Over a year ago

this is what i get Notice: Undefined index: userID in C:\xampp\htdocs\TNBCMS(Develop)\checkUserId.php on line 7 false

kenken Over a year ago

it means that you are not getting the value of this $_POST['userID'] . check your form if it has a method post and also echo $_POST['userID'] .

Marcus Tan · Accepted Answer · 2015-04-28 03:15:54Z

0

I had successfully solved it with this code. Thanks for all the support.

Here is my updated code:

<?php
     include "session.php";
     include 'dbConnect.php';

     global $conn;

     $requestedID  = $_REQUEST['userID'];

     $query = "SELECT * FROM Users WHERE _userID = '$requestedID'";
     $params = array();
     $options =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
     $result = sqlsrv_query($conn,$query , $params, $options);


    $row_count = sqlsrv_num_rows($result);
    if($row_count >= 1){
        echo 'false';
    }
    else{
        echo 'true';
    }


?>

answered Apr 28, 2015 at 3:15

Marcus Tan

4171 gold badge12 silver badges27 bronze badges

Collectives™ on Stack Overflow

Php unable to determine userid availability with jQuery Validate

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related