/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 vote140 views2 answers
Public laravel htaccess
PHP Laravel
0 vote138 views1 answer
Php mysqli connect err0r
PHP
0 vote139 views2 answers
How to save array of inputs in php
PHP
18 votes145 views6 answers
String to datetime php
PHP
2 votes143 views3 answers
Wordpress get user id by email
PHP Wordpress
1 vote126 views5 answers
Jobs laravel
PHP
0 vote143 views1 answer
Laravel Facades\DB update
PHP Laravel
0 vote144 views1 answer
Laravel nova card duplicate keys
PHP
3 votes132 views2 answers
Password encryption php
PHP
1 vote115 views2 answers
Mail function php not working
PHP