Docker nginx php mysql

Docker running Nginx, PHP-FPM, Composer, MySQL and PHPMyAdmin.

Before installing project make sure the following prerequisites have been met.
We’ll download the code from its repository on GitHub.
[Optional]
We'll generate and configure SSL certificate for nginx before running server.
[Optional]
We'll configure Xdebug for IDE (PHPStorm or Netbeans).
By this point we’ll have all the project pieces in place.
[Optional]
When developing, you can use Makefile for doing recurrent operations.
When running, you can use docker commands for doing recurrent operations.

To run the docker commands without using sudo you must add the docker group to your-user:

sudo usermod -aG docker your-user

For now, this project has been mainly created for Unix (Linux/MacOS). Perhaps it could work on Windows.

All requisites should be available for your distribution. The most important are :

Check if docker-compose is already installed by entering the following command :

which docker-compose

Check Docker Compose compatibility :

The following is optional but makes life more enjoyable :

which make

On Ubuntu and Debian these are available in the meta-package build-essential. On other distributions, you may need to install the GNU C++ compiler separately.

sudo apt install build-essential

You should be careful when installing third party web servers such as MySQL or Nginx.

This project use the following ports :

Server

Port

MySQL

8989

PHPMyAdmin

8080

Nginx

8000

Nginx SSL

3000

git clone https://github.com/nanoninja/docker-nginx-php-mysql.git

Go to the project directory :

cd docker-nginx-php-mysql

.
├── Makefile
├── README.md
├── data
│   └── db
│       ├── dumps
│       └── mysql
├── doc
├── docker-compose.yml
├── etc
│   ├── nginx
│   │   ├── default.conf
│   │   └── default.template.conf
│   ├── php
│   │   └── php.ini
│   └── ssl
└── web
    ├── app
    │   ├── composer.json.dist
    │   ├── phpunit.xml.dist
    │   ├── src
    │   │   └── Foo.php
    │   └── test
    │       ├── FooTest.php
    │       └── bootstrap.php
    └── public
        └── index.php

You can change the host name by editing the .env file.

If you modify the host name, do not forget to add it to the /etc/hosts file.

Generate SSL certificates

```
source .env && docker run --rm -v $(pwd)/etc/ssl:/certificates -e "SERVER=$NGINX_HOST" jacoelho/generate-certificate
```

2. Configure Nginx

Do not modify the `etc/nginx/default.conf` file, it is overwritten by `etc/nginx/default.template.conf`

Edit nginx file `etc/nginx/default.template.conf` and uncomment the SSL server section :

```
# server {
#     server_name ${NGINX_HOST};
#
#     listen 443 ssl;
#     fastcgi_param HTTPS on;
#     ...
# }
```

Get your own local IP address :

```
sudo ifconfig
```

2. Edit php file etc/php/php.ini and comment or uncomment the configuration as needed. 3.

Set the `remote_host` parameter with your IP :

```
xdebug.remote_host=192.168.0.1 # your IP
```

Copying the composer configuration file :

```
cp web/app/composer.json.dist web/app/composer.json
```

2. Start the application :

```
docker-compose up -d
```

**Please wait this might take a several minutes...**

```
docker-compose logs -f # Follow log output
```

Open your favorite browser :

- [http://localhost:8000](http://localhost:8000/)
- [https://localhost:3000](https://localhost:3000/) ([HTTPS](https://github.com/nanoninja/docker-nginx-php-mysql#configure-nginx-with-ssl-certificates) not configured by default)
- [http://localhost:8080](http://localhost:8080/) PHPMyAdmin (username: dev, password: dev)

Stop and clear services

```
docker-compose down -v
```

Name

Description

apidoc

Generate documentation of API

clean

Clean directories for reset

code-sniff

Check the API with PHP Code Sniffer (PSR2)

composer-up

Update PHP dependencies with composer

docker-start

Create and start containers

docker-stop

Stop and clear all services

gen-certs

Generate SSL certificates for nginx

logs

Follow log output

mysql-dump

Create backup of all databases

mysql-restore

Restore backup of all databases

phpmd

Analyse the API with PHP Mess Detector

test

Test application with phpunit

Start the application :

make docker-start

Show help :

make help

docker run --rm -v $(pwd)/web/app:/app composer require symfony/yaml

docker run --rm -v $(pwd)/web/app:/app composer update

docker run --rm -v $(pwd):/data phpdoc/phpdoc -i=vendor/ -d /data/web/app/src -t /data/web/app/doc

docker-compose exec -T php ./app/vendor/bin/phpunit --colors=always --configuration ./app

docker-compose exec -T php ./app/vendor/bin/phpcbf -v --standard=PSR2 ./app/src

docker-compose exec -T php ./app/vendor/bin/phpcs -v --standard=PSR2 ./app/src

docker-compose exec -T php ./app/vendor/bin/phpmd ./app/src text cleancode,codesize,controversial,design,naming,unusedcode

docker-compose exec php php -m

docker exec -it mysql bash

and

mysql -u"$MYSQL_ROOT_USER" -p"$MYSQL_ROOT_PASSWORD"

mkdir -p data/db/dumps

source .env && docker exec $(docker-compose ps -q mysqldb) mysqldump --all-databases -u"$MYSQL_ROOT_USER" -p"$MYSQL_ROOT_PASSWORD" > "data/db/dumps/db.sql"

source .env && docker exec -i $(docker-compose ps -q mysqldb) mysql -u"$MYSQL_ROOT_USER" -p"$MYSQL_ROOT_PASSWORD" < "data/db/dumps/db.sql"

Notice: Replace "YOUR_DB_NAME" by your custom name.

source .env && docker exec $(docker-compose ps -q mysqldb) mysqldump -u"$MYSQL_ROOT_USER" -p"$MYSQL_ROOT_PASSWORD" --databases YOUR_DB_NAME > "data/db/dumps/YOUR_DB_NAME_dump.sql"

source .env && docker exec -i $(docker-compose ps -q mysqldb) mysql -u"$MYSQL_ROOT_USER" -p"$MYSQL_ROOT_PASSWORD" < "data/db/dumps/YOUR_DB_NAME_dump.sql"

<?php
    try {
        $dsn = 'mysql:host=mysql;dbname=test;charset=utf8;port=3306';
        $pdo = new PDO($dsn, 'dev', 'dev');
    } catch (PDOException $e) {
        echo $e->getMessage();
    }
?>

Last updated 1 year ago

Was this helpful?