What should I do if the time displayed in phpmyadmin is garbled?

Solution to garbled time display in phpmyadmin: First open the file [common.lib.php]; then change the code [$format=__('%B %d, %Y at %I:%M %p ')] to [$format = '%Y-%m-%d %H:%M].

Solution to phpmyadmin time display garbled code:

Filelibraries/common.lib.php, line 1648

Change the following code:

 $format = __('%B %d, %Y at %I:%M %p');

to

$format = '%Y-%m-%d %H:%M:%S';

, date format display format example

2020-7-20 11:49:07

Reason:

PMA_localisedDateFunction usage The strftime() function is used. The first parameter of the strftime function is the date format. The phpmyadmin source program uses a format string with Chinese characters; while the PHP version under Windows will convert it when formatting. into gibberish. It has been confirmed that there is no such problem under Linux and pma is normal.

Related tutorial recommendations: phpmyadmin

The above is the detailed content of What should I do if the time displayed in phpmyadmin is garbled?. For more information, please follow other related articles on the PHP Chinese website!