/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 vote183 views1 answer
Link fake data in seeder laravel
PHP Laravel
15 votes161 views1 answer
Laravel skip requirements
PHP Laravel
2 votes180 views1 answer
How to use join query in codeigniter
PHP CodeIgniter
9 votes311 views1 answer
Create foreign key phpmyadmin
PHP
0 vote139 views1 answer
Php date('d') is one day behind
PHP
0 vote164 views1 answer
Laravel vendor publish all files
PHP Laravel
0 vote132 views1 answer
$tmpmembershipfee = MembershipFee::orderBy('created_at','DESC') ->first();
PHP
0 vote186 views1 answer
How to add a additional condition in a join using query builder laravel 5.3?
PHP
2 votes161 views2 answers
Disable Bitnami Banner Wordpress
PHP Wordpress
0 vote177 views1 answer
Push key and value in laravel
PHP