Introduction to Laravel Eloquent ORM

Laravel Eloquent ORM (Object-Relational Mapping) is a key feature of the Laravel framework. It provides an elegant way to interact with your database. With Eloquent, each table in your database corresponds to a model, allowing you to work with data using PHP syntax rather than writing raw SQL queries.

-> Basic Usage:

Eloquent models represent database tables, making performing CRUD (Create, Read, Update, Delete) operations easy. For example, if you have a user table, you would create a User model to interact with it:

php artisan make: model User

-> Common Operations:

1. Retrieve all records:
$users = User::all();
2. Find a record by ID:
$user = User::find(1);
3. Create a new record:
User::create([‘name’ => ‘John Doe’, ’email’ => ‘john@example.com’]);
4. Update a record:
$user->update([‘name’ => ‘Jane Doe’]);
5. Delete a record:
$user->delete();

-> Eloquent Relationships:

Eloquent makes it easy to define and manage relationships between different models:
1. One-to-Many Relationship: For example, a blog post may have multiple comments:
public function comments() {
return $this->hasMany(Comment::class);
}
2. Belongs To Relationship: If a comment belongs to a post:
public function post() {
return $this->belongsTo(Post::class);
}

->Eloquent Scopes

Scopes allow you to define common query logic in your models that can be reused across your application. For example, you can create a scope to retrieve only active users:

public function scopeActive($query) {
return $query->where(‘status’, ‘active’);
}

->Conclusion:

Laravel Eloquent ORM simplifies database interactions by providing a clean, readable syntax for performing common database operations. It abstracts away the complexity of raw SQL queries and allows you to focus on your application’s business logic. With Eloquent, handling relationships, querying data, and working with models becomes intuitive and efficient.

 

Leave a Reply