/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

10 votes282 views2 answers
Laravel array to string conversion
PHP
5 votes331 views2 answers
Laravel chmod
PHP Laravel
0 vote359 views4 answers
Upload image in laravel
PHP Laravel
0 vote282 views1 answer
Laravel override eloquent all function
PHP
0 vote303 views1 answer
Show only 3 initial letter of month in php
PHP
7 votes301 views3 answers
Php combine values of two arrays
PHP
6 votes307 views2 answers
Laravel migration table column nullable
PHP Laravel
11 votes330 views6 answers
Convert object to array php
PHP
0 vote292 views1 answer
Replace default WP search and dropdown placeholder
PHP
5 votes340 views4 answers
Php globals
PHP