/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 vote145 views1 answer
Text box should accept only alphanumeric not special characters in php
PHP
2 votes156 views1 answer
Php array map cast to int
PHP
39 votes182 views6 answers
Php uppercase
PHP
3 votes178 views3 answers
Laravel pagination having raw query not working
PHP Laravel
7 votes234 views2 answers
If notexists in laravel query
PHP
21 votes155 views6 answers
Laravel seeder update
PHP
1 vote202 views1 answer
Laravel get next record
PHP Laravel
2 votes144 views2 answers
Confirm popup laravel
PHP
0 vote127 views1 answer
Use external variable in array_filter
PHP
0 vote164 views2 answers
Comment split une chaine de caratere en php
PHP