How to develop Dockerized applications using PHP + MySQL?
![]() In program development, it is definitely not enough to only know one technology. The development of many applications requires the use of multiple technologies. Today we will talk to you about how to build a Linux + Apache + MySQL + PHP application based on the LAMP technology stack and using Docker images.
1. Create a PHP development application container
First, select the official PHP image as the base image of the project.
dockerfile
FROMdaocloud.io/php:5.6-apache
Next, use the official PHP image built-in command docker-php-ext-install to install PHP’s MySQL extension dependency.
dockerfile
RUNdocker-php-ext-install pdo_mysql
The dependency package is installed through docker-php-ext-install. If the dependency package requires configuration parameters, use the docker-php-ext-configure command.
Install pdo_mysql PHP extension.
Then, copy the code to the target directory.
dockerfile
COPY ./var/www/html/
Because the exposed port and startup command have been declared in the base image, they can be omitted here.
At this point, the Docker container containing PHP application development is ready. The parameters required to access the database in PHP code are declared by reading environment variables.
```php
$serverName =env("MYSQL_PORT_3306_TCP_ADDR", "localhost");
$databaseName = env("MYSQL_INSTANCE_NAME","homestead");
$username = env(" MYSQL_USERNAME","homestead");
$password =env("MYSQL_PASSWORD", "secret");
/**
* Get environment variables
* @param $key
* @param null$default
* @returnnull|string
*/
functionenv($key, $default = null)
{
$value =getenv($key);
if ($value ===false) {
return $default;
www.maiziedu.com
}
return $value;
}
```
Why do you do this? Because in the best practices of Docker application development, stateful data services are usually run in another container, and the application container and data container are dynamically connected through the container-specific link mechanism.
2. Bind the local MySQL data container
First, you need to create a MySQL container.
bash
docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d daocloud.io/mysql:5.5
After that, through the link mechanism between Docker containers, the default port of MySQL can be changed (3306) Exposed to the application container.
bash
docker run --name some-app --link some-mysql:mysql -d app-that-uses-mysql
3. Bind the cloud MySQL data service
Compared to creating it locally, It will be easier to create and bind MySQL data services in the cloud.
a. Fork DaoCloud/php-apache-mysql-sample on GitHub or add your own code repository.
b. Register as a DaoCloud user.
c. Select "Code Build" in the DaoCloud "Console".
d. Create a new project, select the code source, and start building the image.
e. Create a MySQL service instance in "Service Integration".
f. Associate the built application image with the MySQL service instance and deploy it in the cloud.
The above are the specific steps to implement Docker application through PHP + MySQL. If you are still unclear, you can try it yourself.
Recommended learning: php video tutorial http://www.maiziedu.com/course/php/
|

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



Alipay PHP...

JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,

The application of SOLID principle in PHP development includes: 1. Single responsibility principle (SRP): Each class is responsible for only one function. 2. Open and close principle (OCP): Changes are achieved through extension rather than modification. 3. Lisch's Substitution Principle (LSP): Subclasses can replace base classes without affecting program accuracy. 4. Interface isolation principle (ISP): Use fine-grained interfaces to avoid dependencies and unused methods. 5. Dependency inversion principle (DIP): High and low-level modules rely on abstraction and are implemented through dependency injection.

How to automatically set the permissions of unixsocket after the system restarts. Every time the system restarts, we need to execute the following command to modify the permissions of unixsocket: sudo...

How to debug CLI mode in PHPStorm? When developing with PHPStorm, sometimes we need to debug PHP in command line interface (CLI) mode...

Article discusses late static binding (LSB) in PHP, introduced in PHP 5.3, allowing runtime resolution of static method calls for more flexible inheritance.Main issue: LSB vs. traditional polymorphism; LSB's practical applications and potential perfo

Sending JSON data using PHP's cURL library In PHP development, it is often necessary to interact with external APIs. One of the common ways is to use cURL library to send POST�...

Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.
