第3次实践作业

（1）完成Docker-compose的安装

由于官方提供的下载方式速度过慢，从网上找到了换源的方案
进入root用户

sudo -i

进行Docker-compose安装

curl -L "https://get.daocloud.io/docker/compose/releases/download/1.25.4/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose

查看安装是否成功

docker-compose --version

（2）Dockerfile编写

选择LNMP（Linux+Nginx+Mysql+PHP）完成实验
目录结构

dockerfile_nginx

#基础镜像
FROM nginx
#作者信息
MAINTAINER by ruifeng1<460886524@qq.com>
#声明暴露的端口
EXPOSE 2020

dockerfile_mysql

#基础镜像
FROM mysql
#作者信息
MAINTAINER by ruifeng1<460886524@qq.com>
#设置root密码
ENV MYSQL_ROOT_PASSWORD 123456
#设置不可免密登录
ENV MYSQL_ALLOW_EMPTY_PASSWORD no

dockerfile_php

#基础镜像
FROM php:7.4-fpm
#作者信息
MAINTAINER by ruifeng1<460886524@qq.com>
FROM php:7.4-fpm
RUN apt-get update && apt-get install -y 
        libfreetype6-dev 
        libjpeg62-turbo-dev 
        libpng-dev 
    && docker-php-ext-install pdo_mysql 
    && docker-php-ext-configure gd --with-freetype --with-jpeg 
    && docker-php-ext-install -j$(nproc) gd

default.conf

server {
    listen       2020; #修改映射端口
    server_name  localhost;

    #charset koi8-r;
    #access_log  /var/log/nginx/host.access.log  main;

    location / {
        root   /home/docker_compose/html; #修改工作目录
        index  index.html index.htm index.php;
    }

    #error_page  404              /404.html;

    # redirect server error pages to the static page /50x.html
    #
    error_page   500 502 503 504  /50x.html;
    location = /50x.html {
        root   /usr/share/nginx/html;
    }

    # proxy the PHP scripts to Apache listening on 127.0.0.1:80
    #
    #location ~ .php$ {
    #    proxy_pass   http://127.0.0.1;
    #}

    # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
    #
    #location ~ .php$ {
    #    root           /home/docker_compose/php; #修改工作目录
    #    fastcgi_pass   lrfphp:9000; #修改为容器名
    #    fastcgi_index  index.php;
    #    fastcgi_param  SCRIPT_FILENAME  /scripts$fastcgi_script_name;
    #    include        fastcgi_params;
    #}

    # deny access to .htaccess files, if Apache's document root
    # concurs with nginx's one
    #
    #location ~ /.ht {
    #    deny  all;
    #}
}

index.html

<!DOCTYPE html>
<html>
    <head>
        <title>MyNginx</title>
    </head>
    <body>
        <h1>hello world</h1>
        <h1>welcome to 031702533</h1>
    </body>
</html>

index.php

<?php phpinfo();?>

（3）使用Compose实现多容器运行机制

运行docker-compose

查看容器和镜像

访问网站

（4）服务测试

连接测试
修改index.php

 <?php
    $servername = "lzssql";
    $username = "root";
    $password = "123456";

    try {
        $conn = new PDO("mysql:host=$servername;", $username, $password);
        echo "连接成功"; 
    }
    catch(PDOException $e)
    {
        echo $e->getMessage();
    }
    ?>

创建数据库
修改index.php

<?php
$servername = "lzssql";
$username = "root";
$password = "123456";

try {
    $conn = new PDO("mysql:host=$servername", $username, $password);

    // 设置 PDO 错误模式为异常
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "CREATE DATABASE test";

    // 使用 exec() ，因为没有结果返回
    $conn->exec($sql);

    echo "数据库创建成功<br>";
}
catch(PDOException $e)
{
    echo $sql . "<br>" . $e->getMessage();
}
$conn = null;
?>

查看数据库信息

docker exec -it lzssql /bin/bash
mysql -u root -p
show databases;

创建数据表
修改index.php

        <?php
$servername = "lzssql";
$username = "root";
$password = "123456";
$dbname="test";    

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // 设置 PDO 错误模式，用于抛出异常
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    // 使用 sql 创建数据表
    $sql = "CREATE TABLE test (
 	id bigint(20) NOT NULL,
 	name varchar(255) NOT NULL,
 	email varchar(255) NOT NULL
	)";
    // 使用 exec() ，没有结果返回 
    $conn->exec($sql);
    echo "数据表创建成功";
}
catch(PDOException $e)
{
    echo $sql . "<br>" . $e->getMessage();
}
$conn = null;
?>

查看数据表

    use test
    show tables;

插入数据

修改index.php
<?php
$servername = "lzssql";
$username = "root";
$password = "123456";
$dbname="test";    

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // 开始事务
    $conn->beginTransaction();
    // SQL 语句
    $conn->exec("INSERT INTO test (`id`, `name`,`email`)
	VALUES(100,'john','1345311153@qq.com');");
    $conn->exec("INSERT INTO test (`id`, `name`,`email`)
	VALUES(31702115,'lzs','1345311153@qq.com');");

    // 提交事务
    $conn->commit();
    echo "新记录插入成功";
}    
catch(PDOException $e)
{
    // 如果执行失败回滚
    $conn->rollback();
    echo $sql . "<br>" . $e->getMessage();
}

$conn = null;
?>

删除数据
修改index.php

<?php
$servername = "lzssql";
$username = "root";
$password = "123456";
$dbname="test";    

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // 开始事务
    $conn->beginTransaction();
    // SQL 语句
    $conn->exec("delete from test where id=100");

    // 提交事务
    $conn->commit();
    echo "记录删除成功";
}    
catch(PDOException $e)
{
    // 如果执行失败回滚
    $conn->rollback();
    echo $sql . "<br>" . $e->getMessage();
}

$conn = null;
?>

（5）总结

遇到的问题
1.使用官方渠道下载docker-compose速度过慢
2.使用网上的换源方案时，发现sudo指令权限依然不够，于是直接使用sudo -i登录root用户，执行成功
3.运行docker-compose时，php构建失败,原因是执行apt-get update时失败
4.运行docker-compose时，进行访问网站操作，出现了连接被重置的问题
总用时：12小时