Laravel图库数据无法写入数据库的问题排查与解决

我开发了一个Laravel应用，尝试将图片存入后台的gallery数据库，用于在网站图库页面展示，但数据无法写入数据库。以下是相关代码及排查解决步骤：

排查与修复步骤 #

1. 确认模型可填充字段 #

Laravel默认开启批量赋值保护，必须在Gallery模型中声明可写入的字段：

// app/Models/Gallery.php
namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Gallery extends Model
{
    protected $fillable = ['title', 'image', 'priority']; // 必须包含这三个字段
}

如果未设置$fillable，Laravel会直接阻止数据写入数据库。

2. 优化优先级调整逻辑 #

原代码中循环逐个更新优先级的方式容易引发事务不一致，建议改用数据库原生更新：

// 替换store方法中的优先级调整代码
Gallery::where('priority', '>=', $newPriority)
    ->increment('priority');

这种方式更高效，也能避免因模型事件或内存问题导致的保存失败。

3. 统一表单与验证规则 #

表单中priority字段未加required属性，但控制器验证规则要求必填，用户未填写时会触发验证错误（页面顶部会显示错误列表）。建议给表单字段加上required：

<input type="number" class="form-control" id="priority" name="priority" value="{{ old('priority') }}" required />

4. 检查存储权限与软链接 #

确保图片存储目录有写权限，同时创建public目录的软链接：

chmod -R 755 storage/
php artisan storage:link

storage:link会将public/storage链接到storage/app/public，保证图片能被前端访问。

5. 开启调试模式查看具体错误 #

在.env文件中设置APP_DEBUG=true，提交表单时若有错误会显示详细异常信息（比如数据库字段不存在、权限不足等），这是排查问题最直接的方式。

6. 验证路由定义 #

确认gallery.store路由已正确配置在routes/web.php中：

use App\Http\Controllers\GalleryController;

// 推荐使用资源路由
Route::resource('gallery', GalleryController::class);

// 或单独定义store路由
Route::post('/gallery', [GalleryController::class, 'store'])->name('gallery.store');

路由未正确定义会导致表单提交404，数据自然无法写入。

原代码参考 #

Gallery控制器代码 #

<?php

namespace App\Http\Controllers;
 
use App\Models\Gallery;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Storage;
use Illuminate\Support\Str;
use Intervention\Image\Facades\Image;

class GalleryController extends Controller
{
    public function home()
    {
         $gallery = Gallery::orderBy('priority')->get();
         return view('gallery', compact('gallery'));
    }

    
    public function index()
    {
        $gallery = Gallery::all();
        return view('gallery.index', compact('gallery'));
    }

    public function create()
    {
        return view('gallery.create');
    }


    public function store(Request $request)
    {
        $request->validate([
            'title' => 'required',
            'image' => 'required|image|mimes:jpeg,png,jpg|max:2048',
            'priority' => 'required|integer',
        ]);
    
        $imagePath = $request->file('image')->store('gallery', 'public');
        $image = Image::make(public_path("storage/{$imagePath}"));
        $image->save();
    
        $newPriority = $request->priority;
    
        // Shift the priorities of existing images greater than or equal to the new priority
        Gallery::where('priority', '>=', $newPriority)
            ->orderBy('priority', 'desc')
            ->get()
            ->each(function ($image) {
                $image->priority += 1;
                $image->save();
            });
    
        $gallery = new Gallery();
        $gallery->title = $request->title;
        $gallery->image = $imagePath;
        $gallery->priority = $newPriority;
        $gallery->save();
    
        return redirect()->route('gallery.index')->with('success', 'Image added successfully.');
    }

    public function show($id)
    {
        $gallery = Gallery::findOrFail($id);
        return view('gallery.show', compact('gallery'));
    }

    public function edit($id)
    {
        $gallery = Gallery::findOrFail($id);
        return view('gallery.edit', compact('gallery'));
    }

    public function update(Request $request, $id)
    {
        $gallery = Gallery::findOrFail($id);
    
        $request->validate([
            'title' => 'required',
            'priority' => 'required|integer',
        ]);
    
        $newPriority = $request->priority;
    
        // Check if the new priority already exists in other images
        $existingImage = Gallery::where('priority', $newPriority)->first();
    
        if ($existingImage) {
            // Shift the priority of existing images greater than or equal to the new priority
            Gallery::where('priority', '>=', $newPriority)
                ->where('id', '!=', $gallery->id)
                ->orderBy('priority', 'desc')
                ->get()
                ->each(function ($image) {
                    $image->priority += 1;
                    $image->save();
                });
    
            // Update the priority of the current image
            $gallery->priority = $newPriority;
        } else {
            // If the new priority is unique, update the priority of the current image
            $gallery->priority = $newPriority;
        }
    
        $gallery->title = $request->title;
        $gallery->save();
    
        return redirect()->route('gallery.index')->with('success', 'Image updated successfully.');
    }

    public function destroy($id)
    {
        $gallery = Gallery::findOrFail($id);
    
        // Delete the image file from the storage folder
        Storage::delete('public/' . $gallery->image);
    
        $gallery->delete();
    
        return redirect()->route('gallery.index')->with('success', 'Image deleted successfully.');
    }
        
}

表单代码 #

<x-app-layout>
    <div class="wrapper2">
        <h1 class="justify-content-center">Gallery</h1>

        @if ($errors->any())
        <div class="alert alert-danger">
            <ul>
                @foreach ($errors->all() as $error)
                <li>{{ $error }}</li>
                @endforeach
            </ul>
        </div>
        @endif

        <form action="{{ route('gallery.store') }}" method="POST" enctype="multipart/form-data">
            @csrf
            <div class="form-group" style="padding-bottom: 2px;">
                <label for="title">Title</label>
                <input type="text" class="form-control" id="title" name="title" value="{{ old('title') }}" required />
            </div>
            <div class="form-group" style="padding-bottom: 2px;">
                <label for="image"> Image</label>
                <input type="file" class="form-control-file" id="image" name="image" required />
            </div>
            <div class="form-group" style="padding-bottom: 2px;">
                <label for="priority">Priority</label>
                <input type="number" class="form-control" id="priority" name="priority" value="{{ old('priority') }}" />
            </div>
            <button type="submit" class="btn btn-primary">Add Image</button>
        </form>
    </div>
</x-app-layout>

内容的提问来源于stack exchange，提问作者Absaar Ali Rizwan