Creating and Update Laravel Eloquent

Question

What s the shorthand for inserting a new record or updating if it exists    lt  php   shopOwner   ShopMeta  where  shopId         theID      - gt where  metadataKey        2001 - gt first     if   shopOwner    null           Insert new record into database   else          Update the existing record

User · Answer

2020 Update As in Laravel  gt   5 3  if someone is still curious how to do so in easy way  Its possible by using   updateOrCreate    For example for asked question you can use something like   matchThese     shopId   gt  theID  metadataKey   gt 2001   ShopMeta  updateOrCreate  matchThese   shopOwner   gt  New One      Above code will check the table represented by ShopMeta  which will be most likely shop metas unless not defined otherwise in model itself and it will try to find entry with column shopId    theID and column metadateKey   2001 and if it finds then it will update column shopOwner of found row to New One  If it finds more than one matching rows then it will update the very first row that means which has lowest primary id  If not found at all then it will insert a new row with   shopId    theID metadateKey   2001 and shopOwner   New One Notice Check your model for  fillable and make sue that you have every column name defined there which you want to insert or update and rest columns have either default value or its id column auto incremented one  Otherwise it will throw error when executing above example  Illuminate Database QueryException with message  SQLSTATE HY000   General error  1364 Field       doesn t have a default value  SQL  insert into                   updated at    created at   values          xxxx-xx-xx xx xx xx  xxxx-xx-xx xx xx xx     As there would be some field which will need value while inserting new row and it will not be possible as either its not defined in  fillable or it doesnt have default value  For more reference please see Laravel Documentation at   https   laravel com docs 5 3 eloquent One example from there is     If there s a flight from Oakland to San Diego  set the price to  99     If no matching model exists  create one   flight   App Flight  updateOrCreate        departure    gt   Oakland    destination    gt   San Diego          price    gt  99      which pretty much clears everything  Query Builder Update Someone has asked if it is possible using Query Builder in Laravel  Here is reference for Query Builder from Laravel docs  Query Builder works exactly the same as Eloquent so anything which is true for Eloquent is true for Query Builder as well  So for this specific case  just use the same function with your query builder like so   matchThese   array  shopId   gt  theID  metadataKey   gt 2001   DB  table  shop metas    updateOrCreate  matchThese   shopOwner   gt  New One      Of course  don t forget to add DB facade  use Illuminate Support Facades DB   OR use DB   I hope it helps

User · Answer

shopOwner   ShopMeta  firstOrNew array  shopId    gt   theID  metadataKey    gt  2001      Then make your changes and save  Note the firstOrNew doesn t do the insert if its not found  if you do need that then its firstOrCreate

User · Answer

Isn t this the same as updateOrCreate         It is similar but not the same  The updateOrCreate   will only work   for one row at a time which doesn t allow bulk insert    InsertOnDuplicateKey will work on many rows    https   github com yadakhov insert-on-duplicate-key

User · Answer

Save function    shopOwner- gt save     already do what you want      Laravel code          If the model already exists in the database we can just update our record        that is already in this database using the current IDs in this  where         clause to only update this model  Otherwise  we ll just insert them      if   this- gt exists                 saved    this- gt performUpdate  query                 If the model is brand new  we ll insert it into our database and set the        ID attribute on the model to the value of the newly inserted row s ID        which is typically an auto-increment value managed by the database      else                saved    this- gt performInsert  query

User · Answer

Actually firstOrCreate would not update in case that the register already exists in the DB  I improved a bit Erik s solution as I actually needed to update a table that has unique values not only for the column  id          If the register exists in the table  it updates it      Otherwise it creates it     param array  data Data to Insert Update     param array  keys Keys to check for in the table     return Object     static function createOrUpdate  data   keys         record   self  where  keys - gt first        if  is null  record             return self  create  data         else           return self  where  keys - gt update  data             Then you d use it like this   Model  createOrUpdate          array       id a    gt  1       foo    gt   bar             array       id a    gt  1

User · Answer

Updated  Aug 27 2014 -  updateOrCreate Built into core      Just in case people are still coming across this    I found out a few weeks after writing this  that this is in fact part of Laravel s Eloquent s core     Digging into Eloquent   s equivalent method s   You can see here    https   github com laravel framework blob 4 2 src Illuminate Database Eloquent Model php L553  on  570 and  553                 Create or update a record matching the attributes  and fill it with values                 param  array   attributes         param  array   values         return static             public static function updateOrCreate array  attributes  array  values   array                   instance   static  firstOrNew  attributes             instance- gt fill  values - gt save             return  instance            Old Answer Below    I am wondering if there is any built in L4 functionality for doing this in some way such as     row   DB  table  table  - gt where  id         id - gt first       Fancy field   gt  data assignments here  row- gt save      I did create this method a few weeks back        Within a Model extends Eloquent public static function createOrUpdate  formatted array         row   Model  find  formatted array  id         if   row     null            Model  create  formatted array           Session  flash  footer message    CREATED          else            row- gt update  formatted array           Session  flash  footer message    EXISITING               affected row   Model  find  formatted array  id         return  affected row      I Hope that helps  I would love to see an alternative to this if anyone has one to share    erikthedev

User · Answer

One more option if your id isn t autoincrement and you know which one to insert update    object   MyModel  findOrNew  id     assign attributes to update     object- gt save

User · Answer

firstOrNew will create record if not exist and updating a row if already exist   You can also use updateOrCreate here is the full example   flight   App Flight  updateOrCreate        departure    gt   Oakland    destination    gt   San Diego          price    gt  99        If there s a flight from Oakland to San Diego  set the price to  99  if not exist create new row  Reference Doc here   https   laravel com docs 5 5 eloquent

User · Answer

Try more parameters one which will surely find and if available update and not then it will create new  save data  Model  firstOrNew   key1    gt   key1value  key   gt  key2value      your values here  save data- gt save

User · Answer

If you need the same functionality using the DB  in Laravel  gt   5 5 you can use   DB  table  table name  - gt updateOrInsert  attributes   values     or the shorthand version when  attributes and  values are the same   DB  table  table name  - gt updateOrInsert  values

User · Answer

Like the firstOrCreate method  updateOrCreate persists the model  so there s no need to call save       If there s a flight from Oakland to San Diego  set the price to  99     If no matching model exists  create one    flight   App Flight  updateOrCreate       departure    gt   Oakland    destination    gt   San Diego         price    gt  99       And for your issue   shopOwner   ShopMeta  updateOrCreate       shopId    gt   theID   metadataKey    gt   2001         other field    gt   val    other field    gt   val

User · Answer

like  JuanchoRamone posted above  thank  Juancho  it s very useful for me  but if your data is array you should modify a little like this   public static function createOrUpdate  data   keys         record   self  where  keys - gt first        if  is null  record             return self  create  data         else           return  record- gt update  data

User · Answer

check if a user exists or not  If not  insert   exist   DB  table  User  - gt where   username   gt  username  password   gt  password  - gt get    if count  exist    gt 0        echo  User already exist      else         data array  username   gt  username  password   gt  password       DB  table  User  - gt insert  data     Laravel 5 4

User · Answer

Here s a full example of what  lu cip  was talking about    user   User  firstOrNew array  name    gt  Input  get  name       user- gt foo   Input  get  foo     user- gt save      Below is the updated link of the docs which is on the latest version of Laravel  Docs here  Updated link

[php] Creating and Update Laravel Eloquent

2020 Update

Query Builder Update

Examples related to php

Examples related to laravel

Examples related to eloquent

Examples related to laravel-query-builder