/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

5 votes174 views5 answers
Install laravel 8 with composer
PHP Laravel
1 vote186 views1 answer
Get random posts wordpress
PHP
3 votes121 views1 answer
Phpcs
PHP
1 vote188 views2 answers
Create child theme in wordpress
PHP
10 votes206 views2 answers
Create folder php
PHP
2 votes171 views1 answer
Wp cron disable
PHP
0 vote191 views1 answer
Get basename without extension Laravel
PHP
2 votes162 views4 answers
Laravel where in array
PHP
7 votes186 views2 answers
Wordpress get post type
PHP Wordpress
0 vote168 views1 answer
Drupal form show description
PHP