/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 vote336 views1 answer
Laravel order by raw
PHP Laravel
24 votes263 views2 answers
Php artisan php warning require
PHP
0 vote325 views1 answer
Check mobile or email in laravel
PHP Laravel
0 vote268 views1 answer
Php script to generate random date
PHP
1 vote313 views1 answer
Laravel best practices
PHP Laravel
0 vote286 views2 answers
Socket io laravel
PHP Laravel
0 vote259 views1 answer
Php triple quotes
PHP
0 vote270 views1 answer
Simplesaml php logout
PHP
2 votes266 views1 answer
Laravel difference between current time and created time
PHP
3 votes275 views1 answer
Verificare esistenza file in php
PHP