How can I enable the MySQLi extension in PHP 7

Question

I have installed PHP 7 and MySQL 5 5 47 on Ubuntu nbsp 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 nbsp 7   That s why I cannot use phpMyAdmin  It says  The mysqli extension is missing

User · Accepted Answer

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 nbsp 7  and Ubuntu nbsp 14 04 environment    etc php 7 0 apache2 php ini   By default  the MySQLi extension is disabled in PHP nbsp 7

User · Answer

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 nbsp 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 nbsp 16 04  Xenial Xerus

User · Answer

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

User · Answer

Let s use  mysqli connect   instead of  mysql connect   because mysql connect isn t supported in PHP nbsp 7

User · Answer

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 nbsp 7

User · Answer

sudo phpenmod mysqli sudo service apache2 restart      phpenmod moduleName enables a module to PHP nbsp 7  restart Apache after that sudo service apache2 restart  phpdismod moduleName disables a module to PHP nbsp 7  restart Apache after that sudo service apache2 restart  php -m lists the loaded modules

User · Answer

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  quot How to install more PHP extensions quot

[php] How can I enable the MySQLi extension in PHP 7?

Examples related to php

Examples related to mysql

Examples related to mysqli

Examples related to php-7