/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

8 votes273 views3 answers
Php join
PHP
0 vote313 views1 answer
Laravel creating_table_name
PHP Laravel
4 votes321 views6 answers
Jwt laravel
PHP
1 vote352 views1 answer
Lumen jwt
PHP
0 vote304 views1 answer
How to get all the records with same ID in laravel
PHP
1 vote275 views1 answer
How to get array dont similer elements in php
PHP
0 vote293 views1 answer
Theme mod disalow wp
PHP
1 vote311 views1 answer
Php get country code from country name
PHP
9 votes303 views4 answers
Pretty json php
PHP
0 vote279 views1 answer
Smarty foreach
PHP