phpMyAdmin中查看DATE, DATETIME, TIMESTAMP类型数据出现[BLOB - 8 字节]的解决方法

本来需要显示为日期时间的数据全部变成带超级链接的[BLOB - 8 字节]：

原因：PHP中没有启用php_mysqli.dll这个扩展。

---

实际上出现这种问题在phpMyAdmin的登录界面也会有提示：

在phpMyAdmin官方的FAQ中说明了具体原因：

1.20 I receive an error about missing mysqli and mysql extensions.

To connect to a MySQL server, PHP needs a set of MySQL functions called “MySQL extension”. This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysqli.so or php_mysqli.dll. phpMyAdmin tried to load the extension but failed. Usually, the problem is solved by installing a software package called “PHP-MySQL” or something similar.

There are currently two interfaces PHP provides as MySQL extensions - mysql and mysqli. The mysqli is tried first, because it’s the best one.

简单来说，php中的两个扩展php_mysql.dll和php_mysqli.dll都能够支持使用phpMyAdmin，但相对而言php_mysqli.dll效果会更好。

解决方法：

在PHP配置文件（PHP目录下的php.ini）中，将

extension=php_mysqli.dll

前的;去掉

然后重启WEB服务器。