Docker With PHP And MySQL

This is a quick tutorial to setup (W|L|M)AMP stack in docker.
You can use either docker or docker toolbox.In this tutorial we are going to cover set of instructions on how to create Development Environment for Docker using PHP, MySQL and Apache webserver.

Docker Installation

1. Install Docker. Download docker from official docker website.

*If you are running Windows OS without Hyper-V, you would need Docker ToolBox installed on your system which uses docker-machine to create and attach to a VM. This machine is a Linux VM that hosts Docker for you and your Windows system.

To setup Docker on your system, click Docker Installation and follow the instructions.

2. In the Docker Quick-Start Terminal, docker-machine ip command will give the ip address of the docker host.

Setting Up Docker

Project Structure

├──docker-php-project
│   └── .dockerfile
│        └──php
│           ├──Dockerfile
│           └── vhost.conf
├──public_html
|   └──index.php
├──database_volume
|   └──docker_tutorial
├──docker-compose.yml
├──custom.ini

Edit docker-php-project/.dockerfile/php/Dockerfile file with following code

FROM php:7.1.8-apache

MAINTAINER Kartikay Kanojia

# Copying public_html folder files into /srv/app folder.
COPY  public_html/ /srv/app
# Overwriting apache config file with our config file.
COPY .docker/php/vhost.conf /etc/apache2/sites-available/000-default.conf

# Installing packages.
RUN docker-php-ext-install mbstring pdo pdo_mysql exif json fileinfo
# Changes ownership of the application files to the Apache www-data user, making files writable by the Apache user.
RUN chown -R www-data:www-data /srv/app \
    && a2enmod rewrite

# Run apt-get update to update the package libraries. Install zlib1g-dev, libicu-dev, g++.
RUN apt-get update && apt-get install -y zlib1g-dev libicu-dev g++
# Install php Intl extention.
RUN docker-php-ext-configure intl
RUN docker-php-ext-install intl

Edit docker-php-project/.dockerfile/php/vhost.conf file with following code

<VirtualHost *:80>
    DocumentRoot /srv/app

    <Directory "/srv/app">
        AllowOverride all
        Require all granted
    </Directory>

    ErrorLog ${APACHE_LOG_DIR}/error.log
    CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>

Edit docker-compose.yml file with following code

version: '3.6'
services:
  # Project service name 'app'.
  app:
    build:
      context: .
      dockerfile: .docker/php/Dockerfile
    # Specify custom container name, rather than a generated default name.
    container_name: my-web-container
    # exposes our app port to container app HOST:CONTAINER.
    ports:
      - 80:80
    # mount the root of our project to the /srv/app folder, 
    # which is where Apache will be looking for our code 
    # (specified in 'vhost.conf' file).
    volumes:
      - ./public_html:/srv/app
      - ./custom.ini:/usr/local/etc/php/conf.d/custom.ini
    # Linking our 'app' service with 'mysql' service
    links:
      - mysql
  # Mysql service
  mysql:
    # pulling latest mysql image.
    image: mysql:latest
    # Exposing mysql port
    ports:
      - 3306:3306
    # Setting 'mysql' environment.
    environment:
      MYSQL_DATABASE: docker_tutorial
      MYSQL_USER: app
      MYSQL_ROOT_PASSWORD: password

Creating Project

Edit public_html/index.php with following code.

<html>
   <head>
      <title>Docker PHP Mysql Tutorial</title>
   </head>
   <body>
      <h1>Hello World!</h1>
      <h4>Attempting MySQL connection from php...</h4>
      <?php
         $host = 'mysql';//Same as mysql service name.
         $user = 'app';
         $pass = 'password';
         $conn = new mysqli($host, $user, $pass);

         if ($conn->connect_error) {
             die("Connection failed: " . $conn->connect_error);
         } 
         echo "Connected to MySQL successfully!";
      ?>
   </body>
</html>

Building PHP, MySQL Docker Image

Building
First we build our image which we modified from official php image (php:7.1.8-apache).

Open CLI of your OS and run docker compose command with up and build option.
Run this command in folder where docker-compose.yml is placed.

docker-compose up --build

Docker download (pull) the PHP image we are extending, it might take a few minutes.
After build completes container start running.

Running
To run docker container run docker compose command.

docker-compose up

Now open your browser and open url
* http://localhost:80 – if you are running docker.
* http://192.168.99.100:80 – if you are running docker toolbox. If this ip does not work then look into docker virtual box machine ip address or in kitematic.

Stopping
Run docker compose command with stop option.

docker-compose stop

You can also press ctrl+c combination in window CLI where docker compose up is used.

Using Volume With MySQL

When ever docker image is rebuilt MySQL data is cleaned because rebuilding delete old data.
To save data we use volume, but the problem is mysql do not copy data to volume because of data folder protection in mysql.
So use MariaDB to save data in volume.

Now we see docker real power. Instead of doing heavy work we can change from mysql to mariadb easily.

Edit docker-compose.yml file with following code

version: '3.6'
services:
  app:
    build:
      context: .
      dockerfile: .docker/php/Dockerfile
    container_name: my-web-container
    ports:
      - 80:80
    volumes:
      - ./public_html:/srv/app
      - ./custom.ini:/usr/local/etc/php/conf.d/custom.ini
    links:
      - mysql
  mysql:
    image: mariadb:latest # CHANGE FROM MYSQL TO MARIADB.
    ports:
      - 3306:3306
    # Specify database volume.
    volumes:
      - ./database_volume:/var/lib/mysql
      - ./database_volume/docker_tutorial:/var/lib/mysql/docker_tutorial
    environment:
      MYSQL_DATABASE: docker_tutorial
      MYSQL_USER: app
      MYSQL_ROOT_PASSWORD: password

Rebuild docker

docker-compose up --build

That’s it, now even after image rebuilding our database is stored in our local machine inside ‘database_volume’ folder.

Docker With PHP And MySQL

Published by admin on August 14, 2018August 14, 2018

Docker Installation

Setting Up Docker

Creating Project

Building PHP, MySQL Docker Image

Using Volume With MySQL

0 Comments

Leave a Reply Cancel reply

Getting started with Docker Toolbox

Docker With PHP And MySQL

Published by admin on August 14, 2018August 14, 2018

Docker Installation

Setting Up Docker

Creating Project

Building PHP, MySQL Docker Image

Using Volume With MySQL

0 Comments

Leave a Reply Cancel reply

Related Posts

Getting started with Docker Toolbox