Many friends find that when using phpmyadmin4.0 or above, they will find that opening is much slower than before. Friends who have used dedecms will encounter the same problem. The solution to dedecms is that remote files are loaded, and phpmyadmin4 also operates in the same way. , so we just need to find the code and delete it.
Many people have found that the speed seems to be much slower after using phpmyadmin4 and later versions. In summary, we provide solutions.
1. Modify localization time
Principle: Localized time formatting requires gettext support. If your environment does not enable this function, garbled characters will be returned, affecting #phpmyadmin ajax processing. This test was verified on the phpmyadmin 4.0.2 php 5.5.0 environment. .
Modify: ./libraries/Util.class.php file
The code is as follows
代码如下 |
复制代码 |
# 查找
return strftime($date, $timestamp);
# 替换成如下代码:
if(extension_loaded('gettext'))
return strftime($date, $timestamp);
# 中国区这样设置.
date_default_timezone_set('UTC');
return gmdate('Y-m-d H:i:s', $timestamp + 28800);
|
|
Copy code
|
# Find
return strftime($date, $timestamp);
# Replace with the following code:
if(extension_loaded('gettext'))
Return strftime($date, $timestamp);
代码如下 |
复制代码 |
$save = true;
$file = 'http://www.phpmyadmin.net/home_page/version.json';
if (ini_get('allow_url_fopen')) {
$response = file_get_contents($file);
} else if (function_exists('curl_init')) {
$curl_handle = curl_init($file);
curl_setopt($curl_handle, CURLOPT_RETURNTRANSFER, 1);
$response = curl_exec($curl_handle);
} |
# China area is set up like this.
date_default_timezone_set('UTC'); |
return gmdate('Y-m-d H:i:s', $timestamp + 28800);
2. Block online upgrades
Principle: The official website of phpmyadmin is GFW. The time to automatically check for updates is wasted waiting in the wall. Just close it
Modify: ./version_check.php file, delete or comment out the following codes
The code is as follows
|
Copy code
$save = true;
$file = 'http://www.phpmyadmin.net/home_page/version.json';
if (ini_get('allow_url_fopen')) {
$response = file_get_contents($file);
} else if (function_exists('curl_init')) {
$curl_handle = curl_init($file);
curl_setopt($curl_handle, CURLOPT_RETURNTRANSFER, 1);
}
After logging out now, log in again to see if it has opened instantly? Let’s try it~
http://www.bkjia.com/PHPjc/633184.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/633184.htmlTechArticleMany friends find that when using phpmyadmin4.0 or above, they will find that opening is much slower than before. If you have used dedecms, Friends will encounter the same problem. The problem is that dedecms is loaded...
|
|