dougua9165 2019-04-05 21:28
浏览 172

如何使用Laravel显示具有匹配记录字段的用户? [重复]

This question already has an answer here:

Display the users with matching ID fields

staff details should only return when staffID(employer table) == id(staff table)

Below is my database schema

Staff('id' , 'username' , 'location');

Employer('id' , 'employerID','staffID' );

Below is what I have tried , however it is not return anything , i also have it returning to my blade file and a @foreach loop to get the data. I've tried have a model methods but no luck.

   $following =  DB::table('staff')
    ->select('username')
   ->join('employer' , 'employer.staffID', '=', 'staff.id')
    ->where('employer.employer_id' , '=', Auth::id())
    ->where('employer.staffID' ,'=', 'staff.id') 
    ->get(); 

below is how I am trying to get my querys results to display in my blade

 @foreach ($following as $userFound)

                        <p> {{ $userFound->username}}</p>                 

 @endforeach   
</div>
  • 写回答

1条回答 默认 最新

  • du13932014807 2019-04-05 22:05
    关注

    with raw SQL

    $query = "SELECT username 
              FROM employer JOIN staff ON employee.staffID = staff.id
              WHERE employerID = ?";
    $params = [Auth::id()];
    
    $following = \DB::select($query , $params);
    
    评论

报告相同问题?

悬赏问题

  • ¥15 MATLAB怎么通过柱坐标变换画开口是圆形的旋转抛物面?
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿