1. Home
2. Laravel
3. Working with Laravel Eloquent ORM: A Beginner's Guide to CRUD Operations

Working with Laravel Eloquent ORM: A Beginner's Guide to CRUD Operations

August 10, 2024   Laravel

Laravel's Eloquent ORM (Object-Relational Mapping) is one of the most powerful features of the framework. It provides an elegant and simple way to interact with your database using an active record implementation. In this guide, we'll explore how to use Eloquent ORM and perform basic CRUD (Create, Read, Update, Delete) operations.

1. Introduction to Laravel Eloquent ORM

Eloquent ORM is Laravel’s built-in ORM that allows you to work with your database as if you were working with an object-oriented PHP application. Each database table has a corresponding "Model" that is used to interact with that table.

To get started with Eloquent, you need to create a model that corresponds to a table in your database. You can create a model using the Artisan command:

php artisan make:model Post

This command will create a Post model in the app/Models directory.

2. Creating Data with Eloquent

To insert data into the database, you can use the create method or set the attributes manually and call the save method.

Example using the create method:

use App\Models\Post;

Post::create([
    'title' => 'My First Post',
    'content' => 'This is the content of my first post.',
]);

For this to work, you need to ensure that the fillable property is defined in your model:

class Post extends Model
{
    protected $fillable = ['title', 'content'];
}

Alternatively, you can create a new instance and save it:

$post = new Post;
$post->title = 'My First Post';
$post->content = 'This is the content of my first post.';
$post->save();

3. Reading Data with Eloquent

Eloquent provides various methods to retrieve data from the database, such as all, find, and where.

To retrieve all records:

$posts = Post::all();

To retrieve a single record by its primary key:

$post = Post::find(1);

To retrieve records with a specific condition:

$posts = Post::where('title', 'My First Post')->get();

4. Updating Data with Eloquent

To update an existing record, first, retrieve the record, modify its attributes, and then call the save method:

$post = Post::find(1);
$post->title = 'Updated Title';
$post->save();

You can also use the update method to update records in bulk:

Post::where('id', 1)->update(['title' => 'Updated Title']);

5. Deleting Data with Eloquent

Eloquent makes it easy to delete records from the database. You can delete a record by first retrieving it and then calling the delete method:

$post = Post::find(1);
$post->delete();

Alternatively, you can use the destroy method to delete records by their primary key:

Post::destroy(1);

6. Using Eloquent Relationships

Eloquent ORM also allows you to define relationships between different models. For example, if a Post has many Comment models, you can define this relationship in the Post model:

public function comments()
{
    return $this->hasMany(Comment::class);
}

Then, you can retrieve the comments for a specific post:

$post = Post::find(1);
$comments = $post->comments;

Conclusion

Laravel’s Eloquent ORM simplifies database interactions by allowing you to work with databases using an intuitive, object-oriented syntax. By mastering basic CRUD operations and understanding how to define relationships between models, you can efficiently manage your application's data layer.

For more advanced features and in-depth understanding, explore Laravel’s official documentation and keep practicing with real-world examples.

If you have any questions or need further clarification, feel free to leave a comment below!

 

---

---

---