主页 / 问题 / 1070221
Accepted
Aslero
Asked:2020-01-15 20:48:49 +0000 UTC2020-01-15 20:48:49 +0000 UTC

输出匹配 Laravel + MySql

  • 772

如何显示用户 -user_i = 1 的匹配项。您需要显示用户 1 喜欢的用户和喜欢该用户的用户

在此处输入图像描述

比如user 12匹配条件，但是不知道怎么显示

$users = DB::table('likes')
            ->leftJoin('users','users.id','=','likes.like_user')
            ->leftJoin('user_attributes','user_attributes.user_id','=','likes.like_user')
            ->select('user_attributes.fullname','user_attributes.avatar','user_attributes.country','user_attributes.city','user_attributes.age',
                'users.name','users.id','likes.created_at')
            ->where('likes.like_user','=', 'likes.user_id')
            ->where('likes.user_id','=', Auth::user()->id)
            ->paginate(15);
mysql

3 个回答

  1. Best Answer
    SELECT t1.user_id 
FROM likes t1
JOIN likes t2 ON t1.user_id = t2.like_user 
             AND t2.user_id = 1
             AND t1.like_user = 1

    如果我正确理解语法，那么

    $users = DB::table(DB:raw('likes t1'))
       ->join(DB:raw('likes t2'), 't1.user_id', '=', 't2.like_user ')
       ->where('t2.user_id', '=', '1')
       ->where(' t1.like_user', '=', '1')
    • 1 
  2. SELECT
  l1.*
FROM
  likes l1
  JOIN likes l2 ON (l1.like_user = l2.user_id)
WHERE
  l1.user_id = 1 OR
  l1.like_user = 1
    • 0

  3. 工作代码

    $users = DB::table('likes AS t1')
            ->join('likes AS t2', 't1.user_id', '=', 't2.like_user')
            ->leftJoin('users','users.id','=','t1.user_id')
            ->leftJoin('user_attributes','user_attributes.user_id','=','t1.user_id')
            ->select('user_attributes.fullname','user_attributes.avatar','user_attributes.country','user_attributes.city','user_attributes.age',
                'users.name','users.id','t1.created_at')
            ->where('t2.user_id', '=', Auth::user()->id)
            ->where('t1.like_user', '=', Auth::user()->id)->distinct('t1.user_id')->get();
    • 0

相关问题