how to add validate rules

Question

I tried to add unique validation rule in controller. but why the duplicate data still record to database.

Controller

public function tambahDataWNI(Request $request){
    $validation = $request->validate([
        'no_identitas' => 'required|unique:pendataan,no_identitas'
    ]);

    $c = new InputdatawniModel();
    $c->jenis_identitas = $request->jenis_identitas;
    $c->no_identitas = $request->no_identitas;
    $c->nama = $request->nama;
    $c->asal_shelter = $request->asal_shelter;
    $c->save();

    return redirect('inputdatawni');
}

is your table name 'pendataan' correct?

ZeroOne
– ZeroOne

2019-07-19 03:12:13 +00:00
Commented Jul 19, 2019 at 3:12 — ZeroOne
– ZeroOne, Commented Jul 19, 2019 at 3:12

Ghiffari Assamar · Accepted Answer · 2019-07-19 04:28:48Z

1

take a look on here unique rules

based on that reference you need to make sure that you use correct table name and correct column name

$validation = $request->validate([
    'no_identitas' => 'required|unique:table_name,column_name'
]);

answered Jul 19, 2019 at 4:28

Ghiffari Assamar

6614 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Karan Khimani · Accepted Answer · 2019-07-19 04:01:20Z

0

Make sperate request file for this

 public function rules()
{
    switch ($this->method()) {
        case 'POST':
        return [
            'no_identitas' => 'required|unique:tablename,columnname,NULL,id,deleted_at,NULL',
        ];
        case 'PUT':
            $model = Model::whereId($this->model)->first();

        return [

        'no_identitas' => 'required|numeric|unique:tablename,name,' . $model->id . ',id',deleted_at,NULL',

        ];
        default:
        break;
    }
}

answered Jul 19, 2019 at 4:01

Karan Khimani

454 bronze badges

Comments

Suraj15689 · Accepted Answer · 2019-07-19 04:48:12Z

0

Add Below validator class in your controller.

use Illuminate\Support\Facades\Validator;

And Check with below code.

$validator = Validator::make($request->all(), 
         [
            'no_identitas'=>'required|unique:your_tablename'
         ]);

if($validator->fails())
{
   // Error if any
}else{
  // No Errors
}

answered Jul 19, 2019 at 4:48

Suraj15689

294 bronze badges

1 Comment

Ghiffari Assamar Over a year ago

this is ain't no different with op code other than make a custom manual validation, here reference for what i mean laravel.com/docs/5.8/validation#manually-creating-validators

Collectives™ on Stack Overflow

how to add validate rules

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related