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 @@ ## 参考リンク + + +
+