/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

0 vote280 views2 answers
Laravel sanctum instalation
PHP Laravel
0 vote246 views1 answer
Remove cache from cpanle larael
PHP
0 vote257 views1 answer
Cf7 first_as_label
PHP
0 vote263 views1 answer
Php pdo prepare doesn't work
PHP
1 vote303 views1 answer
Get current month record in laravel
PHP Laravel
1 vote247 views2 answers
Laravel add attribute to model
PHP
19 votes287 views6 answers
Laravel logger
PHP Laravel
1 vote279 views1 answer
Wordpress is_archive
PHP Wordpress
0 vote305 views2 answers
Wp max revisions
PHP Wordpress
0 vote255 views1 answer
Spatie/laravel-activitylog display only changed data
PHP