/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 vote110 views1 answer
Laravel realation with has
PHP Laravel
0 vote95 views1 answer
Codeigniter 3 Pass anything in query string
PHP
0 vote98 views1 answer
Catch warning php
PHP
3 votes115 views2 answers
Error handling in laravel
PHP Laravel
0 vote96 views2 answers
Old codestar text field
PHP
0 vote94 views1 answer
Befreie den WordPress-Header von unnötigen Einträgen
PHP
1 vote108 views1 answer
Get the category wp
PHP Wordpress
0 vote83 views1 answer
Collapse open by default
PHP
4 votes155 views2 answers
Laravel get authorization bearer token
PHP Laravel
23 votes110 views6 answers
Laravel model insert
PHP Laravel