How to foreach loop table using | PHP Laravel
Step 1: Install Laravel 5.7 Project
In the first step, we will install Laravel 7 application using bellow command, So open your terminal OR command prompt and run bellow command:
composer create-project --prefer-dist laravel/laravel blog
Step 1: Database connection
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=management_system
DB_USERNAME=root
DB_PASSWORD=123456
Step 1: route
// ======================== user ======================== //Route::get('user', 'HomeController@usertotal');
Step : HomeController.php/select all
public function usertotal() { $user = Auth::user(); $userselect = DB::table('users') ->get(); return view('password.user',compact('user',$user,'userselect')); }Step 2: password/user
View/password/user.blade.php
@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">
<div id="simpletable_wrapper" class="dataTables_wrapper dt-bootstrap4"><div class="row"><div class="col-xs-12 col-sm-12 col-sm-12 col-md-6"><div class="dataTables_length" id="simpletable_length"><label>Show <select name="simpletable_length" aria-controls="simpletable" class="form-control input-sm"><option value="10">10</option><option value="25">25</option><option value="50">50</option><option value="100">100</option></select> entries</label></div></div><div class="col-xs-12 col-sm-12 col-md-6"><div id="simpletable_filter" class="dataTables_filter"><label>Search:<input type="search" class="form-control input-sm" placeholder="" aria-controls="simpletable"></label></div></div></div><div class="row"><div class="col-xs-12 col-sm-12"><table id="simpletable" class="table table-striped table-bordered nowrap dataTable" role="grid" aria-describedby="simpletable_info">
<thead>
<tr role="row">
<th class="sorting_asc" tabindex="0" aria-controls="simpletable" rowspan="1" colspan="1" aria-sort="ascending" aria-label="Name: activate to sort column descending" style="width: 265px;">ID</th>
<th class="sorting" tabindex="0" aria-controls="simpletable" rowspan="1" colspan="1" aria-label="Position: activate to sort column ascending" style="width: 387px;">Name</th>
<th class="sorting" tabindex="0" aria-controls="simpletable" rowspan="1" colspan="1" aria-label="Office: activate to sort column ascending" style="width: 196px;">Email</th>
<th class="sorting" tabindex="0" aria-controls="simpletable" rowspan="1" colspan="1" aria-label="Age: activate to sort column ascending" style="width: 105px;">Profile User</th>
<th class="sorting" tabindex="0" aria-controls="simpletable" rowspan="1" colspan="1" aria-label="Start date: activate to sort column ascending" style="width: 199px;">Date Join</th>
<th class="sorting" tabindex="0" aria-controls="simpletable" rowspan="1" colspan="1" aria-label="Salary: activate to sort column ascending" style="width: 143px;">Update Join</th>
</tr>
</thead>
<tbody>
@foreach($userselect as $totaluser)
<tr role="row" class="odd">
<td class="sorting_1">{{$totaluser->id}}</td>
<td>{{$totaluser->name}}</td>
<td>{{$totaluser->email}}</td>
<td> <img src="..\files\assets\images\{{$user->avatar}}"alt="User-Profile-Image" width= "25%;"></td>
<td>{{$totaluser->created_at}}</td>
<td>{{$totaluser->updated_at}}</td>
</tr>
@endforeach
</tbody>
<tfoot>
<tr>
<th rowspan="1" colspan="1">ID</th>
<th rowspan="1" colspan="1">Name</th>
<th rowspan="1" colspan="1">Email</th>
<th rowspan="1" colspan="1">Profile User</th>
<th rowspan="1" colspan="1">Date Join</th>
<th rowspan="1" colspan="1">Update Join</th>
</tr>
</tfoot>
</table>
</div>
</div>
<div class="row">
<div class="col-xs-12 col-sm-12 col-md-5">
<div class="dataTables_info" id="simpletable_info" role="status" aria-live="polite">Showing 1 to 10 of 20 entries
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-7">
<div class="dataTables_paginate paging_simple_numbers" id="simpletable_paginate">
<ul class="pagination">
<li class="paginate_button page-item previous disabled" id="simpletable_previous">
<a href="#" aria-controls="simpletable" data-dt-idx="0" tabindex="0" class="page-link">Previous</a>
</li>
<li class="paginate_button page-item active">
<a href="#" aria-controls="simpletable" data-dt-idx="1" tabindex="0" class="page-link">1</a>
</li>
<li class="paginate_button page-item next" id="simpletable_next">
<a href="#" aria-controls="simpletable" data-dt-idx="3" tabindex="0" class="page-link">Next</a>
</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Zero config.table end -->
</div>
</div>
</div>
</div>
</div>
</div>
@endsection
0 Comments
CAN FEEDBACK
Emoji