/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 votes176 views6 answers
Laravel 8 ui auth
PHP
2 votes166 views1 answer
Exit and echo php
PHP
0 vote241 views1 answer
Comment supprimer les éléments liés à WordPress oEmbed
PHP Wordpress
0 vote165 views1 answer
Php nginx file not found
PHP
0 vote211 views1 answer
Snactum laravel
PHP Laravel
0 vote168 views1 answer
Php write to standard out
PHP
0 vote243 views1 answer
Régler l’enregistrement automatique dans WordPress
PHP Wordpress
0 vote186 views1 answer
Php backend generator
PHP
0 vote206 views1 answer
How to fetch days old records php mysql
PHP
0 vote195 views1 answer
Laravel 7 create-project
PHP Laravel