how to install mysqli extension for php7?

[zjsxwc]

hello,

my container is from php:7.0-fpm

i started to run phpmyadmin, but got

The mysqli extension is missing

i then checked the directoy

ls /usr/local/lib/php/extensions/no-debug-non-zts-20151012
opcache.a  opcache.so  pdo.so  pdo_mysql.so

then i seach by apt-cache got nothing

 apt-cache search php7-*

how to install mysqli extension for php7?

[estahn]

@zjsxwc https://github.com/docker-library/docs/tree/master/php#php-core-extensions

[bommox]

You can easily add this to your Dockerfile
RUN docker-php-ext-install mysqli && docker-php-ext-enable mysqli

or docker run the image, and then install it from inside the container:

docker exec -ti <your-php-container> sh
>> docker-php-ext-install mysqli 
>> docker-php-ext-enable mysqli
>> apachectl restart

[loooping-old]

You can easily add this to your Dockerfile
RUN docker-php-ext-install mysqli && docker-php-ext-enable mysqli

or docker run the image, and then install it from inside the container:

docker exec -ti <your-php-container> sh
>> docker-php-ext-install mysqli 
>> docker-php-ext-enable mysqli
>> apachectl restart

thank u so much

[pmpintogil]

You can easily add this to your Dockerfile
RUN docker-php-ext-install mysqli && docker-php-ext-enable mysqli

or docker run the image, and then install it from inside the container:

docker exec -ti <your-php-container> sh
>> docker-php-ext-install mysqli 
>> docker-php-ext-enable mysqli
>> apachectl restart

Thankyou so much, that was a problem for some days.

[boxboatjeremy]

I ran into this exact problem today and was able to update the Dockerfile by adding this line:

RUN docker-php-ext-install mysqli

Unlike some of the comments above, I did not need to run the docker-php-ext-enable command.

[Mr-Reca]

Hi, I'm having the same issue.

This is my Dockerfile

FROM php:7.0-apache
WORKDIR /var/www/html
RUN apt-get update && apt-get install -y mysql-client
RUN docker-php-ext-install mysqli pdo pdo_mysql
RUN docker-php-ext-enable mysqli

This is what I'm receiving:
Fatal error: Uncaught Error: Class 'mysqli' not found in /var/www/html/....

[JoelLinn]

What is the workdir for? Try to move that after the last RUN or remove it.
Also what do you need mysql-client for in a php container?

[Mr-Reca]

My PHP application connects to a MySQL Server. The program uses mysqli and some answers include the installation of those packages.

[JoelLinn]

mysql-client is only needed for command line access to the database. Even if you want to do it you most probably want to do it from outside or another container.

[Mr-Reca]

I've removed the WORKDIR and now it's working...

[sohmc]

These instructions were perfect but I'm having difficulty adding the necessary commands to my docker-compose file.

Each time the container is stopped and restarted, I have to manually execute the install. Is there a way to add it to a docker-compose.yml file? I tried adding:

command: "/bin/sh -c 'docker-php-ext-install mysqli && apachectl restart'"

But after doing so the container stops prematurely.

[JoelLinn]

You need to create your own image with a Dockerfile based on (FROM php:xy) the version you want in which you install mysqli via RUN docker-php-ext-install ... and reference that from your compose file. Restarting the apache of course stops the container, because apache is its main process - it is unneeded anyways in the Dockerfile

[sohmc]

@JoelLinn thanks for the comment. It's just odd because when I run apachectl restart from within the container, it doesn't stop the container and everything works as normal. Hmm...

That being said, sounds like creating my own Dockerfile is the way to go.