jQuery PHP: Check if username already exist

Question

I'm trying to check the existence of an username already registered on my application using jQuery+Ajax+POST.

HTML

<div class="form-group">
    <label for="username" class="col-md-3 control-label">Username</label>
    <div class="col-md-9">
        <input type="text" id="username" class="form-control" name="username" placeholder="Username">
    </div>
</div>
<div class="col-sm-9 col-sm-offset-3" id="userCheck">
    <div class="alert alert-info" id="userCheckLabel"></div>
</div>

jQuery

$('#username').focusout(function() {
    var username = $('#username').val();
    checkUserExist(username);
})
function checkUserExist($uname) {
    $.post( "../core/lib/checkUserExist.php", function( data ) {
    if(data.html == 'true') {
       $('#userCheck').slideDown("slow");
       $('#userCheckLabel').text("This user already exist!")
    }
});

PHP

<?php
require_once('../../core/class.user.php');
$user = new USER();
$uname = $_POST['username'];

$stmt = $user->runQuery("SELECT user_nameFROM users WHERE user_name=:uname ");
$stmt->execute(array(':uname'=>$uname));
$row=$stmt->fetch(PDO::FETCH_ASSOC);

if($row['user_name']==$uname) {
    print 'true';
} else {
    print 'false';
}
?>

I Don't include class.user.php cause It's only handling the PDO Connection, If I remove the if(data.html == 'true') the connection work as expected and the message come out.

Behavior

The code work if I remove the if(data.html == 'true'). but with this it doesn't do anything, no errors in console. So I think the error is in the way I handle the PHP part. Any suggestion?

you don't sent the username function checkUserExist(uname) { $.post( "../core/lib/checkUserExist.php", {username: uname }, function( data ) { ... — splash58
– splash58, Commented Mar 14, 2017 at 19:10
@splash58 thanks to you and Alive to Die the code is working now! — andreaem
– andreaem, Commented Mar 14, 2017 at 19:18

Death-is-the-real-truth · Accepted Answer · 2017-03-14 19:11:54Z

2

Since you are returning string not HTML, so you have to do like below:-

$.post( "../core/lib/checkUserExist.php",{username: uname }, function( data ) {
     console.log(data);// check this and let me know the output
     if(data == 'true') {  // or try if(data)
       $('#userCheck').slideDown("slow");
       $('#userCheckLabel').text("This user already exist!")
    }
});

edited Mar 14, 2017 at 19:11

answered Mar 14, 2017 at 18:59

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

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

3 Comments

andreaem Over a year ago

thanks for the reply, using your suggestion I don't get the alert regarding the user exist

andreaem Over a year ago

Ok, was a typo in the file path, now it's working as expected, thanks!

Death-is-the-real-truth Over a year ago

@andreaem glad to help you:):)

Collectives™ on Stack Overflow

jQuery PHP: Check if username already exist

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related