/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 vote168 views3 answers
Laravel syncwithoutdetaching
PHP
1 vote168 views2 answers
Php append string
PHP
4 votes198 views2 answers
How to create access token in laravel
PHP
6 votes183 views1 answer
Laravel check collection not empty
PHP
0 vote177 views1 answer
Php exec get pid
PHP
18 votes174 views3 answers
Get first word from string php
PHP
0 vote176 views1 answer
How to increase the WordPress Multisite Network limit for Maximum Filesize Upload?
PHP
6 votes168 views2 answers
Laravel generate key
PHP
11 votes270 views6 answers
Datetime validation in laravel
PHP
2 votes249 views1 answer
Laravel carbon human readable
PHP Laravel