Laravel表单验证器错误-Java 学习之路

我想在将数据存储到数据库之前验证输入字段，因此我浏览了laravel文档并遵循这些

php artisan make:request StoreLessons
in StoreLessons

public function rules()
    {
        return [
            'title' => 'required|unique:lesson',
            'body' => 'required',
        ];
    }

在我的控制器中

namespace App\Http\Controllers;

use Response;
use App\lesson;
use Illuminate\Http\Request;
use App\Acme\Transformers\LessonTransformer;
use Illuminate\Support\Facades\Input;
use App\Http\Requests\StoreLessons;

class LessonsController extends ApiController 
{

    protected $lessonTransformer;

    function __construct(LessonTransformer $lessonTransformer) 
    {
        $this->lessonTransformer = $lessonTransformer;
    }

    //fetch all and pass a metadata 'data' 
    public function index() 
    {
        $lessons = Lesson::all();

        return $this->respond([
            'data' => $this->lessonTransformer->transformCollection($lessons->all())
        ]);
    }

    //add a new lesson to lessons table
    public function store(StoreLessons $request) 
    {
        Lesson::create($request->all());

        //Lesson::create(input::all());

        return $this->respondCreated('Lesson created successfully');
    }


}

现在我收到了这个错误

QueryException in Connection.php line 770:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_api.lesson' doesn't exist (SQL: select count(*) as aggregate from `lesson` where `title` = the)

我没有't know why it'寻找 lesson 表我有一个 lessons 表

但 store() 函数可以使用默认验证

//this works fine but i wan to do the validation 
    public function store() 
    {
        if (! input::get('title') or ! input::get('body')) {
            return $this->respondBadRequest();
        }

        Lesson::create(input::all());

        return $this->respondCreated('Lesson created successfully');
    }

谢谢

2 回答

2
```
unique:table,column,except,idColumn
```
唯一的语法如上所述，传递的第一个参数是表名 .
```
public function rules() { 
    return [ 'title' => 'required|unique:lesson', 'body' => 'required', ];
}
```
这里的唯一规则是查找表 lesson . 尝试将其更改为 lessons
回复于 2024-05-03T11:14:08+08:00
0

请在相关的模型类名之后写下面的行 .

class xyz extends Model { protected $ table = 'lessons';

码 - -

}

试试这个 .

回复于 2024-05-03T11:14:08+08:00

Laravel表单验证器错误

2 回答

相关问题