/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

49 votes331 views6 answers
Laravel when
PHP
1 vote357 views1 answer
Laravel refresh server
PHP Laravel
3 votes352 views2 answers
How to use required_with in laravel to array element
PHP Laravel
1 vote293 views2 answers
Php append string
PHP
0 vote309 views1 answer
Echo define value
PHP
1 vote362 views1 answer
Array_last in laravel 8
PHP Laravel
0 vote249 views1 answer
Check custom post type post exists
PHP
1 vote346 views1 answer
Bootstrap doesn't work in laravel
PHP Laravel
11 votes348 views4 answers
Install phpmyadmin ubuntu 18.04
PHP
1 vote307 views1 answer
Php get index of current item array_reduce
PHP