CRUD with Eloquent in Laravel - Mini Project: Build & Apply

CRUD with Eloquent

📖 Scenario: You are building a simple Laravel app to manage a list of books in a library. Each book has a title and an author.

🎯 Goal: Create a Laravel Eloquent model and perform basic CRUD (Create, Read, Update, Delete) operations on the Book model.

📋 What You'll Learn

Create a Book model with title and author fields

Create a new book record

Retrieve all books from the database

Update a book's title

Delete a book record

💡 Why This Matters

🌍 Real World

Managing data records in a Laravel application is common for websites and APIs that handle users, products, or content.

💼 Career

Understanding CRUD with Eloquent is essential for Laravel developers to build and maintain database-driven applications efficiently.

1

Create the Book model

Create a Laravel Eloquent model called Book with title and author as fillable properties.

Laravel

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Book extends Model
{
    // Add the fillable property with 'title' and 'author'
}

Need a hint?

Use the protected $fillable property to allow mass assignment of title and author.

2

Create a new book record

Create a new Book record with title set to 'The Great Gatsby' and author set to 'F. Scott Fitzgerald' using the create method.

Laravel

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Book extends Model
{
    protected $fillable = ['title', 'author'];
}

// Create a new book record with title 'The Great Gatsby' and author 'F. Scott Fitzgerald'

Need a hint?

Use Book::create([...]) with an array of title and author.

3

Retrieve all books

Retrieve all Book records from the database using the all() method and store them in a variable called books.

Laravel

 'The Great Gatsby', 'author' => 'F. Scott Fitzgerald']);

// Retrieve all books and store in $books

Need a hint?

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

4

Update and delete a book

Update the title of the $book variable to 'The Great Gatsby - Revised' and then delete the $book record using Eloquent methods.

Laravel

 'The Great Gatsby', 'author' => 'F. Scott Fitzgerald']);

$books = Book::all();

// Update $book title and delete $book

Need a hint?

Assign the new title to $book->title, call $book->save() to update, then call $book->delete() to remove the record.