$user = DB::table('users')
->join('hobbies', 'users.id', '=', 'hobbies.user_id')
->join('personal_informations', 'users.id', '=', 'personal_informations.user_id')
->join('educations', 'users.id', '=', 'educations.user_id')
->select(
'users.id',
'users.firstname',
'lastname',
'status',
'email',
'birthday',
'gender',
'profile_photo',
'header_photo',
'status_chat',
'hobbies.*', 'personal_informations.*', 'educations.*')
->where('users.id', $this->user_id)
->first();
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Models\User;
use Illuminate\Support\Facades\DB;
class AboutsController extends Controller
{
protected int $user_id;
public function show(User $id)
{
$this->user_id = $id->id;
$user = DB::table('users')
->join('hobbies', 'users.id', '=', 'hobbies.user_id')
->join('personal_informations', 'users.id', '=', 'personal_informations.user_id')
->join('educations', 'users.id', '=', 'educations.user_id')
->select(
'users.id',
'users.firstname',
'lastname',
'status',
'email',
'birthday',
'gender',
'profile_photo',
'header_photo',
'hobbies.*', 'personal_informations.*', 'educations.*')
->where('users.id', $this->user_id)
->first();
return view('profile.about', compact('user'));
}
}
Route::get('/id{id}', function ($id)
{
return view('profilepage', ['id' => $id]);
})->where('id', '[0-9]+')->middleware(['auth'])->name('dashboard');
<title>Profile Page {{ $id }} {{ route('dashboard', ['id' => $id]) }}</title>