/PHP/Laravel/Update or insert in laravel

Update or insert in laravel

Laravel update from query

$affected = DB::table('users')
              ->where('id', 1)
              ->update(['votes' => 1]);

Source: laravel.com

Laravel create or update

// If there's a flight from Oakland to San Diego, set the price to $99.
// If no matching model exists, create one.
$flight = App\Models\Flight::updateOrCreate(
    ['departure' => 'Oakland', 'destination' => 'San Diego'],
    ['price' => 99, 'discounted' => 1]
);

Source: laravel.com

Update or create laravel

$user = User::updateOrCreate(['name' => request()->name], [ 
    'foo' => request()->foo
]);

Source: laracasts.com

Laravel find query

return Destination::orderByDesc(
    Flight::select('arrived_at')
        ->whereColumn('destination_id', 'destinations.id')
        ->orderBy('arrived_at', 'desc')
        ->limit(1)
)->get();

Source: laravel.com

Update or insert in laravel

DB::table('users')
    ->updateOrInsert(
        ['email' => 'john@example.com', 'name' => 'John'],
        ['votes' => '2']
    );

-1

Similar codes

1 vote331 views1 answer
Static function model laravel
PHP Laravel
10 votes275 views6 answers
Laravel Pagination
PHP Laravel
10 votes301 views5 answers
How to remove public from url in laravel
PHP Laravel
1 vote297 views2 answers
Laravel 8
PHP Laravel
10 votes310 views2 answers
Convert collection to array laravel
PHP Laravel
8 votes302 views1 answer
Laravel command to create symlink storage
PHP Laravel
8 votes271 views3 answers
Laravel redirect back with errors and input
PHP Laravel
3 votes293 views1 answer
Laravel mail and sms system
PHP Laravel
4 votes276 views2 answers
Ubuntu laravel storage permission
PHP Laravel
3 votes319 views1 answer
Laravel firstOrFail
PHP Laravel