<?phptry{$db=sprintf('mysql:host=%s:3306;dbname=%s','mysql','mydb');$dbh=newPDO($db,'appuser','appuser1');foreach($dbh->query('select * from users')as$row){echo$row['name'].'<br>';}$dbh=null;}catch(PDOException$e){echo$e;die();}$dbh=null;
FROM mysql:8.0EXPOSE 3306ADD ./my.cnf /etc/mysql/conf.d/my.cnfCMD ["mysqld"]
./mysql/init/init.sql
適当なテーブルとデータを詰め込むような記述にしておく
use mydb;
CREATE TABLE users (
id int(10) unsigned not null auto_increment,
name varchar(255) not null,
primary key (id)
);
insert into users(name) values('hogeo');
insert into users(name) values('fugao');
FROM php:7.4-apache
COPY ./php.ini /usr/local/etc/php/
RUN apt-get update
RUN apt-get install -y zip unzip vim libpng-dev libpq-dev
RUN docker-php-ext-install pdo_mysql
ksk@ksknoMacBook-Pro work % docker-compose build
〜〜〜中略〜〜〜
Successfully built e5b1c15e825e
Successfully tagged work_php-apache:latest
Building mysql
Step 1/4 : FROM mysql:8.0
---> d4c3cafb11d5
Step 2/4 : EXPOSE 3306
---> Using cache
---> e11d55e213ab
Step 3/4 : ADD ./my.cnf /etc/mysql/conf.d/my.cnf
---> Using cache
---> 6dd70a6b7ecd
Step 4/4 : CMD ["mysqld"]
---> Using cache
---> c22190479ddf
Successfully built c22190479ddf
Successfully tagged work_mysql:latest
コンテナ作成&起動
ksk@ksknoMacBook-Pro work % docker-compose up -d
Creating web ... done
Creating db ... done
確認
コンテナの状態確認
ksk@ksknoMacBook-Pro work % docker container ls -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
b416b97d3f7b work_mysql "docker-entrypoint.s…" 2 seconds ago Up 2 seconds 0.0.0.0:3306->3306/tcp, 33060/tcp db
9985abb2eb90 work_php-apache "docker-php-entrypoi…" 2 seconds ago Up 2 seconds 0.0.0.0:8080->80/tcp web
/**
* First we will load all of this project's JavaScript dependencies which
* includes React and other helpers. It's a great starting point while
* building robust, powerful web applications using React + Laravel.
*/require('./bootstrap');/**
* Next, we will create a fresh React component instance and attach it to
* the page. Then, you may begin adding components to this application
* or customize the JavaScript scaffolding to fit your unique needs.
*/require('./components/Example');require('./components/Answer');//追記
