/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 vote219 views1 answer
Mixed content laravel form target
PHP Laravel
1 vote225 views5 answers
Laravel eloquent batch insert
PHP Laravel
0 vote188 views1 answer
Most complicated task ina array in php
PHP
2 votes187 views3 answers
Make model -mcr laravel
PHP
0 vote180 views1 answer
Laravel faker realtext
PHP
0 vote204 views2 answers
Api newslater with php
PHP
0 vote206 views1 answer
SetUp() must be compatible with Illuminate\Foundation\Testing\TestCase::setUp()
PHP
9 votes216 views4 answers
Laravel time format
PHP
2 votes157 views1 answer
Php stdclass is object?
PHP
1 vote145 views2 answers
Wordpress get post slug
PHP