/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

0 vote195 views1 answer
Do php
PHP
0 vote246 views1 answer
Update onlu one column laravel
PHP Laravel
1 vote272 views4 answers
How to fix 419 page expired in laravel
PHP
12 votes212 views3 answers
Displaying errors in laravel
PHP
0 vote268 views1 answer
When should I use 'self' over '$this'?
PHP
1 vote208 views1 answer
Get data based on date in laravel
PHP Laravel
5 votes223 views2 answers
Remove field from object php
PHP
0 vote234 views2 answers
Laravel get path to storage folder
PHP
0 vote202 views1 answer
Regex phpstorm
PHP
13 votes276 views6 answers
Laravel api routes
PHP Laravel