Warning: mysqli_fetch_all() expects parameter 1 to be mysqli_result, bool given in C:newxammphtdocslearnindex.php on line 11 1

Warning: mysqli_fetch_all() expects parameter 1 to be mysqli_result, bool given in C:\newxammp\htdocs\learn\index.php on line 11

#where you are running mysqli_query , add 'or die( mysqli_error($db)'
#e.g
$sql = "SELECT * FROM users";
$result = mysqli_query($db, $sql) or die( mysqli_error($db));
#$db being the variable holding the connection to db

Here is what the above code is Doing:
1. It’s creating a variable called $sql that holds the SQL query.
2. It’s running the query and storing the result in a variable called $result.
3. It’s checking to see if the query ran successfully. If it didn’t, it’s printing out the error message.

Similar Posts