Laravel eloquent update record without loading from database

Question

I m quite new to laravel and I m trying to update a record from form s input  However I see that to update the record  first you need to fetch the record from database   Isn t is possible to something like to update a record  primary key is set     post   new Post     post- gt id   3    already exists in database   post- gt title    Updated title    post- gt save

User · Answer

You can also use firstOrCreate OR firstOrNew     Retrieve the Post by the attributes  or create it if it doesn t exist     post   Post  firstOrCreate   id    gt  3       OR    Retrieve the Post by the attributes  or instantiate a new instance     post   Post  firstOrNew   id    gt  3         update record  post- gt title    Updated title    post- gt save      Hope it will help you

User · Answer

The common way is to load the row to update    post   Post  find  id     I your case   post   Post  find 3    post- gt title    Updated title    post- gt save      But in one step  just update  you can do this    affectedRows   Post  where  id   3 - gt update   title    gt   Updated title

User · Answer

Post  where  id  3 - gt update   title   gt  Updated title

User · Answer

You can simply use Query Builder rather than Eloquent  this code directly update your data in the database    This is a sample   DB  table  post               - gt where  id   3              - gt update   title    gt   Updated Title       You can check the documentation here for more information  http   laravel com docs 5 0 queries updates

User · Answer

Use property exists    post   new Post     post- gt exists   true   post- gt id   3    already exists in database   post- gt title    Updated title    post- gt save      Here is the API documentation  http   laravel com api 5 0 Illuminate Database Eloquent Model html

[php] Laravel eloquent update record without loading from database

Examples related to php

Examples related to eloquent

Examples related to laravel-5