/PHP/Mysqli_fetch_all() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\complete-blog-php\admin\includes\post_functions.php on line 31

Mysqli_fetch_all() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\complete-blog-php\admin\includes\post_functions.php on line 31

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

Source: codeproject.com

Mysqli_fetch_all() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\complete-blog-php\admin\includes\post_functions.php on line 31

mysqli_fetch_array()'s 1st parameter must be a result of a query. What you are doing is you are passing the connection (which doesn't make sense) and the query command itself.

To fix this, execute the query first, then store the result to a variable then later fetch that variable.

$sql = "select * from privinsi";
$result = mysqli_query($connection,$sql);
while($r = mysqli_fetch_array($result))
{
    // your code here
}

Source: hrefcode.com

Similar codes

2 votes273 views2 answers
How get query from url in laravel
PHP Laravel
0 vote245 views1 answer
No cache on browser back php
PHP
0 vote253 views1 answer
Route pattern cannot reference variable name more than once. laravel
PHP Laravel
0 vote223 views1 answer
Your Composer dependencies require a PHP version "><h1>HELLO THERE!</h1>
PHP
1 vote214 views2 answers
Modularizing laravel 8.0
PHP
3 votes218 views3 answers
PHP time limit (max_execution_time):
PHP
6 votes223 views2 answers
Php artisan key generate
PHP
0 vote232 views1 answer
Redirect to HTTPS & remove www
PHP
102 votes292 views6 answers
Php string replace
PHP
1 vote225 views1 answer
How to add property to the request object
PHP