Php Mysqli Extension Is Missing Windows Driver

Php Mysqli Extension Is Missing Windows Driver Average ratng: 6,9/10 4639 votes
Active2 months ago

Move libmysql.dll to: WINDOWS or: WINNT. For php 5 (i think) you have to add mysql (extension=phpmysql.dll) to the extensions list. I have both mysql and mysqli extensions loaded on my local server, so i can use either one for mysql 4.1. Stack Exchange Network. Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. Visit Stack Exchange. Recently I discovered that mysqli extension is not installed in my server Centos version 2.6. I confirm it because I change the driver of db connection from mysqli to mysql and now works fine. So, is there another way/log to determinate this problem? Because the apache errorlog does not say anything about it.

How to install MySQL drivers for php 7 on windows system?

Error: - Installation request for pear-pear.php.net/mdb2_driver_mysql 1.4.1 -> satisfiable by pear-pear.php.net/MDB2_Driver_mysql[1.4.1]. - pear-pear.php.net/MDB2_Driver_mysql 1.4.1 requires ext-mysql * -> the requested PHP extension mysql is missing from your system.

Problem 2 - Installation request for pear-pear.php.net/validate_au 0.1.4 -> satisfiable by pear-pear.php.net/Validate_AU[0.1.4]. - pear-pear.php.net/Validate_AU 0.1.4 requires php >=4.2.0.0,<=6.0.0.0 -> your PHP version (7.1.4) does not satisfy that requirement

RiggsFolly
75.3k18 gold badges78 silver badges118 bronze badges
Arjun BaligaArjun Baliga

2 Answers

I guess you haven't enabled mysql in your XAMPP server yet. To do that:

Mysqli Extension Download

At first close all running services of xampp. Now, go to your xampp folder. Then go to php folder and open the file named php.ini with any text editor. Now search for mysql in that file. You will find a line stating ;extension=php_mysqli.dll. The ; symbol describes it as a comment that means it is not enabled yet. Simply cut out that ; sign in front of that line which will now look like extension=php_mysqli.dll. Finally save the file and restart xampp.

Rakibul IslamRakibul Islam
2,7883 gold badges18 silver badges32 bronze badges

PHP7 does not have the mysql_ database extension any more. Its dead Jim

Arjun BaligaArjun Baliga

Not the answer you're looking for? Browse other questions tagged phpmysqlcomposer-phpphp-7 or ask your own question.

Active5 days ago

I have installed PHP 7, MySQL 5.5.47 on Ubuntu 14.04.I have checked installed extension using :

Its output me:

I am not able to see MySQLi extension using phpinfo() as well,please let me know,how can I enable/install MySQLi extension in PHP 7.That's why I cannot use phpmyadmin, its says 'The mysqli extension is missing.'

Extension

Note: I am new in php7.

Mohd SayeedMohd Sayeed
8911 gold badge8 silver badges22 bronze badges

6 Answers

The problem is that the package that used to connect PHP to MYSQL is depricated (php5-mysql). If you install the new package:

This will automatically update apache and php7.

Cheers!

XenoXeno

New Mysqli Php

1,1903 gold badges9 silver badges7 bronze badges

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

Now MySQLi working well.Here is php.ini file path in apache2,PHP 7, Ubuntu 14.04 environment:

By Default MySQLi extension is disable in PHP 7.

Mohd SayeedUpdateMohd Sayeed
8911 gold badge8 silver badges22 bronze badges
  • phpenmod moduleName enables a module to php7 (restart apache after that sudo service apache2 restart)
  • phpdismod moduleName disables a module to php7 (restart apache after that sudo service apache2 restart)
  • php -m lists the loaded modules
PipoPipo

In ubuntu need to uncommented this line in php.ini which is located at /etc/php/7.0/apache2/php.ini

extension=php_mysqli.so

Atul PandyaAtul Pandya

On ubuntu,

When mysqli is missingexecute the following,

replace 7.x with your PHP version.

note: This could be 7.0 and up, but for example Drupal recommends 'php7.2' on grounds of security a.o.

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

You do exactly the same if you are missing mbstring

I recently had to do this for PHPmyadmin when upgrading php from 7.0 to 7.2on Ubuntu 16.04 .

Marco SchoolenbergMarco Schoolenberg

Let's use

mysqli_connect

instead of

mysql_connect

because mysql_connect isn't supported in php7.

Tiago Martins Peres
2,2847 gold badges20 silver badges37 bronze badges
Kratos.vnKratos.vn

protected by CommunityNov 29 '17 at 10:16

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged phpmysqlmysqliphp-7 or ask your own question.

Comments are closed.