Laravel、Next.jsでWeb回覧システム設計、Docker Sail Laravel 12 TinyMCE

composer create-project laravel/laravel web-circular

composer require laravel/sail --dev

php artisan sail:install

  Which services would you like to install? [mysql]
  None ............................................................................................................. 0  
  mysql ............................................................................................................ 1  
  pgsql ............................................................................................................ 2  
  mariadb .......................................................................................................... 3  
  mongodb .......................................................................................................... 4  
  redis ............................................................................................................ 5  
  valkey ........................................................................................................... 6  
  memcached ........................................................................................................ 7  
  meilisearch ...................................................................................................... 8  
  typesense ........................................................................................................ 9  
  minio ........................................................................................................... 10  
  mailpit ......................................................................................................... 11  
  rabbitmq ........................................................................................................ 12  
  selenium ........................................................................................................ 13  
  soketi .......................................................................................................... 14  
❯ 1

/mnt/c/web-circular# vendor/bin/sail up -d

vendor/bin/sail artisan migrate

   INFO  Preparing database.  

  Creating migration table ...................................................... 308.69ms DONE

   INFO  Running migrations.  

  0001_01_01_000000_create_users_table .......................................... 586.27ms DONE
  0001_01_01_000001_create_cache_table .......................................... 171.50ms DONE
  0001_01_01_000002_create_jobs_table ........................................... 400.70ms DONE

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

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

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

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

mysql> show tables;
Empty set

docker-compose exec app php artisan migrate

docker exec [DBコンテナ名] mysqldump -u root -p laravel > laravel.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

export default defineConfig({
    plugins: [laravel({ input: [...], refresh: true })],
    base: process.env.VITE_ASSET_BASE || '/build/',
});

APP_URL=https://bizlabo.site/laravel-xserver
VITE_ASSET_BASE=/laravel-xserver/build/

APP_URL=http://localhost:8000
VITE_ASSET_BASE=/build/

<!-- 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