現状
laravel初心者です。
自作で情報投稿サイトを作成しています。
投稿者の名前のみ表示させたいのですが、optional(Auth::user())->name、と記述しているせいか、全ての投稿がログイン中のユーザー名になってしまいます。
リレーションもしていて、user_idに紐ずく名前を表示させたいのですが、その方法が分かりません。
分かる方居ましたらお願い致します。
画面
DB
コード
php
@extends('layouts.app') @section('content') <!DOCTYPE html> <html lang="ja"> <head> <meta charset="UTF-8"> <link rel="stylesheet" href="public/css/content.css"> </head> <body> <div class="container-fluid"> <div class="row"> <div class="col no-gutters"> <img class="img-fluid" src="iStock-1163221036.jpg"> </div> </div> </div> <div class="container"> <div class="row justify-content-center"> <div class="col-12"> <div class="card-body"> @if (session('status')) <div class="alert alert-success" role="alert"> {{ session('status') }} </div> @endif </div> </div> <div class="card" style="width: 35rem;"> <div class="card text-center"> <div class="p-3"> @foreach($contents as $content) <h5 class="card-title"> {{ optional(Auth::user())->name }}</h5> <div class="card-body"> <p class="card-text">店名</p> <div class="form-group"> <textarea class="form-control" name="shop" rows="5"> {{ optional($content)->shop }} </textarea> </div> </div> ーー以下省略ーー
php
<?php namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Models\Sauna; use App\Models\User; use Illuminate\Support\Facades\DB; use Illuminate\Support\Facades\Auth; class SaunaController extends Controller { /** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $contents = DB::table('saunas') ->select('shop', 'hot', 'ice', 'chill', 'article', 'user_id') ->get(); return view('saunas.sauna', compact('contents')); } /** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create() { return view('saunas.create'); } /** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $sauna = new Sauna; $sauna->shop = $request->input('shop'); $sauna->hot = $request->input('hot'); $sauna->ice = $request->input('ice'); $sauna->chill = $request->input('chill'); $sauna->article = $request->input('article'); $sauna->user_id = $request->user()->id; $sauna->save(); return redirect('/home'); // dd($shop, $sauna); } /** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { // } /** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { // } /** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { // } /** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { // } }
php
<?php namespace App\Models; use Illuminate\Contracts\Auth\MustVerifyEmail; use Illuminate\Database\Eloquent\Factories\HasFactory; use Illuminate\Foundation\Auth\User as Authenticatable; use Illuminate\Notifications\Notifiable; use Laravel\Sanctum\HasApiTokens; class User extends Authenticatable { use HasApiTokens, HasFactory, Notifiable; /** * The attributes that are mass assignable. * * @var array<int, string> */ public function saunas() { return $this->hasMany('App\Sauna'); } protected $fillable = [ 'name', 'sub_name', 'lastname', 'sub_lastname', 'tel', 'email', 'password', ]; /** * The attributes that should be hidden for serialization. * * @var array<int, string> */ protected $hidden = [ 'password', 'remember_token', ]; /** * The attributes that should be cast. * * @var array<string, string> */ protected $casts = [ 'email_verified_at' => 'datetime', ]; }
php
<?php namespace App\Models; use Illuminate\Database\Eloquent\Factories\HasFactory; use Illuminate\Database\Eloquent\Model; class Sauna extends Model { public function user() { return $this->belongsTo('App\User'); } }
まだ回答がついていません
会員登録して回答してみよう