Laravel Not Delete record

Question

I working on laravel to build my php project . I can retrieve data from database successfully but I can not delete records when press delete button , I trying to delete record using ajax so this my ajax code

$('.userdelete').on('click', function () {
    alert('dfsfs');
    var id = $(this).data('id');
    $.ajax({
        type: 'DELETE',
        url: '/users/' + id,
        data: {
            '_token': $('input[name=_token]').val(),
        },
        success: function (data) {
            alert(data);
            toastr.success('Successfully deleted Post!', 'Success Alert', {timeOut: 5000});
            $('.item' + data['id']).remove();
        },
        error: function (data) {
            console.log(data);
        }
    });
});

this is the route

Route::resource('users','radcheckController');

Users Model

namespace App;

use Illuminate\Database\Eloquent\Model;

class Users extends Model
{
    protected $table="radcheck";
}

this is the controller's destroy function

public function destroy($id)
{
    $res = Users::where('username', $id)->delete();
}

if you're using $id as a primary key, use User::find($id)->delete() — abr
this is the error DELETE localhost:8000/users/10966417880 500 (Internal Server Error) — Muh

Ali Özen Ali Özen · Accepted Answer · 2018-05-29T12:05:44

You need to specify the correct column, but you didn't pick one. Use find or findOrFail with $id or use first(). Right way is:

public function destroy($id)

{
    $res = Users::find($id);
    $res->delete();
}

or try:

public function destroy($id)
{
    $res = Users::where('username', $id)->first()->delete();
}

Laravel Not Delete record

2 Answers