/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 vote203 views1 answer
The app function returns the service container instancel
PHP
0 vote135 views1 answer
Wordpress get page number
PHP
4 votes150 views1 answer
Php get array average
PHP
0 vote141 views1 answer
How to check if page opened from mobile or desktop
PHP
-1 vote198 views1 answer
Element cakephp
PHP CakePHP
32 votes163 views6 answers
Php get ip address
PHP
0 vote162 views1 answer
How to conditional values in old value or edit new value with validsation faild to redirect back in laravel
PHP Laravel
0 vote186 views1 answer
Wordpress is_tag function
PHP
0 vote152 views2 answers
Login with email and phone laravel
PHP Laravel
0 vote166 views1 answer
Laravel make view command
PHP Laravel