diff --git a/docker-compose.yml b/docker-compose.yml
index 24000da..9f782f7 100644
--- a/docker-compose.yml
+++ b/docker-compose.yml
@@ -1,8 +1,8 @@
-version: "3.8"
-
services:
web:
- image: php:8.2-apache
+ build:
+ context: .
+ dockerfile: docker/Dockerfile
ports:
- "${WEB_PORT:-8080}:80"
volumes:
diff --git a/docker/Dockerfile b/docker/Dockerfile
new file mode 100644
index 0000000..864156f
--- /dev/null
+++ b/docker/Dockerfile
@@ -0,0 +1,6 @@
+FROM php:8.2-apache
+
+RUN apt-get update && \
+ apt-get install -y libonig-dev
+
+RUN docker-php-ext-install mysqli pdo_mysql mbstring
diff --git a/public/sample/sql/connect.php b/public/sample/sql/connect.php
new file mode 100644
index 0000000..be9870a
--- /dev/null
+++ b/public/sample/sql/connect.php
@@ -0,0 +1,23 @@
+setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
+
+$rows = $dbh->query("SELECT NOW() AS current_datetime")->fetchAll(PDO::FETCH_ASSOC);
+
+foreach ($rows as $row) {
+ echo "Current Date and Time: " . $row['current_datetime'] . "\n";
+}
+
+// MySQL接続を閉じる
+$dbh = null;
diff --git a/src/pages/sql/030-sql-on-php.mdx b/src/pages/sql/030-sql-on-php.mdx
index 4b93930..222a09c 100644
--- a/src/pages/sql/030-sql-on-php.mdx
+++ b/src/pages/sql/030-sql-on-php.mdx
@@ -4,6 +4,7 @@
export const title = "PHPでSQLを操作する";
+import DockerLink from "@/components/DockerLink.astro";
import OuterLink from "@/components/OuterLink.astro";
# {title}
@@ -12,6 +13,10 @@
## 参考リンク
+
+
+
+