/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 vote260 views1 answer
Http error 500 phpmyadmin
PHP
0 vote278 views1 answer
Order by sum() laravel
PHP Laravel
1 vote208 views1 answer
Array push laravel
PHP
7 votes232 views2 answers
Php Undefined index: error
PHP
18 votes255 views4 answers
Php list all files in directory
PHP
1 vote204 views1 answer
Check if string is base64 php
PHP
1 vote336 views2 answers
Symfony get current datetime
PHP Symfony
0 vote283 views1 answer
Generate slug on create laravel
PHP Laravel
1 vote315 views1 answer
Static function model laravel
PHP Laravel
1 vote282 views1 answer
Laravel controller return message
PHP Laravel