Warning: mysqli_fetch_all() expects parameter 1 to be mysqli_result, bool given in C:newxammphtdocslearnindex.php on line 11 1

Warning: mysqli_fetch_all() expects parameter 1 to be mysqli_result, bool given in C:\newxammp\htdocs\learn\index.php on line 11

ByAnurag batra 
#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

Here is what the above code is Doing:
1. It’s creating a variable called $sql that holds the SQL query.
2. It’s running the query and storing the result in a variable called $result.
3. It’s checking to see if the query ran successfully. If it didn’t, it’s printing out the error message.

Similar Posts

Compiling multiple CSS into ONE CSS with Laravel MIX

Compiling multiple CSS into ONE CSS with Laravel MIX

ByAnurag batra

The solution was to import all the required css into one main css file, then use that inside the mix chain: in app.css we import all of our css files @import ‘resources/css/plugin-1.css’; @import ‘resources/css/plugin-2.css’; inside webpack.mix.js we use resource/app.css as an input mix.styles([ ‘resources/app.css’, ], output); Here is what the above code is Doing: 1….

PDO encode result recordset to utf8

PDO encode result recordset to utf8

ByAnurag batra

function utf8_encode_recordset($recordset) { return array_map(function($record) { return array_map(“utf8_encode”, $record); }, $recordset); } Here is what the above code is Doing: 1. It’s creating a function called utf8_encode_recordset. 2. It’s taking a recordset as a parameter. 3. It’s mapping the recordset to an array. 4. It’s mapping each record in the array to an array. 5….

get last name user

get last name user

ByAnurag batra

get_user_meta( $new_user->ID, ‘last_name’, true ); Here is what the above code is Doing: 1. We’re using the wp_insert_user() function to create a new user. 2. We’re setting the user’s role to ‘subscriber’. 3. We’re setting the user’s first and last name. 4. We’re setting the user’s username to the email address. 5. We’re setting the…

instal phpgd2

instal phpgd2

ByAnurag batra

sudo apt-get install php5-gd Here is what the above code is Doing: 1. We’re using the apt-get command to install the php5-gd package. 2. We’re using the -y flag to tell apt-get to assume yes to all prompts and run non-interactively. 3. We’re using the -q flag to tell apt-get to be quiet and not…