doy57007
2019-02-17 11:50
浏览 86
已采纳

laravel自定义请求验证ID

hi i have laravel project and im using custom request this is my request code

public function rules()
{
    if($this->method() == 'POST' and $this->ajax())
    {
        return [
            'id' => 'integer|min:1|unique:archive_categorys',
            'archive_category_name' => 'max:50|min:1|unique:archive_categorys',
            'archive_category_id' => 'nullable|integer|min:1|max:'.Archive_category::max('id'),
            'archive_category_max' => 'nullable|integer|min:1|',
            'archive_category_plus_value' => 'nullable|integer|min:1|',
            'image' => 'nullable|image|mimes:jpg,jpeg,gif,png|max:2048',
        ];              
    }
    elseif($this->method() == 'PATCH' )
    {
        return [
            'id' => 'required|min:1|unique:archive_categorys,id,'.$this->id,
            'archive_category_name' => 'required|max:50|min:1|unique:archive_categorys,archive_category_name,'.$this->id,
            'archive_category_id' => 'nullable|min:1|max:'.Archive_category::max('id'),
            'archive_category_max' => 'nullable|integer|min:1|',
            'archive_category_plus_value' => 'nullable|integer|min:1|',
            'image' => 'nullable|image|mimes:jpg,jpeg,gif,png|max:2048',
        ];          
    }
    else
    {
        return false;
    }
}

now my problem with method patch

'id' => 'required|min:1|unique:archive_categorys,id,'.$this->id,

now if i tried to change archive_categorys with id 1 to 2 if there is no archive_categorys with id 2 its will update successfully but if there is anther archive_categorys with id 2 its will pass and get error 1062 Duplicate entry
so how can i check unique value in laravel when update thanks

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dongyou7292 2019-02-17 12:37
    已采纳

    Considering that you have POST route creating a new entry, id should not be ideally sent from the frontend but should be added automatically as primary key from MySQL.

    Also in your PATCH route, you should send an id to validate if it exists.

    Please check updated validation :

    public function rules()
    {
        if($this->method() == 'POST' and $this->ajax())
        {
            return [
                'archive_category_name' => 'max:50|min:1|unique:archive_categorys,name',
                'archive_category_max' => 'nullable|integer|min:1',
                'archive_category_plus_value' => 'nullable|integer|min:1',
                'image' => 'nullable|image|mimes:jpg,jpeg,gif,png|max:2048',
            ];              
        }
        elseif($this->method() == 'PATCH' )
        {
            return [
                'id' => 'required|exists:archive_categorys,id,',
                'archive_category_name' => 'required|max:50|min:1|unique:archive_categorys,archive_category_name,'.$this->input('id'),
                'archive_category_max' => 'nullable|integer|min:1',
                'archive_category_plus_value' => 'nullable|integer|min:1',
                'image' => 'nullable|image|mimes:jpg,jpeg,gif,png|max:2048',
            ];          
        }
        return [];
    }
    
    已采纳该答案
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题