Check username with ajax jquery php mysql

Question

I have table users :

id : int,
username : varchar(255),
password :varchar(255),

I would check if the login exist in the database or not

I try with this code jquery and html :

 <div class="form-group">
     <label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">username <span class="required">*</span></label>
     <div class="col-md-6 col-sm-6 col-xs-12">
        <input type="text"  class="form-control col-md-7 col-xs-12"  name="username " id="username ">
          <span id="availablity"></span>
     </div>
 </div>
<script type="text/javascript">

    $('document').ready(function(){
            $('#username').blur(function(){
                var username = $(this).val();
                $.ajax ({
                    url = "check.php",
                    method = "POST",
                    data =  {username :username },
                    dataType : "text",
                    success:function(html)
                    {
                        $('#availablity').html(html);
                    }
                });
            });
    });
</script>

page check.php :

if(isset($_POST['username'])){
                $username  = $_POST["username"];
                $sql = $db->query("SELECT * FROM users WHERE username  = '$username'");
                if($sql->rowCount() > 0){
                     echo '<span class="text-danger">Not Exist</span>';
                }else{
                    echo '<span class="text-success">Exist</span>';
                }

}

But no results

For security reasons: you really should escape your username. Currently your application is vulnerable for SQL injections. — u-nik
– u-nik, Commented Jul 29, 2016 at 8:53
Apart from that, your logic is wrong: rowCount()>0 should return "Exists" — Jeff
– Jeff, Commented Jul 29, 2016 at 8:56

Mohit Tanwani · Accepted Answer · 2016-07-29 09:02:44Z

1

Please try following code.

JavaScript code

 $('document').ready(function(){
          $('#username').change(function(){
               var username = $(this).val();
                $.ajax ({
                    url : "check.php",
                    method : "POST",
                    data :  {username :username },
                    dataType: "text",
                    success:function(html)
                    {
                        $('#availablity').html(html);
                    }
                });
            });
   });

And you've mentioned id="username " (with space), please change that like as below.

<input type="text"  class="form-control col-md-7 col-xs-12"  name="username" id="username">

answered Jul 29, 2016 at 9:02

Mohit Tanwani

6,6382 gold badges16 silver badges33 bronze badges

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

1 Comment

Mohit Tanwani Over a year ago

@johansson, you accepted my answer and then removed it.

u-nik · Accepted Answer · 2016-07-29 08:58:53Z

1

You have used = in your ajax configuration. Thats an syntax error. Use

$.ajax({
    url: "check.php",
    method: "POST",
    data: {username: username},
    dataType: "text",
    success: function (html) {
        $('#availablity').html(html);
    }
});

instead.

answered Jul 29, 2016 at 8:58

u-nik

4884 silver badges12 bronze badges

Comments

ayush · Accepted Answer · 2016-07-29 09:05:01Z

0

This should be your code:

$('document').ready(function(){
            $('#username').blur(function(){

                var username = $(this).val();
                $.ajax ({
                    url :"check.php",
                    method: "POST",
                    data : {username :username },
                    dataType : "text",
                    success:function(html)
                    {
                        $('#check').html(html);
                    }
                });
            });
    });

answered Jul 29, 2016 at 9:05

ayush

1349 bronze badges

Comments

Naga · Accepted Answer · 2016-07-29 09:14:16Z

0

looks Jquery syntax error ...

<script type="text/javascript">

    $('document').ready(function(){
            $('#username').blur(function(){
                var username = $(this).val();
                $.ajax ({
                    url : "check.php",
                    method : "POST",
                    data :  {username :username },
                    dataType : "text",
                    success:function(html)
                    {
                        console.log(html);
                        $('#availablity').html(html);

                    },
                    error: function(html)
                    {
                        console.log(html);
                    }
                });
            });
    });
</script>

check your console message.

edited Jul 29, 2016 at 9:14

answered Jul 29, 2016 at 9:02

Naga

2,1683 gold badges18 silver badges21 bronze badges

Collectives™ on Stack Overflow

Check username with ajax jquery php mysql

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related