/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 votes130 views4 answers
Laravel where in array
PHP Laravel
0 vote84 views1 answer
Php download temp file
PHP
10 votes150 views2 answers
Laravel route list
PHP Laravel
0 vote136 views1 answer
How to integrate gravity forms in wordpress theme using form id
PHP Wordpress
6 votes138 views6 answers
Search query in laravel
PHP Laravel
0 vote132 views1 answer
Laravel asset resolving to http not https
PHP
0 vote130 views1 answer
Dropdown in crud application YII
PHP Yii
0 vote124 views1 answer
Stupidity
PHP
0 vote91 views1 answer
Laravel isset and not empty
PHP
2 votes141 views2 answers
Get users other than specific role laravel role spatie
PHP Laravel