How get data from another table in Laravel customize

Step 1: Install Laravel 5.7 Project

To install a Laravel project, use the following command:

composer create-project --prefer-dist laravel/laravel blog

This command will create a new Laravel project named blog.

Step 2: Set Up Database Connection

In your .env file, you will need to define the database connection:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=management_system
DB_USERNAME=root
DB_PASSWORD=123456

Ensure your MySQL database is running and that you have created the management_system database before proceeding.

Step 3: Define Routes

In the routes/web.php file, define a route for displaying user data:

// ======================== user ======================== //
Route::get('user', 'HomeController@usertotal');

This route will call the usertotal method in the HomeController.

Step 4: Controller - HomeController.php

In the HomeController.php file, define the usertotal method to fetch the authenticated user's details and pass it to the view.

public function usertotal()
{
    $user = Auth::user();
    return view('password.user', compact('user'));
}

This method fetches the currently authenticated user and passes it to the user view in the password folder.

Step 5: Create the View (resources/views/password/user.blade.php)

In the resources/views/password/user.blade.php file, and create the HTML structure for displaying user data in a table format.

@extends('layouts.master')

@section('menu')
    @include('sidebar.dashboard')

    <div class="pcoded-content">
        <div class="pcoded-inner-content">
            <div class="main-body">
                <div class="page-wrapper">

                    <div class="page-header">
                        <div class="row align-items-end">
                            <div class="col-lg-8">
                                <div class="page-header-title">
                                    <div class="d-inline">
                                        <h4>Table User</h4>
                                        <span>User display all</span>
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-4">
                                <div class="page-header-breadcrumb">
                                    <ul class="breadcrumb-title">
                                        <li class="breadcrumb-item">
                                            <a href="index-1.htm"> <i class="feather icon-home"></i> </a>
                                        </li>
                                        <li class="breadcrumb-item"><a href="#!">User Table</a></li>
                                        <li class="breadcrumb-item"><a href="#!">Back home</a></li>
                                    </ul>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="page-body">
                        <div class="row">
                            <div class="col-sm-12">
                                <!-- Zero config.table start -->
                                <div class="card">
                                    <div class="card-header">
                                        <h5>User</h5>
                                        <span>count total</span>
                                    </div>
                                    <div class="card-block">
                                        <div class="dt-responsive table-responsive">
                                            <table id="simpletable" class="table table-striped table-bordered nowrap">
                                                <thead>
                                                    <tr>
                                                        <th>ID</th>
                                                        <th>Name</th>
                                                        <th>Email</th>
                                                        <th>Profile User</th>
                                                        <th>Date Join</th>
                                                        <th>Update Join</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    <tr>
                                                        <td>{{ $user->id }}</td>
                                                        <td>{{ $user->name }}</td>
                                                        <td>{{ $user->email }}</td>
                                                        <td>{{ $user->profile }}</td>
                                                        <td>{{ $user->created_at }}</td>
                                                        <td>{{ $user->updated_at }}</td>
                                                    </tr>
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                                <!-- Zero config.table end -->
                            </div>
                        </div>
                    </div>

                </div>
            </div>
        </div>
    </div>
@endsection

Key Points in the Code:

1. User Data: The user data fetched by Auth::user() is displayed in the table. You can customize this to display additional user attributes as needed.

2. Table Structure: A responsive table is used to display user details such as ID, Name, Email, Profile User, Date Join, and Update Join.

3. Pagination: If you want to handle a large number of users, consider implementing pagination in the controller and view.