How to get password from mysql query?

Question

PHP

I'm trying to check user authorization. I do a check by nickname, and then I need to somehow get the password and compare.

$db = new mysqli($host, $user, $password, $database)
or die("Error " . mysqli_error($db));

$sql = "SELECT name, password FROM login WHERE name = '$login_admin->nickname'";
$res = $db->query($sql);
if($login_admin->password == $res->password){
  echo "Ok";
  }else{
   echo "faslse";
}

But there is no password data in $res (I feel that something is missing there.

Answer 1

$sql = "SELECT name, password FROM login WHERE name = '".addslashes($login_admin->nickname)."'";
$res = $db->query($sql);
$user = $db->fetch($res);
if($login_admin->password == $user->password){
  echo "Ok";
  }else{
   echo "faslse";
}