Building a simple php apache and mysql environment in Docker

• I want to quickly spin up a php apache and mysql environment with Docker on a Remote Sever
• I want to be able to mount a small project code and run on the environment on Docker
• I want to be able to customize your MySQL Database in Docker with pre-populated data
  • There are three ways to pre-populated the data
    1. Import the .sql file with phpMyAdmin manually after the services are up (this one doesn't really count as pre-populated) see code from my branch
    2. Copy the sql scripts into the mysql container startup folder with Dockerfile then build the image with customized database see code from my branch
    3. Bind Mount the sql scripts folder to the startup folder in mysql container see code from my branch

NOTE: make sure your server have port 8080 and 8081 open

I mount the scripts inside the MySQL Docker container, so when the services starts I have an initialed table in it

• There are two sub-folders in the bin folder: one for building db image; one for building app image
• The db sub-folder includes the sql scripts folder to copy to /docker-entrypoint-initdb.d/ when building the image in Dockerfile
• All scripts in docker-entrypoint-initdb.d/ are automatically executed during container startup
• I learn from this article

I created a config foldler with my.cnf file in it, mount it to the /etc/mysql/conf.d in the mysql container

• Because in MySQL 8.0 caching_sha2_password is the default authentication plugin rather than mysql_native_password, which is the default method in MySQL 5.7 and prior.
• I want use the MySQL 8.0 with mysql_native_password so phpMyAdmin can recognize it and connnect to it.
• See reference links from here and here

I copy the Db_conn.php file to /home/ directory in the app container so the PDO utility class can find it. And protect it from being in the public folder.

Getting Started

After git clone the folder to your machine that has docker installed, inside the folder Run

docker-compose up -d

There will be three containers running, check with

docker container ls

Then go to port 8080/views you should see the Home Page of the project

You can go to 8081 login to phpMyAdmin to add or delete records in the table classics, and refresh the index.php page on port 8080 to view to change.

Stop and remove containers by

docker-compose down

Project description

It is a sample project with a table called short_names in test_db database, demostrates create and update and delete records from the short_names table. The home page shows a list of records, and has links to two other pages: add record and update record.