CODEWITHSUNDEEP
laravel
laraCoder
laraCoder

Reputation: 281

How to update a single value with laravel

Hello i want to update a single value on another table using laravel. This is the code i have done until now but doesnt seem to work:

$amount = Product::findorFail($request->products[$i]);
$total_value = $request->amount[$i] + $amount->amount;
$amount->update(['amount', $total_value]);
dd($total_value);

with dd i see that the result is correct but the update function is not, the query im trying to make is

update table set amount=x where id=y

Upvotes: 2

Views: 103

Answers (2)

ERaufi
ERaufi

Reputation: 1663

you could change your code like below

$amount = Product::findorFail($request->products[$i]);
$total_value = $request->amount[$i] + $amount->amount;
$amount->amount=$total_value;
$amount->update();

or as mentioned in comments you could use eloquent increment function

Upvotes: -1

Maik Lowrey
Maik Lowrey

Reputation: 17594

You have multiple choices. The shortes are:

$amount->update(['amount'=> $amount->amount + request->amount[$i]]);

or

Product::findorFail($request->products[$i])->increment('amount', $request->amount[$i]);

Upvotes: 2

Related Questions