Lumen timezone time zone setting method

When I used the Lumen framework to write code today, it was also my first time to experience Lumen. I encountered a problem. The time found from the database was 8 hours slower than the TIMESTAMP time saved in the database. Obviously this is a time zone setting problem. , I thought it could be solved within 1 minute, but I was wrong

According to the experience of Laravel 4.x and 5.0, you only need to set the 'timezone' parameter to 'PRC' in config/app.php Just fine, find Lumen's config directory, under the /vendor/laravel/lumen-framework/config path, but there is no timezone parameter option in the parameter options of config/app.php, and it is invalid even if it is added manually.

Then I thought about the .env file of Laravel 5, and found that there is no option for timezone setting in Lumen’s .env file.

Go back to the config directory and look at the settings in config/database.php. The default configuration for mysql is as follows:

'mysql' => [
 'driver'  => 'mysql',
 'host'   => env('DB_HOST', 'localhost'),
 'port'   => env('DB_PORT', 3306),
 'database' => env('DB_DATABASE', 'forge'),
 'username' => env('DB_USERNAME', 'forge'),
 'password' => env('DB_PASSWORD', ''),
 'charset'  => 'utf8',
 'collation' => 'utf8_unicode_ci',
 'prefix'  => env('DB_PREFIX', ''),
 'timezone' => env('DB_TIMEZONE','+00:00'),
 'strict'  => false,
],

In There is a database timezone setting here. The default is 00:00, which is UTC time. Changing it to 08:00 solves the problem. Since the project enabled the .env configuration file, a line

DB_TIMEZONE= 08:00

was finally added to the .env file. The database timezone problem was solved.

Although the timezone problem of the database has been solved, the timezone problem of the app has not been solved. Search the lumen project globally to find the place where timezone is used. It is in /vendor/laravel/lumen-framework/src/ The code for initializing the lumen timezone part was found in the Application.php file

/**
* Create a new Lumen application instance.
*
* @param string|null $basePath
* @return void
*/
public function __construct($basePath = null)
{
 date_default_timezone_set(env('APP_TIMEZONE', 'UTC'));
 $this->basePath = $basePath;
 $this->bootstrapContainer();
 $this->registerErrorHandling();
}

The .env parameter used in the code is APP_TIMEZONE, and the value is UTC. Here, change UTC to PRC, or add

APP_TIMEZONE=PRC

lumen php's time zone setting problem in the .env file.

Summary of Lumen time zone settings

Edit .env file to add configuration

APP_TIMEZONE=PRC
DB_TIMEZONE=+08:00

If it is not enabled .env configuration file, edit

/vendor/laravel/lumen-framework/config/database.php
/vendor/laravel/lumen-framework/src/Application.php

to modify the APP_TIMEZONE and DB_TIMEZONE parameter values ​​respectively.

Enable .env configuration file

Rename the .env.example file in the Lumen root directory to .env, edit /bootstrap/app.php, and cancel as follows Comments on the line of code
Dotenv::load(__DIR__.'/../');

Addition:

Because lumen uses Greenwich time by default, it needs to be converted to Beijing time.
Add

APP_TIMEZONE=PRC to .env
DB_TIMEZONE= 08:00

The time will be correct

Related recommendations:

Explanation of the simple implementation method of nginx real-time output

Detailed explanation of PHP comment syntax specifications and naming specifications

php language comments, single-line comments and multi-line comments related content

The above is the detailed content of Lumen timezone time zone setting method. For more information, please follow other related articles on the PHP Chinese website!