/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

2 votes179 views3 answers
Hmtl remove tag php
PHP
0 vote197 views1 answer
Php pass variable to anonymous function
PHP
-1 vote205 views2 answers
Best way to check if a URL is valid
PHP
1 vote172 views2 answers
Php xml string
PHP
10 votes220 views2 answers
Laravel array to string conversion
PHP Laravel
0 vote201 views1 answer
Disable sidebar widget wordpress 5.8
PHP Wordpress
-1 vote186 views1 answer
Turn error log WP
PHP Wordpress
0 vote169 views1 answer
Login and registration form using php and mysqul
PHP
0 vote169 views1 answer
Calcul age php datetime
PHP
0 vote192 views1 answer
Php deader deny iframe
PHP