Why Query Builder offers flexibility in Laravel - See It in Action

Why Query Builder offers flexibility

📖 Scenario: You are building a small Laravel application to manage a bookstore's inventory. You want to fetch books based on different conditions like price, author, and availability. Using Laravel's Query Builder will help you write flexible and readable database queries.

🎯 Goal: Build a Laravel Query Builder example that shows how to flexibly fetch books from the database using different conditions and chaining methods.

📋 What You'll Learn

Create a $books variable with a base query selecting from the books table

Add a configuration variable $maxPrice to filter books cheaper than this price

Use Query Builder methods to filter books where price is less than $maxPrice and available is true

Complete the query by ordering the results by title ascending

💡 Why This Matters

🌍 Real World

Query Builder helps developers write database queries that are easy to read, modify, and maintain without writing raw SQL. This flexibility is useful in real applications where query conditions change based on user input or business rules.

💼 Career

Understanding Query Builder is essential for Laravel developers to build efficient and secure database interactions. It improves productivity and reduces errors compared to raw SQL queries.

1

DATA SETUP: Create base query for books

Create a variable called $books and set it to a Query Builder instance selecting from the books table using DB::table('books').

Laravel

<?php

use Illuminate\Support\Facades\DB;

// Create a variable $books with DB::table('books')
// Your code here

Need a hint?

Use DB::table('books') to start the query.

2

CONFIGURATION: Define maximum price filter

Add a variable called $maxPrice and set it to 20 to use as a price filter.

Laravel

<?php

use Illuminate\Support\Facades\DB;

$books = DB::table('books');

// Define $maxPrice as 20
// Your code here

Need a hint?

Just create a variable $maxPrice and assign it the number 20.

3

CORE LOGIC: Add filters using Query Builder methods

Use the where method on $books to filter where price is less than $maxPrice and where available is true. Chain these methods to $books.

Laravel

<?php

use Illuminate\Support\Facades\DB;

$books = DB::table('books');

$maxPrice = 20;

// Add where conditions for price < $maxPrice and available = true
// Your code here

Need a hint?

Chain two where calls on $books to filter by price and availability.

4

COMPLETION: Order results by title ascending

Complete the query by chaining the orderBy method on $books to sort results by title in ascending order.

Laravel

where('price', 'where('available', true);

// Add orderBy to sort by title ascending
// Your code here

Need a hint?

Use orderBy('title', 'asc') chained to $books.