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";
}
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);