/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

1 vote96 views2 answers
Wordpress login user programmatically
PHP
0 vote109 views2 answers
Add slashes to string
PHP
2 votes128 views2 answers
Open php.ini in ubuntu
PHP
3 votes103 views4 answers
Php increment variable by 1
PHP
13 votes155 views5 answers
Php datetime from timestamp
PHP
0 vote90 views1 answer
How can get attribute without getter in laravel
PHP
0 vote97 views1 answer
Spatie/laravel-activitylog display only changed data
PHP Laravel
2 votes112 views1 answer
Php login google api
PHP
4 votes111 views2 answers
Laravel sum column values
PHP Laravel
5 votes101 views4 answers
Wordpress get plugin root directory
PHP Wordpress