/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 vote212 views1 answer
Laravel: Validation unique on update
PHP
0 vote176 views1 answer
Mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given in
PHP
1 vote220 views1 answer
Wp get field taxonomy
PHP Wordpress
3 votes206 views3 answers
Laravel pagination having raw query not working
PHP Laravel
9 votes204 views2 answers
A facade root has not been set laravel
PHP
1 vote163 views2 answers
Run shell script from php file
PHP
1 vote207 views1 answer
Php include once inside a function?
PHP
0 vote195 views1 answer
Laravel Testing send raw data in GET method
PHP
0 vote179 views1 answer
Check laravel first null
PHP
0 vote185 views6 answers
Hash password decrypt laravel
PHP