/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

20 votes222 views6 answers
Check string in php
PHP
0 vote161 views1 answer
Fetch Multiple Rows in PHP
PHP
76 votes233 views5 answers
Php show error
PHP
-1 vote192 views1 answer
Send email when form is submitted php
PHP
33 votes198 views6 answers
Laravel make:auth
PHP Laravel
7 votes222 views3 answers
Laravel search function
PHP Laravel
14 votes203 views3 answers
Unset php return array
PHP
2 votes172 views1 answer
Php trim array to certain length
PHP
0 vote170 views1 answer
Limited text show in laravel
PHP
0 vote169 views1 answer
Apache use public folder as root
PHP