Laravel DB updated 2 row even 1 id given

Question

I don't know what's wrong with my code, i want to update 1 row of my DB, but instead it's updated 2 row at once, i'm using ajax post to update the data

ajax query :

$('#tolak').on('click', function() {
                const id = $(this).attr('data-id')
                const name = $(this).attr('data-name')
                Swal.fire({
                    title: 'Konfirmasi',
                    text: `Apakah anda yakin akan menolak form pendaftaran driver ${name}`,
                    icon: 'warning',
                    showCancelButton: true,
                    confirmButtonColor: '#3085d6',
                    cancelButtonColor: '#d33',
                    confirmButtonText: 'Ya, tolak!',
                    cancelButtonText: 'Batal',
                }).then((result) => {
                    Swal.showLoading()
                    if (result.isConfirmed) {
                        $.ajax({
                            url: '{{ route('admin.verifDriver') }}',
                            type: 'ajax',
                            method: 'post',
                            data: {
                                id: id,
                                status: 2,
                            },
                            success: function(data) {
                                console.log(data)
                                Swal.fire(
                                    'Sukses!',
                                    `Berhasil tolak pendaftaran ${name}`,
                                    'success'
                                )
                                fetchData()
                                Swal.hideLoading()
                            },
                            error: function(e) {
                                Swal.hideLoading()
                            }
                        })
                    }
                })
            })

And here's the controller

public function verif(Request $req)
    {
        DB::table('drivers')
            ->where('id', $req->id)
            ->update([
                'status' => $req->status
            ]);
    }

it's just a simple code, i have done it before on the other project but it works, i don't know what's wrong with this code.

EDIT

Here is my full blade code

@extends('admin.layout.app')
@section('content')
    
        Form Driver
        
            
                {{-- Modal Tambah Driver --}}
                
                    
                    

                        
                        

                            TES
                        
                    
                
                
                    Show
                    
                
            
            
                
            
        
        
            
                
                            
                        

                    
                        
                            No
                            Nama
                            Email
                            TTL
                            Alamat
                            Tipe Kendaraan
                            No. Kendaraan
                            Warna
                            Status
                            Action
                        
                    
                    
                        
                    
                
            
        
        
            
            
        
        

        
        

            
            
                
                    
                

                
                    
                
                
                    
                        Nama
                        :
                        Data
                    
                    
                        Email
                        :
                        Data
                    
                    
                        TTL
                        :
                        Data
                    
                    
                        Alamat
                        :
                        Data
                    
                    
                        Tipe Kendaraan
                        :
                        Data
                    
                    
                        Merk
                        :
                        Data
                    
                    
                        Tipe
                        :
                        Data
                    
                    
                        Warna
                        :
                        Data
                    
                    
                        No. Kendaraan
                        :
                        Data
                    
                    
                        No. KTP
                        :
                        Data
                    
                    
                        No. STNK
                        :
                        Data
                    
                    
                        No. SIM
                        :
                        Data
                    
                    
                    
                        Tolak
                        Verifikasi
                    
                

            
        
    
@endsection
@section('script')
    
    
@endsection

Mad an · Accepted Answer

Select single data, modify it and save like

public function verif(Request $req)
{
    $model=Driver::where('id', $req->id)->first();
    $model->status=$req->status;
    $model->save();
}

Laravel DB updated 2 row even 1 id given

Answers (2)

Related Questions