(资料图片)
本教程操作环境:windows7系统、PHP8.1版、Dell G3电脑。
php无法连接mysqli怎么办?
PHP连接MySql,解决 ”Uncaught Error: Class ‘mysqli‘ not found“问题
我的PHP是7.4的,但是mysql扩展好像是5以前的,我就只能用mysqli扩展来操作数据库
我看了几十篇回答,我的错误是phpinfo()页面只有一个mysqlnd,没有mysqli,所以网页会报错 ”Uncaught Error: Class ‘mysqli’ not found“
在php.ini里
extension_dir = “ext” 也改成绝对路径了,;extension=php_mysqli.dll前面的 ; 也去掉了,还是不行
最后发现下面这段
[MySQLi]; Maximum number of persistent links. -1 means no limit.; http://php.net/mysqli.max-persistentmysqli.max_persistent = -1; Allow accessing, from PHP’s perspective, local files with LOAD DATA statements; http://php.net/mysqli.allow_local_infile;mysqli.allow_local_infile = On; Allow or prevent persistent links.; http://php.net/mysqli.allow-persistentmysqli.allow_persistent = On; Maximum number of links. -1 means no limit.; http://php.net/mysqli.max-linksmysqli.max_links = -1; Default port number for mysqli_connect(). If unset, mysqli_connect() will use; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the; compile-time value defined MYSQL_PORT (in that order). Win32 will only look; at MYSQL_PORT.; http://php.net/mysqli.default-portmysqli.default_port = 3306; Default socket name for local MySQL connects. If empty, uses the built-in; MySQL defaults.; http://php.net/mysqli.default-socketmysqli.default_socket =; Default host for mysqli_connect() (doesn’t apply in safe mode).; http://php.net/mysqli.default-hostmysqli.default_host =; Default user for mysqli_connect() (doesn’t apply in safe mode).; http://php.net/mysqli.default-usermysqli.default_user =; Default password for mysqli_connect() (doesn’t apply in safe mode).; Note that this is generally a bad idea to store passwords in this file.; Any user with PHP access can run "echo get_cfg_var(“mysqli.default_pw”); and reveal this password! And of course, any users with read access to this; file will be able to reveal the password as well.; http://php.net/mysqli.default-pwmysqli.default_pw =; Allow or prevent reconnectmysqli.reconnect = OFF
登录后复制
将mysqli.reconnect = OFF
改成mysqli.reconnect = on
就行了,就很无语,有跟我情况一样的可以改改这个
推荐学习:《PHP视频教程》
以上就是php无法连接mysqli怎么办的详细内容,更多请关注php中文网其它相关文章!