/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

2 votes103 views2 answers
Allowed memory size of 1610612736 bytes exhausted 4096
PHP
0 vote166 views1 answer
Laravel job delay dispatch
PHP Laravel
0 vote142 views1 answer
Send mail using php mail function on localhost using xampp server
PHP
2 votes110 views1 answer
Php get elapsed time
PHP
0 vote95 views1 answer
Php return function result to variable
PHP
0 vote114 views1 answer
Check if config exist laravel
PHP Laravel
0 vote107 views1 answer
Curl error (code 3) url malformed laravel
PHP
2 votes101 views1 answer
Laravel validate integer between
PHP
1 vote126 views1 answer
Twig limit text
PHP
0 vote107 views1 answer
What is the mixmam size that php can take
PHP