/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 vote305 views1 answer
Auth log out laravel
PHP
0 vote283 views1 answer
Laravel post index method
PHP
4 votes310 views2 answers
Row count in codeigniter
PHP
0 vote301 views1 answer
Wordpress html classes
PHP
0 vote282 views1 answer
Php mysql insert timestamp now
PHP
0 vote302 views1 answer
Bulk write mongodb php
PHP
1 vote281 views1 answer
Get_posts category
PHP
0 vote294 views2 answers
Composer create project laravel with version
PHP
1 vote312 views1 answer
Change the method name in resource in laravel
PHP
1 vote341 views1 answer
Laravel refresh server
PHP Laravel