/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

0 vote220 views1 answer
Last login date time in wordpress
PHP Wordpress
0 vote285 views2 answers
Yii2 get params from url
PHP Yii
-1 vote250 views3 answers
Codeigniter pagination example
PHP CodeIgniter
1 vote206 views3 answers
Laravel 6 orderby
PHP
0 vote198 views1 answer
Every post wp error 404
PHP
0 vote213 views1 answer
Laravel denny request by ip
PHP
2 votes206 views2 answers
Php string pattern match digit
PHP
3 votes241 views2 answers
{{Str::limit laravel
PHP Laravel
3 votes195 views3 answers
Laravel description substring
PHP
5 votes207 views2 answers
Laravel encrypt decrypt
PHP Laravel