dongqiang4986 2017-01-14 23:34
浏览 10

Laravel显示特定人员的消息

I've made this project using the messages panel, and I want to display the message for a specific person. My relations:

In user:
    public function Message()
    {
        return $this->belongsToMany('App\Message');
    }
In message:
    public function user()
    {
        return $this->belongsTo('App\User');
    }
And in my controller its look like:
    public function wiadomosci()
    {
        $menuClasses = ['', '', '', 'active', ''];
        $messages = Message::where('to_id','=', Auth::user()->id);
        return view('panel.wiadomosci', compact('menuClasses'))->with('messages', $messages);
    }

When I add where in $message it does not display anything to me, but when I delete it, it shows me all of the messages not assigned to that user.

@@Everything is fine now, problem solved. But I have a new problem: I would like to display the user name who send message(teacher_name) in the view, but I can only display an Id. controller:

public function wiadomosci()
{
    $menuClasses = ['', '', '', 'active', ''];
    $messages = Message::where('to_id','=', Auth::user()->id)
        ->join('teachers', 'messages.from_id', '=','teachers.id')
    ->get();
    return view('panel.wiadomosci', compact('menuClasses'))->with('messages', $messages);
}  

and in view :

@foreach($messages as $message)
            Od:{{$message->teachers_name}}
            </br>
            Tytuł:{{$message->title}}
            </br>
            opis:{{$message->contents}}
            </br>
        @endforeach

In mysql query would look like this :

SELECT teachers.name FROM messages JOIN teachers ON messages.from_id=teachers.id
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 matlab中使用gurobi时报错
    • ¥15 WPF 大屏看板表格背景图片设置
    • ¥15 这个主板怎么能扩出一两个sata口
    • ¥15 不是,这到底错哪儿了😭
    • ¥15 2020长安杯与连接网探
    • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么
    • ¥15 banner广告展示设置多少时间不怎么会消耗用户价值
    • ¥16 mybatis的代理对象无法通过@Autowired装填
    • ¥15 可见光定位matlab仿真
    • ¥15 arduino 四自由度机械臂