/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 vote152 views1 answer
Laravel map array
PHP
-1 vote199 views2 answers
Fresh migrqte laravel
PHP
10 votes245 views2 answers
Create model in laravel command line
PHP Laravel
47 votes272 views6 answers
How to add new column in laravel migration
PHP Laravel
0 vote201 views1 answer
Expected PlainValue, got ''' at position 81 in class App\Entity\User.
PHP
0 vote252 views3 answers
Php find multiple value in array
PHP
2 votes162 views2 answers
Add seconds to datetime carbon
PHP
0 vote170 views1 answer
Launch new tab and refresh original page codeigniter
PHP CodeIgniter
3 votes162 views2 answers
Allowed memory size of 1610612736 bytes exhausted (tried to allocate 4096 bytes) laravel
PHP
0 vote199 views1 answer
Php receive request
PHP