/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 vote224 views3 answers
Symfony start
PHP Symfony
0 vote108 views1 answer
Php header utf8 json
PHP
29 votes121 views3 answers
Random String Function PHP
PHP
5 votes119 views2 answers
Route() and with() in laravel
PHP
20 votes118 views4 answers
Laravel bootstrap auth
PHP
0 vote110 views2 answers
HTML and PHP enquiry form
PHP
3 votes122 views2 answers
Laravel eloquent get one column value
PHP
2 votes115 views1 answer
Php split string at first space
PHP
0 vote212 views3 answers
Email or phone required in laravel
PHP
1 vote199 views1 answer
Laravel fixed character limit
PHP Laravel