/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

4 votes324 views2 answers
Laravel form method delete
PHP
6 votes367 views2 answers
Get size files in laravel
PHP Laravel
1 vote370 views2 answers
Laravel make directory
PHP Laravel
5 votes417 views2 answers
Paginate relationship laravel7
PHP
2 votes323 views2 answers
Php remove array element reset keys
PHP
0 vote352 views2 answers
$$ in php
PHP
0 vote385 views1 answer
The_post_thumbnail add class
PHP
0 vote388 views1 answer
How to remove text tab in wordpress editor
PHP Wordpress
2 votes355 views1 answer
Install composer without requirement
PHP
0 vote363 views1 answer
Access directory above php
PHP