Level 39
No problem, rewrite your check to another where condition
Jul 11, 2022
9
Level 4
laravel update query if else
Hello It is possible make check inside update query I want make update 'priceA' if $checkPrice is more 100
Post::where('id', 1)
->update([
'title' => $title;
'text' => $text;
if( $checkPrice > 100) { 'priceA'=> $priceA }
]);
Level 4
@sr57 I want use one where
Level 39
Post::where('id', 1)
->where('priceA','>=' ,$priceA)
-> ...
1 like
Level 4
@sr57 And where set condition $checkPrice > 100
Level 39
This test is a simple php test put it outside your update
if( $checkPrice > 100) {
Post:: ...
}
Level 4
I need update title text and priceA if condition is true
Post::where('id', 1) ->update([ 'title' => $title; 'text' => $text; if( $checkPrice > 100) { 'priceA'=> $priceA } ]);
Level 39
need update title text and priceA if condition is true
Yes, understood, you have all the tips
Just write 2 updates , one for little & text, and second for priceA if ....
Level 75
Post::where('id', 1)->update([
'title' => $title,
'text' => $text
] + ($checkPrice > 100 ? [
'priceA'=> $priceA
] : []));
4 likes
Level 39
@MichalOravec smart :)
Please or to participate in this conversation.