Laravel delete method gives "Method not allowed" error on yajra datatable

Question

I have a problem with the following Laravel function, the delete option does not work, it gives out a "Method not allowed" error, for some odd reason even if I give it an id to the route, it fails to show the entire page.

This is the view, admin.unsertable. I just want to correct the "delete" error


    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
     

    


     
        
        
          
          ALT
          
          PluSIS
        
        
        
          
            
              
              
                
                  Usuario
                
                
                  
                  

                    

                    
                  
                  
                  
                    
                      
                    
                    
                     
                    
                    
                     
                    
                  
                  
                  
                    
                      Perfil
                    
                    
                      Salir
                    
                  
                
              
              
              
                
              
            
          
        
      








        
            
                Email
                Type
                Accion
            
        
        

        


{{ csrf_field() }}

Its controller is called AdminController, which runs the following method, which communicates with the database and deletes the row. The database is defined, because if it brings me the data with the method of fetch_data

public function deleteuser(Request $request){
    if($request->ajax())
    {
        DB::table('users')->where('id', $request->id)->delete();
        echo 'Data deleted';
    }
}

These are the routes

Route::get('/admin/usertable', 'AdminController@listuser')    
->middleware('is_admin')    
->name('admin.usertable');

Route::get('/admin/usertable/fetch_data', 'AdminController@fetch_data')    
->middleware('is_admin')    
->name('admin.usertable');

Route::delete('/admin/usertable/deleteuser/{id}', 'AdminController@deleteuser')    
->middleware('is_admin')    
->name('admin.deleteuser');

porloscerros Ψ · Accepted Answer

The ajax method is seted to POST, but Laravel route method is delete. You can to set a parameter named _method with value 'delete', also the crsf token on the headers and in a parameter named _token. In addition the Laravel route expects a parameter {id} in the uri, and you're not passing it.

If you have the csrf token i a metatag, like this:

you can get it from there

var token = $('meta[name="csrf-token"]').attr('content');

But, if you are in blade, you can directly use the csrf_token() helper

var token = '{{ csrf_token() }}';

Then, assign the token to the ajax headers:

$.ajaxSetup({
    headers: {
        'X-CSRF-TOKEN': token,
        'X-Requested-With': 'XMLHttpRequest',
    }
});

Set a parameter named _method with value 'delete' and set a parameter named _token with the token value:

$(document).on('click', '.delete', function() {
    var id = $(this).attr("id");
    if(confirm("Estas seguro de esto?"))
    {
        $.ajax({
            url:"{{ route('admin.deleteuser') }}",
            method:"POST",
            data:{
                id:id,
                // set a parameter named _method with value 'delete'
                _method: 'delete',
                // set a parameter named _token with the token value
                _token: token
            },
            success:function(data) {
                //...
            }
        })
    }
});

Remove the {id} parameter from your laravel route, since you are not using it:

Route::delete('/admin/usertable/deleteuser', 'AdminController@deleteuser')    
->middleware('is_admin')    
->name('admin.deleteuser');

UPDATE

$(document).on('click', '.delete', function() {
    var token = '{{ csrf_token() }}';
    $.ajaxSetup({
        headers: {
            'X-CSRF-TOKEN': token,
            'X-Requested-With': 'XMLHttpRequest',
        }
    });
    var id = $(this).attr("id");
    if(confirm("Estas seguro de esto?"))
    {
        $.ajax({
            url:"{{ route('admin.deleteuser') }}",
            method:"POST",
            data:{
                id:id,
                _method: 'delete',
                _token: token
            },
            success:function(data) {
                //...
            }
        })
    }
});

Laravel delete method gives "Method not allowed" error on yajra datatable

Answers (1)

Related Questions

Laravel delete method gives &quot;Method not allowed&quot; error on yajra datatable

Answers (1)

Related Questions

Laravel delete method gives "Method not allowed" error on yajra datatable