/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 votes137 views1 answer
: Unable to locate package php7.4-fpm
PHP
0 vote215 views1 answer
Laravel\Socialite\Two\InvalidStateException
PHP Laravel
5 votes167 views2 answers
Laravel auth namespace
PHP Laravel
3 votes164 views2 answers
Laravel 7 view @php
PHP
1 vote172 views2 answers
Public laravel htaccess
PHP Laravel
1 vote143 views1 answer
Php set header to utf-8
PHP
1 vote190 views1 answer
Laravel sentence word count
PHP Laravel
1 vote159 views2 answers
Php strip out special characters
PHP
6 votes173 views3 answers
Laravel blade route redirect back
PHP Laravel
0 vote198 views1 answer
Nova laravel image
PHP Laravel