PHP从表中选择不起作用

Question

i have a problem with mysqli selecting from table. can you pls corect this for me or at least tell me what i have done wrong please? thanks

$row = *mysqli_query($con, "SELECT  `user`, `pass` FROM `users` WHERE `user` = '$uname'");
if  ( $row && ['password'] == $pass ) {
    echo "Logged";
} else {
    echo "Incorect user/password";
}

Answer 1

For successful SELECT, SHOW, DESCRIBE or EXPLAIN queries mysqli_query will return a mysqli_result object. You need to call mysqli_fetch_array to fetch rows out of you result object.

$res = mysqli_query($con, "SELECT  `user`, `pass` FROM `users` WHERE `user` = '$uname'");
$row = mysqli_fetch_array($res);