What are some examples of using Eloquent in Laravel?

What are some examples of using Eloquent in Laravel?

Eloquent is Laravel's ORM that provides a beautiful, simple ActiveRecord implementation for working with your database. Here are a few examples:

1. Retrieving All Records: User::all();
2. Finding a Record by ID: User::find(1);
3. Creating a New Record: User::create(['name' => 'John', 'email' => '[email protected]']);
4. Updating a Record: User::find(1)->update(['name' => 'Jane']);
5. Deleting a Record: User::destroy(1);

Can you explain how to set up relationships in Eloquent?

Sure! In Eloquent, you can define relationships in your models. For example:

• One-to-One: In the User model, you can define a method like public function profile() { return $this->hasOne(Profile::class); }
• One-to-Many: In the Post model, you can define public function comments() { return $this->hasMany(Comment::class); }
• Many-to-Many: In the User model, you can define public function roles() { return $this->belongsToMany(Role::class); }.

What are some common queries I can perform with Eloquent?

Common queries include:

• Where Clauses: User::where('active', 1)->get();
• Ordering Results: User::orderBy('created_at', 'desc')->get();
• Pagination: User::paginate(10);
• Aggregates: User::count(); or User::max('age');.

How can I use Eloquent with query scopes?

You can define query scopes in your model for reusable query logic. For example:

public function scopeActive($query) {
    return $query->where('active', 1);
}

Then you can use it like this: User::active()->get();.