Laravel ДЗ №2

ModelBaseFunction.php

<?php

namespace App\Models;

use Illuminate\Support\Facades\DB;

class  ModelBaseFunction {
	private $table_name = 'users';
	
    public function getAllUsers(){
	return DB::select('select * from users');
    }
	
    public function getCountUsers(){
	return DB::table($this->table_name)->count();
    }
	
    public function getUserById() {
	$id=DB::table($this->table_name)
		->where('id', 1)
		->first();
    }
}

users.blade.php

<span>Количество записей: {{$countUsers}}</span>
<table cellspacing="3" border="2" cellpadding="5">
    <tr>
        <th>id</th>
        <th>Логин</th>
	<th>Пароль</th>
    </tr>
    @foreach ($allUsers as $user)
        <tr>
            <td>{{$user->id}}</td>
            <td>{{$user->login}}</td>
	    <td>{{$user->password}}</td>
        </tr>
    @endforeach
</table>

UsersController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use App\Models\ModelBaseFunction;

class UsersController extends Controller
{
    public function  allAction(){
        $user = new ModelBaseFunction();
        $allUsers = $user->getAllUsers();
        $countUsers = $user->getCountUsers();
        $idUser = $user->getUserById();
        return view('users', ['allUsers'=>$allUsers], ['countUsers'=>$countUsers], ['idUser'=>$idUser]);
    }
}

web.php

<?php

Route::get('users', 'UsersController@allAction');