/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 vote317 views1 answer
Wc php order view order link
PHP
0 vote325 views1 answer
Error repoerting in php
PHP
2 votes352 views5 answers
Php declare variable
PHP
1 vote333 views1 answer
How to add property to the request object
PHP
1 vote321 views1 answer
Php assign value to object
PHP
1 vote343 views1 answer
Declare boolean php
PHP
2 votes355 views1 answer
How to return chunk data laravel
PHP
-1 vote385 views3 answers
Grouping route in laravel
PHP Laravel
4 votes387 views6 answers
Create middleware laravel
PHP
2 votes350 views3 answers
Laravel where created_at today
PHP