Laravel update function

Question

I need to change the value of columns from "0" to "1" after click on the Validate Button in my Application.

The column is saved as "0" by default.

I need to find the right ID of the invoice and update this value. So I tried this code, but my update function is not working.

In view: (Each button got the ID of my invoice)

<form action="{{route('Invoice.update', ['id' => $in->id])}}" method="post">
    {{method_field('patch')}}
    {{csrf_field()}}
    <input type="hidden" name="catid" id="catid" >
    <button type="submit"  data-catid="{{$in->id}}"></button>
</form>

Controller: (Find the Id invoice from value f input)

public function update(Request $request, $id)
{
    $invoice = Invoice::findOrFail($request->catid);
    $invoice->validate = 1;
    $invoice->save();

    return back();    
}

route:

Route::resource('Invoice','ValidateController');

Errors:

No query results for model [App\Invoice].

Edited Thanks...

Tpojka · Accepted Answer · 2018-09-26 09:58:11Z

2

Because you are using Route::resource('Invoces', 'ValidateController), the route to update your Invoice must provide an ID of the invoice which you whan to update and the update method in your controller must look like this

public function update(Request $request, $id){
    // here goes the code to update the invode
}

You are passing test as value of the ID which the invoice.update route expect.

<form action="{{route('Invoice.update', ['id' => $in->id]}}" method="post">

If you want the route behave the way you specifie you make create a custom route for invode.update. For that you must except the update when you are registering the invoce resource and define another route for the update after

Route::match(['put', 'patch'], '/invoce/update', 'ValidationController@update');
Route::resource('Invoce', 'ValidationController')->except(['update'])

edited Sep 26, 2018 at 9:58

Tpojka

7,0812 gold badges32 silver badges41 bronze badges

answered Sep 26, 2018 at 0:08

Yves Kipondo

5,6931 gold badge22 silver badges33 bronze badges

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

8 Comments

yassine j Over a year ago

Hello sir, thank you for ur attention, when i add update with ur response, i got now the id, but i have the error : No query results for model [App\Invoice].

Yves Kipondo Over a year ago

That means there isn't any Invoice with correspond to the ID that you specify

yassine j Over a year ago

It is sir, they wrote me an ID that exist in my database

Yves Kipondo Over a year ago

Is the ID that you get from the request the same as which is in your database? verify the value of the ID. If It's the right ID it can't return that error. The error which you get means eloquent haven't found any invoice with that id

yassine j Over a year ago

Yes, the request return : localhost:8000/Invoice/59 And i have an invoice with the id=59

|

Andrii Lutskevych · Accepted Answer · 2018-09-26 00:06:06Z

0

Are you sure that

My code can't find the invoice ID (catid)

?

You have invalid form action {{route('Invoice.update', 'test')}}. Remove test property - {{route('Invoice.update')}}

And I advise use lowercase in the route names: {{route('invoice.update')}} and Route::resource('invoice', 'ValidateController');

answered Sep 26, 2018 at 0:06

Andrii Lutskevych

1,38913 silver badges23 bronze badges

1 Comment

yassine j Over a year ago

Hello sir, thank you for ur attention. When i remove 'test' i got error message: Missing required parameter

Collectives™ on Stack Overflow

Laravel update function

2 Answers 2

8 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related