/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 votes126 views2 answers
Get value type online
PHP
0 vote124 views1 answer
How to get local current time in laravel
PHP
0 vote165 views1 answer
Upload image to database laravel 8
PHP Laravel
11 votes135 views4 answers
Session variable in laravel
PHP
25 votes126 views2 answers
Clear cache without using composer in laravel 8
PHP
1 vote146 views2 answers
How to pass parameter in routes of laravel
PHP Laravel
0 vote195 views10 answers
Laravel relations find
PHP
1 vote97 views1 answer
Wordpress png quality
PHP Wordpress
0 vote151 views1 answer
Package manifest php error
PHP
3 votes262 views3 answers
Wordpress errors
PHP Wordpress