• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Tutsplanet

Tutsplanet

Free Technical and Blogging Resources

  • Home
  • Web Hosting
  • Programming
  • Plugins
  • Twitter Trends
  • Tools
  • About Us

Programming TagsLaravel

Laravel 8 Eloquent updateOrCreate() Example

May 27, 2022 Editorial Staff Leave a Comment

Share
Tweet
Share

In this post, we will explain about Laravel Eloquent updateOrCreate() method and its importance in our code. It’s very common that we have database operations in our application, like inserting customer details and updating that customer details in a later stage, or deleting customer details.

For example, you have a function that is responsible for creating a user if he is not existing or updating the user details if he is existing.

Let’s see how we can achieve that in Laravel.

For this example, we have set the email address as a unique field.

$email = '[email protected]';
$phone = '909090900';
$city  = 'New York';

$user = User::where('email', $email)->first();

if(is_null($user)) {
   // creates the user
   User::create([
     'email' => $email,
     'phone' => $phone,
     'city'  => $city
   ]);
}
else {
   $user->update([
     'phone' => $phone,
     'city'  => $city
   ]);
}

So far we have done what we have to do to achieve insert/update a user record. Indeed, it’s not a bad solution, but if we have an option for the more elegant solution, would you pick that?.

Laravel has an elegant method to deal with this situation and that’s the function updateOrCreate(). This function takes the first parameter as the select condition as an array and the second parameter as values that need to be updated as an array.

$user = User::updateOrCreate([
          'email' => $email
  ],
  [
    'phone' => $phone',
    'city'  => $city
]);

print_r($user);

Please let us know if you have any comments.


Related Posts

  • How to Substract and Add Hours in Laravel Using Carabon?
  • How to Get Last Week Data in Laravel using Carbon?
  • Differences between query() and input() in Laravel?
  • Raw Queries in Laravel
  • Laravel Eloquent Select Column as Alias
  • What does Model::unguard() do in Laravel?
  • collect.js – A Laravel collection clone in JavaScript
  • How to Export CSV file in Laravel Example
  • How to create Your Own Custom Log File in Laravel
  • Laravel db raw and whereRaw() where clause example
  • Laravel Artisan command for generating Request validation Class
  • Bind vs Singleton in Laravel. Which one to use, and when?
  • Attribute Casting with Laravel
  • How To Get HTTP Hostname In Laravel ?
  • How to call static function from Helper in Laravel blade file?
  • Laravel WhereHas() Eloquent Example
  • How to Rollback migration in Laravel ?
  • Laravel str is() Function With Example
  • How to use Faker with Laravel ?
  • How to Add Foreign Key in Laravel Migration?
  • Check for the application environment in Laravel views or controller
  • How to Get a List of Registered Route Paths in Laravel 8?
  • Two ways to set default DB column value in Laravel
  • How to constrain a route parameter with a given regular expression globally in Laravel?
  • Add default current timestamp to Laravel migration
  • Using Laravel’s dd (dump and die) function in your application
  • Laravel 8 – Ajax File Upload with Progress Bar
  • Laravel 8 Create Custom Helper Functions (Global function)
  • Automatically Set a Local Timezone for Users In Laravel
  • Force HTTPS with a Middleware in Laravel
  • Difference between Laravel’s raw SQL functions
  • Laravel date set timezone
  • How to create console command in laravel ?
  • How to clear laravel.log in Laravel?
  • How to create a custom console command (artisan) for Laravel
  • Hierarchical Tree view Category Example in Laravel
  • How To Install And Use CKEditor In Laravel?
  • Laravel Auth: Login with username instead of Email
  • What is Laravel Mass Assignment, Guarded or Fillable?
  • Laravel Image Intervention Tutorial With Example
  • How to delete file from public folder in Laravel?
  • How to run Laravel validation if the field is not empty?
  • How to select specific columns in laravel eloquent ORM?
  • How to Use reCAPTCHA in Laravel 5 Forms For Validation
  • Redirect urls to HTTPS in Laravel 5
  • Create a database table in Laravel in controller
  • Custom validation messages in Laravel 5
  • How to use DB query builder toArray() laravel 5?
  • How to add new methods to a resource controller in Laravel?
  • How to get Query Strings Value from a URL in Laravel 5.5?

Editorial Staff

Editorial Staff at Tutsplanet is a dedicated team to write various tutorials about subjects like Programming, Technology and Operating Systems.

View all posts by Editorial Staff

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Quick Links

  • Top 21 Website Ideas To Make Money Online in 2021
  • A Simple YouTube Video Downloader Script in PHP
  • The 50 Most Useful jQuery Plugins for Frontend Development
  • Replace “\n” with new line characters, using Notepad++
  • Using Third-Party Libraries in Codeigniter
  • Upload Multiple Images and Store in Database using PHP and MySQL.
  • Hierarchical Tree view Category Example in Laravel
  • Laravel Image Intervention Tutorial With Example
  • How to import sql file in MySQL database using PHP?
  • Free VAT Calculator Online

Subscribe

* indicates required

Search Here

Share

   

Hot topics

  • Replace “\n” with new line characters, using Notepad++ 57 views
  • How to enter new line in Microsoft Teams? 38 views
  • Open a URL in a new tab using JavaScript 28 views
  • A Simple YouTube Video Downloader Script in PHP 25 views
  • Laravel WhereHas() Eloquent Example 22 views
  • How to change PHP version on MAMP – Mac OSX 18 views
  • How to Create PDF File From HTML Form Using Fpdf? 17 views
  • PHP: Implode () with quotes 15 views
  • Simple PHP Shopping Cart 15 views
  • Get Uploads Directory Path in WordPress 14 views

Categories

  • Design & Development
  • Drupal
  • Facebook
  • General
  • How To
  • ios
  • Javascript
  • Linux
  • Magento
  • Marketing
  • News
  • PHP
  • Plugins
  • Programming
  • Snippets List
  • Social Media
  • Softwares
  • Themes
  • Tips
  • Wordpress
  • YouTube

Copyright © 2022 · Planet on Genesis Framework · Powered By BunnyCDN . Network wallpapernoon.com