How to fetch/retrieve data from database in Laravel 8

How to fetch/retrieve data from database in Laravel 8


In this post, you will learn how to retrieve data from database in laravel where we will be using Bootstrap 5 version to design the user interface which is to design the HTML table to display the IMAGE and DATA from database using eloquent model in laravel.

So before getting started, Create a new laravel project and give the Database Connection in .env file.

Step 1: To fetch the data from database you have been already created a Model and Migration and a Controller in laravel application: 

So now, we need to insert/add few data into database in laravel. Click me: How to Insert data in laravel .after inserting your data then we have to follow with STEP 2.

Step 2: Give a route to call the function in your controller for calling the page in the following path: routes/web.php as follows:

<?php

use Illuminate\Support\Facades\Route;
use App\Http\Controllers\StudentController;

Route::get('students', [StudentController::class'index']);

Step 3: Let's go to the controller in the following path : app/Http/Controllers/StudentController.php file.

<?php

namespace App\Http\Controllers;

use App\Models\Student;
use Illuminate\Http\Request;

class StudentController extends Controller
{
    public function index()
    {
        $student = Student::all();
        return view('student.index'compact('student'));
    }
}

Step 4: Create a blade file named index.blade.php inside student folder as the following path: resources/views/student/index.blade.php file as follows:

@extends('layouts.app')

@section('content')

<div class="container">
    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <h4>How to Fetch data in Laravel 8</h4>
                </div>
                <div class="card-body">

                    <table class="table table-bordered table-striped">
                        <thead>
                            <tr>
                                <th>ID</th>
                                <th>Name</th>
                                <th>Email</th>
                                <th>Course</th>
                                <th>Section</th>
                                <th>Edit</th>
                                <th>Delete</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($student as $item)
                            <tr>
                                <td>{{ $item->id }}</td>
                                <td>{{ $item->name }}</td>
                                <td>{{ $item->email }}</td>
                                <td>{{ $item->course }}</td>
                                <td>{{ $item->section }}</td>
                                <td>
                                    <a href="" class="btn btn-primary btn-sm">Edit</a>
                                </td>
                                <td>
                                    <a href="" class="btn btn-danger btn-sm">Delete</a>
                                </td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>

                </div>
            </div>
        </div>
    </div>
</div>

@endsection

Now, you can successfully run the application by the following command:

$ php artisan serve

now lets go to the browser at the link: http://localhost:8000/students


Thanks for reading...

© Copyright - 2018 - 2021 | All rights reserved at Funda of Web IT