Select queries in Laravel - Mini Project: Build & Apply

Select Queries in Laravel

📖 Scenario: You are building a simple Laravel application to manage a bookstore. You need to retrieve book data from the database using Laravel's Eloquent ORM.

🎯 Goal: Learn how to write basic select queries using Laravel's Eloquent ORM to fetch data from the books table.

📋 What You'll Learn

Create an Eloquent model for the books table

Write a query to select all books

Write a query to select books with a price greater than 20

Write a query to select only the title and author columns

Write a query to get the first book with the title 'Laravel Basics'

💡 Why This Matters

🌍 Real World

Selecting data from a database is a common task in web applications. Laravel's Eloquent ORM makes it easy to write readable and efficient queries.

💼 Career

Understanding how to write select queries with Eloquent is essential for backend developers working with Laravel to build data-driven applications.

1

Create the Book model

Create an Eloquent model called Book that uses the books table.

Laravel

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

// Your code here

Need a hint?

Use class Book extends Model and set protected $table = 'books';

2

Select all books

Write a query using the Book model to get all books and assign it to a variable called allBooks.

Laravel

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

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

$allBooks = Book::all(); // Your code here

Need a hint?

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

3

Select books with price greater than 20

Write a query using the Book model to get books where the price is greater than 20. Assign the result to a variable called expensiveBooks.

Laravel

', 20)->get(); // Your code here

Need a hint?

Use Book::where('price', '>', 20)->get() to filter books.

4

Select specific columns and get first matching book

Write a query using the Book model to select only the title and author columns. Assign it to titleAuthorBooks. Then write a query to get the first book where the title is 'Laravel Basics' and assign it to laravelBook.

Laravel

', 20)->get();

$titleAuthorBooks = Book::select('title', 'author')->get(); // Your code here

$laravelBook = Book::where('title', 'Laravel Basics')->first(); // Your code here

Need a hint?

Use select('title', 'author')->get() and where('title', 'Laravel Basics')->first().