【Laravel】Sailを使用せずにDockerで開発、TinyMCEを使用したWeb回覧システム設計

laravel-xserver-dev/
├── docker/
│   ├── php/
│   │   └── Dockerfile
│   └── mysql/
├── docker-compose.yml
├── .env
└── laravel/        ← Laravel本体（後で Composer で生成）

services:
  app:
    build:
      context: .
      dockerfile: docker/php/Dockerfile
    container_name: laravel-app
    volumes:
      - ./laravel:/var/www
    ports:
      - "8000:8000"
    depends_on:
      - db
    working_dir: /var/www

  db:
    image: mysql:8.0
    container_name: laravel-db
    restart: unless-stopped
    environment:
      MYSQL_DATABASE: laravel
      MYSQL_ROOT_PASSWORD: secret
      MYSQL_USER: laravel
      MYSQL_PASSWORD: secret
    ports:
      - "3306:3306"
    volumes:
      - dbdata:/var/lib/mysql

volumes:
  dbdata:

FROM php:8.2-fpm

RUN apt-get update && apt-get install -y \
    git curl zip unzip libonig-dev libxml2-dev \
    && docker-php-ext-install pdo_mysql mbstring exif pcntl bcmath

# Composer install
COPY --from=composer:latest /usr/bin/composer /usr/bin/composer

WORKDIR /var/www

docker compose up -d
docker compose exec app bash
# コンテナ内で以下を実行
composer create-project laravel/laravel .
exit

docker compose exec app php artisan serve --host=0.0.0.0 --port=8000

DB_CONNECTION=mysql
DB_HOST=db
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=laravel
DB_PASSWORD=secret

services:
  app:
    build:
      context: .
      dockerfile: Dockerfile
    container_name: laravel-app-fast
    volumes:
      - ./laravel:/var/www
      
      - storage-volume:/var/www/html/storage/framework
      - vendor-volume:/var/www/html/vendor
    ports:
      - "8000:8000"

    ...


volumes:
  dbdata:
  storage-volume:
  vendor-volume:

docker-compose down -v
docker-compose up -d

docker-compose exec app composer install

   INFO  Discovering packages.

  laravel/pail ................................................................................................................... DONE
  laravel/sail ................................................................................................................... DONE
  laravel/tinker ................................................................................................................. DONE
  nesbot/carbon .................................................................................................................. DONE
  nunomaduro/collision ........................................................................................................... DONE
  nunomaduro/termwind ............................................................................................................ DONE

79 packages you are using are looking for funding.
Use the composer fund command to find out more!


# Laravelのキャッシュ・権限系を整える
docker-compose exec app php artisan config:clear
docker-compose exec app chmod -R 777 storage bootstrap/cache

# アクセス確認（localhost:8000）
docker-compose exec app php artisan serve --host=0.0.0.0 --port=8000

docker-compose exec app ls /var/www/html/
storage  vendor

docker-compose exec app mount | grep /var/www/html/vendor
/dev/sde on /var/www/html/vendor type ext4 (rw,relatime)

Xserver/public_html/
└── laravel-xserver/
    ├── app/
    ├── public/（中身あり）
    ├── .env
    ├── index.php      ← public/index.phpを書換コピペ
    ├── .htaccess      ← public/.htaccessをコピー
    └── ... その他Laravel一式

require __DIR__.'/vendor/autoload.php';
$app = require_once __DIR__.'/bootstrap/app.php';

┌─────────────┐           ┌────────────┐
│ ローカルPC  │           │   Xserver  │
│ Docker(MySQL)│          │  MySQL提供  │
│ Laravel dev │           │ Laravel prod │
└────┬────────┘           └────┬───────┘
     │ DB接続 → localhost       │ DB接続 → mysql1234.xserver.jp
     │                         │
     │ migrate                 │ 手動インポート（phpMyAdmin）
     ▼                         ▼
  OK                          OK

docker exec [DBコンテナ名] mysqldump -u root -p laravel > /tmp/laravel.sql

docker cp laravel-db:/tmp/backup.sql ./backup.sql

composer require laravel/breeze --dev

php artisan breeze:install

cd \laravel-xserver-dev\laravel
npm install --save-dev vite
npm run build

import { defineConfig } from 'vite';
import laravel from 'laravel-vite-plugin';

export default defineConfig({
    plugins: [
        laravel({
            input: ['resources/css/app.css', 'resources/js/app.js'],
            refresh: true,
        }),
    ],
    base: '/laravel-xserver/build/', // xserverデプロイ時の構成に合わせて設定
});

php artisan migrate

laravel/
├── app/
│   ├── Http/
│   │   ├── Controllers/
│   │   │   ├── Auth/         ← Breezeの認証系コントローラ
│   │   │   └── Controller.php
├── database/
│   ├── migrations/           ← users, sessionsなどが定義されてる
├── resources/
│   ├── views/
│   │   ├── auth/             ← login, registerなど
│   │   ├── layouts/          ← app.blade.php 等のレイアウト
├── routes/
│   ├── web.php               ← Breezeが登録ルート追加済
├── public/
│   ├── build/                ← npm run build で生成されたフロントJS

<script type="module" src="http://[::1]:5173/@vite/client"></script>
<link rel="stylesheet" href="http://[::1]:5173/resources/css/app.css">
<script type="module" src="http://[::1]:5173/resources/js/app.js">

# APP_DEBUG=true
APP_DEBUG=false
APP_URL=http://localhost:8000 # @vite() とは無関係
# APP_ENV=local
APP_ENV=production

<!-- Styles / Scripts -->
@if (file_exists(public_path('build/manifest.json')) || file_exists(public_path('hot')))
@vite(['resources/css/app.css', 'resources/js/app.js'])
@else

$ ls -l public
合計 12
drwx---r-x 3 jingtian members  53  6月 13 06:27 build
-rw----r-- 1 jingtian members   0  5月 27 02:17 favicon.ico
-rw----r-- 1 jingtian members  17  6月 21 08:42 hot
-rw----r-- 1 jingtian members 543  5月 27 02:17 index.php
drwx---r-x 3 jingtian members  29  6月 18 21:21 js
-rw----r-- 1 jingtian members  24  5月 27 02:17 robots.txt
drwx---r-x 2 jingtian members 290  6月 25 06:27 uploads

rm public/hot

<!-- resources/views/components/app-layout.blade.php -->
<!DOCTYPE html>
<html lang="{{ str_replace('_', '-', app()->getLocale()) }}">
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>{{ config('app.name', 'Laravel') }}</title>
    <!-- CSS読み込み -->
</head>
<body>
    <div class="min-h-screen bg-gray-100">
        <!-- ナビゲーション -->
        @include('layouts.navigation')
        
        <!-- ページヘッダー -->
        @if (isset($header))
            <header class="bg-white shadow">
                <div class="max-w-7xl mx-auto py-6 px-4">
                    {{ $header }} <!-- 名前付きスロット -->
                </div>
            </header>
        @endif
        
        <!-- メインコンテンツ -->
        <main>
            {{ $slot }} <!-- メインのコンテンツエリア -->
        </main>
    </div>
</body>
</html>

php artisan make:migration create_posts_table --create=posts

php artisan migrate:status で現在の状況を確認
php artisan migrate

php artisan tinker

>>> use App\Models\{User, Post};
>>> use App\Enums\PostStatus;

>>> User::count()
>>> $user = User::first();
>>> $user

>>> Post::create([
...   'user_id' => $user->id,
...   'title' => 'はじめての投稿',
...   'slug' => 'first-post',
...   'body' => 'これは最初のテスト投稿です。',
...   'status' => PostStatus::DRAFT
... ]);

>>> Post::count()
>>> Post::first()

[username@sv12345 laravel-xserver]$ php8.3 artisan migrate

   INFO  Running migrations.  

  2025_06_14_074533_create_posts_table .............. 87.84ms DONE

php artisan make:controller PostController --resource