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

The common way is to load the row to update:

$post = Post::find($id);

I your case

$post = Post::find(3);
$post->title = "Updated title";
$post->save();

But in one step (just update) you can do this:

$affectedRows = Post::where("id", 3)->update(["title" => "Updated title"]);

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

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

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

[php] Laravel eloquent update record without loading from database

Examples related to php

Examples related to eloquent

Examples related to laravel-5