How to use prepared statement for login when password is hashed and salted?

[PrinceJ 0]

Well, As the title says:

MySQL Database stores password of users using default PHP password_hash() function when registering.

Now I am not able to find out a way to login using prepared statement to avoid SQL injections,

I mean I can't use password_verify as I am not able to fetch user password from database without executing the query.

[dsonesuk 871]

??? You use the username and password value they provided, hash the password value and identify if they both match with those stored in database

[Ingolme 966]

The logic is pretty simple and can be done easily with prepared statements. There are many ways to do it, here is one of them:

<?php
$username = $_POST['username'];
$password = $_POST['password'];

// Database connection logic. See documentation:
// http://php.net/manual/en/pdo.construct.php
// $pdo = new PDO(...)

$query = $pdo->prepare('SELECT `hashed_password` FROM `users` WHERE `username` = :username LIMIT 1');
$query->bindParam(':username', $username);
$query->execute();
$query->bindColumn('hashed_password', $hashed_password);

if($query->fetch(PDO::FETCH_BOUND)) {
  if(password_verify($password, $hashed_password)) {
    echo 'User is logged in';
  } else {
    echo 'Wrong username or password';
  }
} else {
  echo 'Wrong username or password';
}

 

[PrinceJ 0]

OMG, Thanks a lot Ik that was a stupid question, Archive this.