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 October 20, 2022September 6, 2022

#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.

PHP Examples

time to load php page

ByAnurag batra July 28, 2022June 30, 2022

//Put this code at beginning of your page: //Put this code at the end of your page: This page was generated in seconds. Here is what the above code is Doing: 1. We start by creating a variable called $start_time and assigning it the current time in microseconds. 2. We then echo out the time…

PHP Examples

composer update php mbstring.so missing

ByAnurag batra October 8, 2022September 6, 2022

sudo apt-get install php7.1-mbstring Here is what the above code is Doing: 1. Install the latest version of PHP 7.1 and some common PHP modules. 2. Enable the PHP 7.1 module. 3. Restart Apache to make the changes take effect.

PHP Examples

php pow

ByAnurag batra July 8, 2022June 30, 2022

$z = pow(2, 8); // int(256) $z = $x ** $y; // PHP >= 5.6 Here is what the above code is Doing: 1. $x is assigned the value of 2. 2. $y is assigned the value of 3. 3. $z is assigned the value of 2 to the power of 3. 4. $z is…

acf add options page to custom post type

PHP Examples

acf add options page to custom post type

ByAnurag batra October 20, 2022September 6, 2022

if( function_exists(‘acf_add_options_page’) ) { acf_add_options_sub_page(array( ‘page_title’ => ‘Offers Page Content’, ‘menu_title’ => ‘offers-page-content’, ‘parent_slug’ => ‘edit.php?post_type=offers’, )); } Here is what the above code is Doing: 1. We’re checking to see if the ACF plugin is active. 2. If it is, we’re adding a sub-page to the Offers page in the admin menu. 3. We’re…

PHP Examples

Laravel create method

ByAnurag batra July 16, 2022June 30, 2022

// If there’s a flight from Oakland to San Diego, set the price to $99. // If no matching model exists, create one. $flight = App\Flight::updateOrCreate( [‘departure’ => ‘Oakland’, ‘destination’ => ‘San Diego’], [‘price’ => 99, ‘discounted’ => 1] ); Here is what the above code is Doing: 1. The updateOrCreate method will attempt to…

PHP Examples

laravel 8 date difference in days

ByAnurag batra October 4, 2022September 6, 2022

$last_date = “2018-01-10 00:00:00”; $current_date = Carbon::now()->toDateTimeString(); //NUMBER DAYS BETWEEN TWO DATES CALCULATOR $start_date = \Carbon\Carbon::createFromFormat(‘Y-m-d H:i:s’, $last_date); $end_date = \Carbon\Carbon::createFromFormat(‘Y-m-d H:i:s’, $current_date); $different_days = $start_date->diffInDays($end_date); Here is what the above code is Doing: 1. We’re creating a variable called $last_date and setting it to a date in the past. 2. We’re creating a variable…

Similar Posts