未找到列: 1054“where子句”中的未知列“api_token”

Question

套餐:圣殿

在生成令牌之后，当请求获取数据时抛出错误，如下所示

Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'api_token' in   
'where clause' (SQL: select * from `users` where `api_token` = XAzuNGUeOJ8CXbIoGEWhBTtWIFr0lFr8jjwScXQ4B0Qxfmu
2cHm9LaUwGX96zy0AnXhLLcCnBFCodQaOlimit 1) in file

Answer 1

转到config/auth.php

并将卫士中的api数组更改为sanctum示例：

 'guards' => [
        'web' => [
            'driver' => 'session',
            'provider' => 'users',
        ],

        'api' => [
            'driver' => 'sanctum',
            'provider' => 'users',
            'hash' => false,
        ],
    ],

Answer 2

转到routes/api.php并使用以下内容

Route::middleware('auth:sanctum')->get('/user', function (Request $request) {
    return $request->user();
});

而不是

Route::middleware('auth:api')->get('/user', function (Request $request) {
    return $request->user();
});

Answer 3

在api.php中

Route::middleware('auth:sanctum')->get('/user', function (Request $request) {
    return $request->user();
});

在config/auth.php中

'api' => [
    'driver' => 'sanctum',
    'provider' => 'users',
    'hash' => false,
],

在那之后，它会解决这个问题。我已经把代码上传到我的GitHub上了。https://github.com/ramseyjiang/laravel_8_api