How to use MySQL in PHP builds

Sometimes when running a build or testing your app a database is required for interaction. The most common use case includes PHP and MySQL. In Buddy, you can easily add MySQL to the executed action, along with many other services. Such service is nothing else but a Docker container attached to the main container in which the build is performed.

Image loading...[画像:Basic idea behind Docker container]

It's like installing an SQL server on the remote host, with connection data available after the installation.

Step 1: Add the service

Go to the PHP and switch to the Services tab. Select MySQL from the dropdown list:

Image loading...[画像:Adding a new service]

Step 2: Add connection details

Once the database is attached, you will see connection details which should be put in the configuration file of our application. In this example, we'll use an .env file:

Image loading...[画像:Filesystem tab]

Step 3: Prepare PHP container for MySQL

Switch to the Environment tab, click Install PHP extensions under the command window, and select the package for MySQL:

Image loading...[画像:Selecting PHP extension]

This will add a couple of new lines to the customization window:

Image loading...[画像:Environment customization]

Step 4: Connect to the database

At this moment you should have a fully working environment in which you can interact with your database. The last step is connecting to the database so you can run SQL commands:

default
mysql -h mysql -u root -proot --execute='CREATE DATABASE IF NOT EXISTS buddy_test;'

Image loading...[画像:Run commands]