当前位置： 文江博客话题详情

如何在PHP 7中启用MySQLI扩展名？

发布于 2025-02-13 09:29:54 字数 1952 浏览 1 评论 0原文

我已经在Ubuntu＆nbsp; 14.04（可信赖的Tahr）上安装了PHP 7和MySQL 5.5.47。

我已经使用以下方式检查了安装的扩展名：

sudo apt-cache search php7-*

IT输出：

php7.0-common - Common files for packages built from the PHP source
libapache2-mod-php7.0 - server-side, HTML-embedded scripting language (Apache 2 module)
php7.0-cgi - server-side, HTML-embedded scripting language (CGI binary)
php7.0-cli - command-line interpreter for the PHP scripting language
php7.0-phpdbg - server-side, HTML-embedded scripting language (PHPDBG binary)
php7.0-fpm - server-side, HTML-embedded scripting language (FPM-CGI binary)
libphp7.0-embed - HTML-embedded scripting language (Embedded SAPI library)
php7.0-dev - Files for PHP7.0 module development
php7.0-dbg - Debug symbols for PHP7.0
php7.0-curl - CURL module for PHP
php7.0-enchant - Enchant module for PHP
php7.0-gd - GD module for PHP
php7.0-gmp - GMP module for PHP
php7.0-imap - IMAP module for PHP
php7.0-interbase - Interbase module for PHP
php7.0-intl - Internationalisation module for PHP
php7.0-ldap - LDAP module for PHP
php7.0-mcrypt - libmcrypt module for PHP
php7.0-readline - readline module for PHP
php7.0-odbc - ODBC module for PHP
php7.0-pgsql - PostgreSQL module for PHP
php7.0-pspell - pspell module for PHP
php7.0-recode - recode module for PHP
php7.0-snmp - SNMP module for PHP
php7.0-tidy - tidy module for PHP
php7.0-xmlrpc - XMLRPC-EPI module for PHP
php7.0-xsl - XSL module for PHP
php7.0 - server-side, HTML-embedded scripting language (metapackage)
php7.0-json - JSON module for PHP
php-all-dev - package depending on all supported PHP development packages
php7.0-sybase - Sybase module for PHP
php7.0-sqlite3 - SQLite3 module for PHP
php7.0-mysql - MySQL module for PHP
php7.0-opcache - Zend OpCache module for PHP
php7.0-bz2 - bzip2 module for PHP

我也无法使用phpinfo（）看到MySQLI扩展。如何在PHP; 7中启用/安装MySQLI扩展名？

这就是为什么我不能使用phpmyadmin。它说：“ Mysqli扩展名没有。”

原文

I have installed PHP 7 and MySQL 5.5.47 on Ubuntu 14.04 (Trusty Tahr).

I have checked installed extension using:

sudo apt-cache search php7-*

It outputs:

php7.0-common - Common files for packages built from the PHP source
libapache2-mod-php7.0 - server-side, HTML-embedded scripting language (Apache 2 module)
php7.0-cgi - server-side, HTML-embedded scripting language (CGI binary)
php7.0-cli - command-line interpreter for the PHP scripting language
php7.0-phpdbg - server-side, HTML-embedded scripting language (PHPDBG binary)
php7.0-fpm - server-side, HTML-embedded scripting language (FPM-CGI binary)
libphp7.0-embed - HTML-embedded scripting language (Embedded SAPI library)
php7.0-dev - Files for PHP7.0 module development
php7.0-dbg - Debug symbols for PHP7.0
php7.0-curl - CURL module for PHP
php7.0-enchant - Enchant module for PHP
php7.0-gd - GD module for PHP
php7.0-gmp - GMP module for PHP
php7.0-imap - IMAP module for PHP
php7.0-interbase - Interbase module for PHP
php7.0-intl - Internationalisation module for PHP
php7.0-ldap - LDAP module for PHP
php7.0-mcrypt - libmcrypt module for PHP
php7.0-readline - readline module for PHP
php7.0-odbc - ODBC module for PHP
php7.0-pgsql - PostgreSQL module for PHP
php7.0-pspell - pspell module for PHP
php7.0-recode - recode module for PHP
php7.0-snmp - SNMP module for PHP
php7.0-tidy - tidy module for PHP
php7.0-xmlrpc - XMLRPC-EPI module for PHP
php7.0-xsl - XSL module for PHP
php7.0 - server-side, HTML-embedded scripting language (metapackage)
php7.0-json - JSON module for PHP
php-all-dev - package depending on all supported PHP development packages
php7.0-sybase - Sybase module for PHP
php7.0-sqlite3 - SQLite3 module for PHP
php7.0-mysql - MySQL module for PHP
php7.0-opcache - Zend OpCache module for PHP
php7.0-bz2 - bzip2 module for PHP

I am not able to see the MySQLi extension using phpinfo() either. How can I enable/install MySQLi extension in PHP 7?

That's why I cannot use phpMyAdmin. It says "The mysqli extension is missing."

如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论， 你可以免费 注册 一个本站的账号。

评论（8）

-柠檬树下少年和吉他 2025-02-20 09:29:54

问题在于，将用于将PHP连接到MySQL的软件包被弃用（PHP5-MYSQL）。如果安装新软件包，

sudo apt-get install php-mysql

这将自动更新Apache和Php＆nbsp; 7。

The problem is that the package that used to connect PHP to MySQL is deprecated (php5-mysql). If you install the new package,

sudo apt-get install php-mysql

this will automatically update Apache and PHP 7.

回复 原文
清音悠歌 2025-02-20 09:29:54

对于所有Docker用户，只需从php容器内部运行Docker-Php-ext-install Mysqli即可。

更新：有关 https://hub.docker.com/_/php 的更多信息“如何安装更多PHP扩展”。

For all docker users, just run docker-php-ext-install mysqli from inside your php container.

Update: More information on https://hub.docker.com/_/php in the section "How to install more PHP extensions".

回复 原文
活泼老夫 2025-02-20 09:29:54
sudo phpenmod mysqli
sudo service apache2 restart
  • phpenmod modulename启用一个模块以php＆nbsp; 7（在此重新启动apache之后sudo service apache2 restart）
  • phpdismod modulename将模块禁用到PHP; 7（7（7））在那之后重新启动apache sudo service apache2 restart）
  • php -m列出已加载的模块
sudo phpenmod mysqli
sudo service apache2 restart
  • phpenmod moduleName enables a module to PHP 7 (restart Apache after that sudo service apache2 restart)
  • phpdismod moduleName disables a module to PHP 7 (restart Apache after that sudo service apache2 restart)
  • php -m lists the loaded modules
回复 原文
笨死的猪 2025-02-20 09:29:54

我得到了解决方案。我能够在php.ini中启用mysqli扩展。我只是在php.ini中毫不费力地说明了这条线：

extension=php_mysqli.dll

现在mysqli运行良好。这是php.ini apache 2，php＆nbsp; 7和ubuntu＆nbsp; 14.04环境中的文件路径：

/etc/php/7.0/apache2/php.ini

默认情况下，php＆nbsp; 7中禁用了mysqli扩展名。

I got the solution. I am able to enable MySQLi extension in php.ini. I just uncommented this line in php.ini:

extension=php_mysqli.dll

Now MySQLi is working well. Here is the php.ini file path in an Apache 2, PHP 7, and Ubuntu 14.04 environment:

/etc/php/7.0/apache2/php.ini

By default, the MySQLi extension is disabled in PHP 7.

回复 原文
可遇━不可求 2025-02-20 09:29:54

在Ubuntu上，当Mysqli缺失时，执行以下操作，

sudo apt-get install php7.x-mysqli

sudo service apache2 restart

将7.x替换为PHP版本。

注意：这可能是7.0及以上，但是例如，Drupal建议在安全方面推荐Php＆nbsp; 7.2。

要检查您的PHP版本，请在命令行类型上

php -v

进行：如果您缺少MBSTRING，则完全相同：

apt-get install php7.x-mbstring

service apache2 restart

我最近必须为PHPMyAdmin执行此操作，而

On Ubuntu, when mysqli is missing, execute the following,

sudo apt-get install php7.x-mysqli

sudo service apache2 restart

Replace 7.x with your PHP version.

Note: This could be 7.0 and up, but for example Drupal recommends PHP 7.2 on grounds of security among others.

To check your PHP version, on the command-line type:

php -v

You do exactly the same if you are missing mbstring:

apt-get install php7.x-mbstring

service apache2 restart

I recently had to do this for phpMyAdmin when upgrading PHP from 7.0 to 7.2 on Ubuntu 16.04 (Xenial Xerus).

回复 原文
梦里南柯 2025-02-20 09:29:54

在ubuntu中，您需要在 /etc/php/7.0/apache2/php.ini 的文件中删除此行 php.ini ：

extension=php_mysqli.so

In Ubuntu, you need to uncomment this line in file php.ini which is located at /etc/php/7.0/apache2/php.ini:

extension=php_mysqli.so
回复 原文
生来就爱笑 2025-02-20 09:29:54

如果是docker，则在安装mysqli之后按上面的快速答案代码>您应该根据此答案重新启动FPM https://stackoverflow.com/a/a/43076457/932473

来自内部容器

kill -USR2 1

In case of docker after installing the mysqli as per Speedy's answer above docker-php-ext-install mysqli you should restart the the fpm as per this answer https://stackoverflow.com/a/43076457/932473

From inside container

kill -USR2 1
回复 原文
橘香 2025-02-20 09:29:54

让我们

mysqli_connect

而不是

mysql_connect

因为 php＆nbsp; 7 中不支持mysql_connect。

Let's use

mysqli_connect

instead of

mysql_connect

because mysql_connect isn't supported in PHP 7.

回复 原文
~没有更多了~

关于作者

情归归情

暂无简介

文章
评论
26 人气
发私信

相关话题

更多

热门标签

操作系统 程序设计 IT运维 Linux系统管理 JavaScript 服务器应用 solaris C/C++ PHP Shell BSD Vue.js aix Oracle Python HTML 系统管理 HTML5 CSS 前端
更多

推荐作者

十二

文章 0 评论 0

飞烟轻若梦

文章 0 评论 0

OPleyuhuo

文章 0 评论 0

wxb0109

文章 0 评论 0

旧城空念

文章 0 评论 0

-小熊_

文章 0 评论 0

更多

友情链接

文江博客
    我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站，即表示您同意使用 Cookies 和您的相关数据。
    原文