/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

7 votes283 views3 answers
How to show validation error in laravel blade
PHP Laravel
0 vote291 views1 answer
Laravel 8 jwt api authentication
PHP Laravel
2 votes246 views1 answer
Laravel where update query
PHP Laravel
0 vote296 views5 answers
Laravel create multiple models at once
PHP Laravel
64 votes236 views6 answers
Delete cache laravel
PHP
18 votes235 views5 answers
Php get first word of string
PHP
0 vote244 views1 answer
Best documentation tools for php
PHP
0 vote307 views2 answers
Wordpress move debug.log
PHP Wordpress
0 vote238 views1 answer
Laravel schedule kernel code sample
PHP Laravel
2 votes219 views1 answer
Laravel check if session variable exists
PHP