Why database integration is core in Laravel - See It in Action

Why database integration is core

📖 Scenario: You are building a simple Laravel application to manage a list of books in a library. To keep track of the books, you need to connect your app to a database where the book information will be stored and retrieved.

🎯 Goal: Learn why database integration is essential in Laravel by creating a basic setup that connects to a database, configures the connection, retrieves data, and displays it.

📋 What You'll Learn

Create a database configuration in Laravel

Set up a model to represent the data

Write a query to fetch data from the database

Display the data in a view

💡 Why This Matters

🌍 Real World

Most web applications need to save and show data like users, products, or posts. Database integration makes this possible.

💼 Career

Understanding database integration is essential for backend and full-stack developers working with Laravel or similar frameworks.

1

Set up database configuration

In the .env file, set the database connection variables exactly as follows: DB_CONNECTION=mysql, DB_HOST=127.0.0.1, DB_PORT=3306, DB_DATABASE=library, DB_USERNAME=root, and DB_PASSWORD=secret.

Laravel

# Your code here to set database variables in .env file

Need a hint?

Open the .env file in your Laravel project root and add or update the database connection lines exactly as shown.

2

Create a Book model

Create a Laravel model named Book using the command php artisan make:model Book. Then, in the app/Models/Book.php file, add the protected $fillable property with the fields 'title' and 'author'.

Laravel

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=library
DB_USERNAME=root
DB_PASSWORD=secret

// Add protected $fillable = ['title', 'author']; in Book model

Need a hint?

Use the artisan command to create the model, then open app/Models/Book.php and add the protected $fillable array.

3

Fetch books from the database

In a controller method, write the code $books = Book::all(); to retrieve all book records from the database.

Laravel

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

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

// Add $books = Book::all(); in controller method

Need a hint?

Inside your controller method, use the Book::all() method to get all books from the database.

4

Display books in a view

In the Blade view file resources/views/books/index.blade.php, add a @foreach ($books as $book) loop to display each book's {{ $book->title }} and {{ $book->author }} inside a list.

Laravel

Need a hint?

Use a Blade @foreach loop to go through each book and show its title and author inside an unordered list.