/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

10 votes110 views4 answers
Unset php
PHP
4 votes108 views2 answers
Duplicate record laravel
PHP
0 vote107 views1 answer
Php check session status
PHP
0 vote111 views1 answer
Remove exact characters from string using php
PHP
3 votes171 views2 answers
Laravel create project thorugh composer
PHP Laravel
0 vote120 views1 answer
Get 1 data from get laravel
PHP Laravel
2 votes113 views1 answer
Wordpress print post data
PHP
5 votes102 views1 answer
Php artisan serve another port
PHP
-2 votes136 views1 answer
Wp get category by id
PHP Wordpress
0 vote105 views1 answer
Php run cron evey hour
PHP