How to get one record from the database?

Question

Laravel

How can I get one specific record from the database? My solution doesn't work because I don't understand how to put in the id variable, which specifies the post number. If instead $idof writing some number, then everything works

<?php

namespace App\Http\Controllers;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\DB;

class TestController extends Controller
{
    public function show($id)
    {
        $result = DB::select('select * from users where id = ?', [$id]);
        foreach($result as $item){
                $login = $item->login;
                $password = $item->password;
            }
        return view('test',[
            'login' => $login,
            'password' => $password,
        ]);
    }
}
?>

Answer 1

namespace App\Http\Controllers;

use App\Http\Controllers\Controller;
use App\Models\User;

class TestController extends Controller
{
    public function show($id)
    {
       $user = User::findOrFail($id);
    }
}