• 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

  • What is the opposite of has() method in Laravel?
  • Laravel: Download files to storage from SFTP
  • Laravel Eloquent- Where Condition with Two Columns
  • How to Add Foreign Key in Laravel Migration?
  • What is Str::finish() in Laravel ?
  • How to Substract and Add Hours in Laravel Using Carbon?
  • 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

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++ 39 views
  • How to enter new line in Microsoft Teams? 34 views
  • Simple PHP Shopping Cart 18 views
  • Open a URL in a new tab using JavaScript 15 views
  • Add FTP/SFTP in Visual Studio Code 15 views
  • Solution: windows photo viewer opens each time save a pic file 12 views
  • Laravel: Download files to storage from SFTP 12 views
  • Laravel Eloquent Select Column as Alias 11 views
  • A Simple YouTube Video Downloader Script in PHP 11 views
  • How to Create PDF File From HTML Form Using Fpdf? 10 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 © 2023 · Planet on Genesis Framework · Powered By BunnyCDN . Network wallpapernoon.com