首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >如何获得我在mysqli上关注的人?

如何获得我在mysqli上关注的人?
EN

Stack Overflow用户
提问于 2018-07-01 23:36:00
回答 1查看 42关注 0票数 0

因此,我有一个名为follow_sys的表,其中包含列idfollowerfollowing,我想要显示我关注的人,但不要将其作为待处理的好友请求返回。我尝试了自连接,但它不起作用

代码语言:javascript
复制
$sqlFollowing = "SELECT * from follows_syds t1, follows_syds t2
    where
    t1.follower = ?
    and
    t1.following != ?
    and
    t2.follower != ?
    AND
    t2.following != ?";

$Following       = $conn -> prepare($sqlFollowing);
$Following       -> bind_param('ssss',$metUser,$metUser,$metUser,$metUser);
$Following       -> execute();
$FollowingGET    = $Following -> get_result();
$FollowingRows   = $FollowingGET -> num_rows;

我试过这样的方法,但结果仍然不准确

代码语言:javascript
复制
$sqlFollowing      = "SELECT * from follows_syds t1
                                 INNER join follows_syds t2 on
                                 t1.follower = t2.following
                                 where
                                 t2.follower = ?
                                 and
                                 t1.following = ?
                                 group by t2.id";
$Following         = $conn -> prepare($sqlFollowing);
$Following        -> bind_param('ss',$getUser,$getUser);
$Following        -> execute();
$FollowingGET      = $Following -> get_result();
$FollowingRows     = $FollowingGET -> num_rows;

while($b = $FollowingGET -> fetch_assoc()){
$ve = $b['following'];

}
  $sqlowing      = "SELECT * from follows_syds t1
                    INNER join follows_syds t2 on
                    t1.follower = t1.follower
                    where
                    t2.follower = ?
                    and
                    t2.following != ?
                    AND
                    t1.follower != ?
                    and
                    t1.following != ?
                    group by t2.id";
  $owing         = $conn -> prepare($sqlowing);
  $owing        -> bind_param('ssss',$getUser,$ve,$ve,$getUser);
  $owing        -> execute();
  $owingGET      = $owing -> get_result();
  $owingRows     = $owingGET -> num_rows;
  while($a = $owingGET -> fetch_assoc()){
      print_r($a );
      echo "</br>";
}
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/51124680

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档