/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 vote312 views1 answer
Php loopthrough object
PHP
0 vote351 views1 answer
The Process class relies on proc_open, which is not available on your PHP installation cpanel
PHP
1 vote284 views2 answers
Object to string php
PHP
2 votes292 views1 answer
Php array map cast to int
PHP
19 votes295 views6 answers
Php sort array by specific key
PHP
0 vote307 views1 answer
Php filter non utf-8 characters
PHP
14 votes327 views6 answers
Update query in laravel eloquent
PHP Laravel
0 vote285 views1 answer
How return cutomize error text the firstOrFail laravel exeption
PHP
-1 vote295 views1 answer
Turn error log WP
PHP
0 vote338 views3 answers
Array fill key use in php project
PHP