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服务器。