/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 vote165 views1 answer
Laravel format number blade
PHP Laravel
-1 vote135 views1 answer
How to print any string in double quotes in php
PHP
1 vote139 views1 answer
How to create controler in laravel
PHP
0 vote141 views1 answer
Example of valid php variables
PHP
49 votes219 views6 answers
Laravel clear all cache
PHP Laravel
0 vote137 views1 answer
Meta_value wordpress
PHP
0 vote167 views1 answer
Check value is email or mobilenumber using php
PHP
2 votes170 views2 answers
Laravel sidebar menu active
PHP Laravel
0 vote140 views1 answer
Gravity Form Shortcode Wordpress
PHP
0 vote144 views1 answer
Elementor woo product hide add to cart
PHP