CRUD with Eloquent in Laravel - Step-by-Step Execution

Concept Flow - CRUD with Eloquent

Create Model Instance

↓

Set Attributes

↓

Save to DB

↓

Read Data

↓

Update Attributes

↓

Save Changes

↓

Delete Record

↓

End

This flow shows how to create, read, update, and delete records using Eloquent models step-by-step.

Execution Sample

Laravel

use App\Models\Post;

// Create
$post = new Post();
$post->title = 'Hello';
$post->save();

This code creates a new Post record with the title 'Hello' and saves it to the database.

Execution Table

Step	Action	Model State	Database State	Output/Result
1	Create new Post instance	Post object with no attributes set	No new record	No output
2	Set title attribute to 'Hello'	Post object with title='Hello'	No new record	No output
3	Call save() to insert record	Post object saved	New record with title='Hello' added	Record ID assigned
4	Read record by ID	Post object with title='Hello'	Record exists	Post data retrieved
5	Update title to 'Hello World'	Post object with title='Hello World'	Record still original	No output
6	Call save() to update record	Post object saved with new title	Record updated with title='Hello World'	No output
7	Call delete() on Post	Post object marked deleted	Record removed from DB	No output
8	Try to read deleted record	No Post object found	No record	Null returned
9	End of CRUD operations	-	-	-

💡 CRUD cycle ends after delete and failed read of deleted record

Variable Tracker

Variable	Start	After Step 2	After Step 3	After Step 5	After Step 6	After Step 7	After Step 8
$post	null	Post(title='Hello')	Post(saved with ID)	Post(title='Hello World')	Post(saved updated)	Post(deleted)	null

Key Moments - 3 Insights

Why does the Post object exist after save() but before delete()?

Because save() writes the data to the database but the object in memory still exists until delete() is called (see steps 3 and 7 in execution_table).

What happens if you try to read a record after deleting it?

The read returns null because the record no longer exists in the database (see step 8 in execution_table).

Does changing attributes update the database immediately?

No, changes to attributes only affect the model in memory until save() is called to update the database (see steps 5 and 6).

Visual Quiz - 3 Questions

Look at the execution table, what is the database state after step 3?

A No new record

B Record updated with title='Hello World'

C New record with title='Hello' added

D Record removed from DB

💡 Hint

Check the 'Database State' column for step 3 in the execution_table.

At which step does the Post object get deleted from the database?

A Step 5

B Step 7

C Step 8

D Step 3

💡 Hint

Look for the 'delete()' action in the 'Action' column of execution_table.

If you update the title but forget to call save(), what happens to the database?

A Database remains unchanged

B Record is deleted

C Database updates automatically

D New record is created

💡 Hint

Refer to steps 5 and 6 in execution_table to see when database updates occur.

Concept Snapshot

CRUD with Eloquent:
- Create: new Model(); set attributes; save()
- Read: Model::find(id) or queries
- Update: change attributes; save()
- Delete: call delete() on model
Remember: save() writes changes to DB, delete() removes record.

Full Transcript

This visual execution trace shows how to perform CRUD operations using Laravel's Eloquent ORM. First, a new model instance is created and attributes are set in memory. Calling save() inserts the record into the database. Reading retrieves the record by ID. Updating changes attributes in memory and requires save() to update the database. Deleting removes the record from the database. Trying to read a deleted record returns null. The variable tracker shows the $post model's state through each step. Key moments clarify that save() is needed to persist changes and that the model object exists separately from the database record. The quiz tests understanding of when database changes happen and the effect of delete(). This step-by-step flow helps beginners see how Eloquent manages data in code and database.