destroy(id) is not working in Laravel 5.2

Very strange that something so fundamental would not be working. Just off the top of my head, what I'd check...

• Have you logged your database queries and confirmed that there is a DELETE SQL statement?
• Are you using a database transaction and not committing it?
• Stupid question, it's got to be asked... you are looking at the correct database and the correct table?

The only thing I can think is that you are not actually hitting the destroy method in your controller, or that the id is not being passed through correctly.

dd($id) just before the Product::destroy($id);

I checked similar in one of my projects (which I know works fine) (L5.0 though)

    {!! Form::open(array('route' => array('admin.templates.destroy', $template->id), 'method' => 'delete')) !!}
        <button class='btn btn-danger pull-right btn-xs' type="submit">Delete Template</button>
    {!! Form::close() !!}

@tykus_ikus : There should be a delete sql statement. I have used it in the past projects on CodeIgniter. It is looking at the correct database. In the same app, i was able to insert records.

I'm just learning the framework by watching youtube tutorials for CRUD app. It was going good until this happen.

@Snapey : When i added dd($id). It returned the id number as "7"

Just use delete.

I tried destroy() and then i tried delete(), it didn't work!

public function destroy($id){
    /* Deleting a product */
    //Product::destroy($id); // 1 way 
    $product = Product::find($id) // another way
                ->delete(); 
//  Product::find($id)->delete();
    return redirect()->route('product.index');
}

Its happening for edit function as well! It isn't updating the record

public function update(request $request,$id)
{

/* inserting values to db - 1st way*/

    $product=Product::find($id);
    $product->name=$request->name;
    $product->price=$request->price;
    $product->save();
    return redirect()->route('product.index');
}    

This is so straight forward but i can't seem to figure out what's wrong here...

I am guessing here but I would bet you may have a route collision. If your routes have product/{id} and product/{id}/update it will hit the first product/{id} it finds regardless of any use after it.

For me to always avoid this make sure it's a pit/patch and delete route. I also don't pass wild cards {id} except on a show route. Everything else is passed in session or the form to the controller.

@brianbabu Post your routes since as @jekinney said you might have an route collision issue. Also, did you logged what DB query is actually executed?

Also, public function update(request $request,$id) should be public function update(Request $request,$id) but I guess yo just wrote the code straight in here.

This is all i have in routes

Route::group(['middleware' => ['web']], function () { /* Route::resource(name, contrller-name, options); */ Route::resource('product', 'ProductController'); });

The 'R' in request didnt make any change either. I used 'request $request' for inserting the record and it worked just fine.

@cristian9509 : Could you pls tell me how to find out what DB query is actually executed?
Thanks.

I was following this (https://www.youtube.com/watch?v=5n6UgzhExAc&list=PL3ZhWMazGi9IcgWunA4izwTkd9QjSGW2j&index=8) tutorial series to learn laravel and it was for the 5.1 version. I got the 5.2 version but i was able to pull off everything in series except for edit and delete. :(

Additionally, I referred to the documentation as well but still hit a bump......

@brianbabu To get all the queries executed place this in your route's file

// Display all SQL executed in Eloquent
Event::listen('illuminate.query', function($query)
{
    var_dump($query);
});

Another way which I like better is to use Clockwork https://github.com/itsgoingd/clockwork. You will need to install a plugin, I recommend Chrome extension Clockwork and then you need to pull the clockwork package to your Laravel installation, add the service provider and the middleware and then you're all set. Just open Chrome developer tools, got to Clockwork tab, reload the page and you'll see all the DB queries there.

@brianbabu

Clockwork is a must have BTW

Check your routes by running php artisan route:list

Screen shot it and post. Generally using route resource many devs use the actual url instead of route helper by name. But verify your action route is correct. If not fix them or post your route list and each form action (route) you're trying to post to.