How to solve the problem of slow opening of phpmyadmin

The tutorial column of phpmyadmin below will introduce to you the solution to the slow opening of phpmyadmin. I hope it will be helpful to friends in need!

The final reason for the slow loading of the phpmyadmin4 series is that the official website of phpmyadmin often cannot be opened recently, and the phpmyadmin page will automatically check the program version update on the official website, so when you enter the phpmyadmin management page and click on the database, phpmyadmin always Trying to connect to the official website slows down the entire opening process.

The final solution is to prevent phpmyadmin from checking for updates, find the version_check.php file in the phpmyadmin directory, and modify it as follows:

The code is as follows:

if (isset($_SESSION['cache']['version_check'])
    && time() < $_SESSION[&#39;cache&#39;][&#39;version_check&#39;][&#39;timestamp&#39;] + 3600 * 6
) {
    $save = false;
    $response = $_SESSION[&#39;cache&#39;][&#39;version_check&#39;][&#39;response&#39;];
} else {
//    $save = true;
//    $file = &#39;http://www.phpmyadmin.net/home_page/version.json&#39;;
//    if (ini_get(&#39;allow_url_fopen&#39;)) {
//        $response = file_get_contents($file);
//    } else if (function_exists(&#39;curl_init&#39;)) {
//        $curl_handle = curl_init($file);
//        curl_setopt($curl_handle, CURLOPT_RETURNTRANSFER, 1);
//        $response = curl_exec($curl_handle);
//    }
}

above The code is to cancel phpmyadmin's connection to the official website version.json by commenting out the middle section of else{...} to check for updates

After the modification, phpmyadmin will immediately return to open within seconds.

Attachment: Another netizen’s solution

The code is as follows:

第一步:
# 文件名 ./libraries/Util.class.php 文件.

# 查找 
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);

#原理: 本地化时间格式化需要gettext支持, 假如你的环境没有开启此功能, 将会返回乱码, 影响#phpmyadmin ajax的处理. 本测试在phpmyadmin 4.0.2 php 5.5.0 环境上验证通过.


# 第二步: ./version_check.php文件.
    $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);
    }
# 将上面这些代码删除或者注释掉. 原因是官方已挂, 这检查升级花费30秒时间.

# 现在退出后, 再登录访问, 看看是不是已经秒开了? 
# 大家试试吧.

The above is the detailed content of How to solve the problem of slow opening of phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!