Why Eloquent simplifies database operations in Laravel - See It in Action

Why Eloquent simplifies database operations

📖 Scenario: You are building a simple Laravel app to manage a list of books in a library. You want to store book details in a database and retrieve them easily.

🎯 Goal: Learn how to use Eloquent ORM to simplify database operations by creating a model, configuring it, querying data, and displaying results.

📋 What You'll Learn

Create a Book model with Eloquent

Configure the model to use the 'books' table

Retrieve all books using Eloquent

Display the list of books in a Blade view

💡 Why This Matters

🌍 Real World

Eloquent helps developers work with databases without writing raw SQL, making apps faster to build and easier to maintain.

💼 Career

Knowing Eloquent is essential for Laravel developers to efficiently handle database operations in real projects.

1

Create the Book model

Create a Laravel Eloquent model called Book inside the app/Models directory.

Laravel

// Your code here to create the Book model

Need a hint?

The model class should extend Model and be in the App\Models namespace.

2

Configure the Book model

Inside the Book model, add a protected property $table and set it to the string 'books' to specify the database table.

Laravel

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Book extends Model
{
    // Add the $table property here
    // Your code here
}

Need a hint?

Use protected $table = 'books'; inside the class.

3

Retrieve all books using Eloquent

In a controller method, write a line of code to get all books from the database using the Book model and store them in a variable called $books.

Laravel

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Book extends Model
{
    protected $table = 'books';
}

// Controller method

use App\Models\Book;

function index()
{
    // Retrieve all books
    // Your code here
}

Need a hint?

Use Book::all() to get all records.

4

Display books in a Blade view

Return a Blade view called books.index from the controller method, passing the $books variable using compact('books').

Laravel

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Book extends Model
{
    protected $table = 'books';
}

// Controller method

use App\Models\Book;

function index()
{
    $books = Book::all();
    // Return the view with books
    // Your code here
}

Need a hint?

Use return view('books.index', compact('books')); to send data to the view.