匹配在数据库中获取的用户名和密码 - Jquery [复制]

This question already has an answer here:

I need to match my username and password that is fetch in the database. right now the problem is I cannot match the username and password like the image you see below:

enter image description here

here is my code below:

HTML

    <body>  
          <div class="container box">  
           <div class="form-group">  
            <h3 align="center">Live Username Available or not By using PHP Ajax Jquery</h3><br />  
            <label>Enter Username</label>  
            <input type="text" name="username" id="username" class="form-control" />
            <input type="password" name="password" id="password" class="form-control" />


            <span id="availability"></span>
            <br /><br />
            <button type="button" name="register" class="btn btn-info" id="register" disabled>Register</button>
            <br />
           </div>  
           <br />  
           <br />  
          </div>  
  </body>

jQuery script - this is where the match availability will show after the username and password is match or mismatched

<script>  
 $(document).ready(function(){  
  $('#username, #password').blur(function(){

    var username = $('#username').val();
    var password = $('#password').val();

     $.ajax({
      url:'check.php',
      method:"POST",
      data:{user_name:username, password:password},
      success:function(data)
      {
        console.log(data);
       if(data != '0')
       {
        $('#availability').html('<span class="text-danger">Username and Password not Match</span>');
        $('#register').attr("disabled", true);
       }
       else
       {
        $('#availability').html('<span class="text-success">Username and Password Available</span>');
        $('#register').attr("disabled", false);
       }

      }

     })

  });
 });  
</script>

check.php - database connection and query

  <?php  
    //check.php  
    $connect = mysqli_connect("localhost", "username", "", "dbname"); 
    if(isset($_POST["user_name"], $_POST["password"]))
    {
     $username = mysqli_real_escape_string($connect, $_POST["user_name"]);
     $password = mysqli_real_escape_string($connect, $_POST["password"]);
     $query = "SELECT * FROM admin WHERE username = '".$username."' AND password = '".$password."' ";
     $result = mysqli_query($connect, $query);
     echo mysqli_num_rows($result);
    }
 ?>

</div>

I think your condition is wrong in the client end script. If username and password matched then it will return value which is greater than 0 . In that case, your code should be

success:function(data)
  {
    console.log(data);
    if(data == 0)
    {
      $('#availability').html('<span class="text-danger">Username and Password not Match</span>');
      $('#register').attr("disabled", true);
    } 
    else
    {
      $('#availability').html('<span class="text-success">Username and Password Available</span>');
      $('#register').attr("disabled", false);
    }
   }

FOR MINUS POINTS This is a solution to the problem that the OP also had. Please see main thread comments. Thank you.

Just wrap your POST value into md5 function.

$password = md5(mysqli_real_escape_string($connect, $_POST["password"]));

OR can try use MD5 in database.

$query = "SELECT * FROM admin WHERE username = '".$username."' AND password = MD5('".$password."') ";

Then password hash should be equal to database hash.

you can try this:

if(isset($_POST["username"], $_POST["password"])) 
    {     
 $username = $_POST["username"]; 
 $password = $_POST["password"]; 
 $query = mysql_query("SELECT username, password FROM admin WHERE username = '".$username."' AND  password = '".$password."'");
 $result=$connect->query($query);
        if(mysql_num_rows($result) > 0 )
        { 
            $_SESSION["logged_in"] = true; 
            $_SESSION["username"] = $name; 
        }
        else
        {
            echo 'The username or password are incorrect!';
        }
}