LARAVEL：当ID为非Integer时，如何引起404错误而不是50x错误

Question

我在Laravel中创建了一个简单的CRUD，但是我有一个问题：

我正在使用Illuminate \ support \ authate \ route ::资源方法，这是我的路由/web.php：app/http/http/controllers/notecontroller.php：php

<?php

use Illuminate\Foundation\Application;
use Illuminate\Support\Facades\Route;
use Inertia\Inertia;

Route::get('/', function () {
    return Inertia::render('Welcome', [
        'canLogin' => Route::has('login'),
        'canRegister' => Route::has('register'),
        'laravelVersion' => Application::VERSION,
        'phpVersion' => PHP_VERSION,
    ]);
});

Route::get('dashboard', [App\Http\Controllers\PageController::class, 'dashboard'])
    ->middleware('auth:sanctum')
    ->name('dashboard');

Route::resource('notes', App\Http\Controllers\NoteController::class)
    ->middleware('auth:sanctum');

：

<?php

namespace App\Http\Controllers;

use App\Models\Note;
use Illuminate\Http\Request;
use Inertia\Inertia;

class NoteController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        if ($request->q) {
            return Inertia::render('Notes/Index', [
                'notes' => Note::where('title', 'ilike', "%$request->q%")->get(),
            ]);
        }
        return Inertia::render('Notes/Index', [
            'notes' => Note::all()
        ]);
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        return Inertia::render('Notes/Create', [
            'note' => new Note()
        ]);
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        $note = Note::create($request->validate([
            'title' => 'required',
            'content' => 'required',
        ]));

        return redirect()->route('notes.show', $note)->with('success', 'Nota creada');
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\Models\Note  $note
     * @return \Illuminate\Http\Response
     */
    public function show(Note $note)
    {
        return Inertia::render('Notes/Show', compact('note'));
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Models\Note  $note
     * @return \Illuminate\Http\Response
     */
    public function edit(Note $note)
    {
        return Inertia::render('Notes/Edit', compact('note'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Models\Note  $note
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Note $note)
    {
        $request->validate([
            'title' => 'required',
            'content' => 'required',
        ]);

        $note->update($request->all());

        return redirect()->route('notes.show', $note)->with('success', 'Nota actualizada');
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Models\Note  $note
     * @return \Illuminate\Http\Response
     */
    public function destroy(Note $note)
    {
        $note->delete();

        return redirect()->route('notes.index')->with('success', 'Nota eliminada');
    }
}

当我转到 /notes /a时，“ a”应该是我想看的注释的索引，我会收到500个错误：

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: "a"

select *从“注释”中select * where“ id” = a limit 1

此时，我的代码尚未运行。如何捕获此错误以提出404错误？

Answer 1

由于您使用内置资源控制器，因此将创建以下URI，并发生模型绑定。如果参数不适合ID类型，则会出错。

GET /notes/{note}
GET /notes/{note}/edit

当模型绑定发生时，我尚未找到修改请求验证的方法。如果您想自定义行为，则可以通过将show和编辑函数从“路由资源声明”中删除，并编写上面列出的自定义端点。

ROUTES/web.php

Route::resource('notes', NoteController::class)->except([
    'show', 'edit'
]);

Route::get('/notes/{note}', [
    'as' => 'notes.show',
    'uses' => '\App\Http\Controllers\NoteController@show',
]);

App/http/controllers/notecontroller.php

use Illuminate\Http\Request;
...
    public function show(Request $request)
    {
        $noteId = $request->note;
        ...
    }

您可以通过将请求切换到继承formrequest的自定义请求来执行验证。

可以在此处找到更多信息：
https://laravel.com/docs/docs/9.x/validation#形式重新验证

Answer 2

路线模型绑定在MySQL/Mariadb上一直有效，但是不在postgres 上 。基于泰勒的“ nofollow noreferrer”> comment修复它。因此，解决方案就是这样：

Route::resource('users', UserController::class)->whereNumber('user');
Route::resource('notes', NoteController::class)->whereNumber('note');

等。

更新且优化的路由文件将看起来像这样：

<?php

use App\Http\Controllers\NoteController;
use App\Http\Controllers\PageController;
use Illuminate\Foundation\Application;
use Illuminate\Routing\Router;
use Illuminate\Support\Facades\Route;
use Inertia\Inertia;

Route::get('/', function () {
    return Inertia::render('Welcome', [
        'canLogin' => Route::has('login'),
        'canRegister' => Route::has('register'),
        'laravelVersion' => Application::VERSION,
        'phpVersion' => PHP_VERSION,
    ]);
});
Route::middleware('auth:sanctum')->group(function (Router $router) {
    $router->get('dashboard', [PageController::class, 'dashboard'])->name('dashboard');
    $router->resource('notes', NoteController::class)->whereNumber('note');
});

Answer 3

您可以在下面使用firstorfail（）或FindorFail示例代码

public function find(Request $request){
    return Note::findOrFail($request->id);
}

Answer 4

如果找不到数据，则可以使用中止代码的流产（404）。

public function findNote($id)
{
    $note = Note::find($id)
    
    if($note == null)
    {
    abort(404);
    }
}