drza10046 2016-12-09 17:18
浏览 14

PHP查询语句3表加入

I am quite stuck with one query statement.

I have the current query:

$user_id = $_SESSION["user_id"];

$stm = $db->prepare("SELECT votes.hasVoted
FROM votes 
INNER JOIN posts
    ON posts.post_id = votes.post_id 
INNER JOIN users
    ON users.users_id = votes.user_id 
    WHERE users.user_id = :user_id;");
$stm->bindParam(':user_id', $user_id);
$stm->execute();
$votes = $stm->fetchAll();

It is not working.

I have 3 tables. [Votes, Posts, Users]. I want to retrieve 'hasVoted' value from Votes table according to the session variable of the logged in user.

Votes Table:

https://i.stack.imgur.com/ZsHZc.png

Posts Table:

https://i.stack.imgur.com/piLPu.png

Thanks in advance.

What I need help with: In my code I want to check if a logged in user is has voted on a specific post, if yes then the button will turn unclickable.

I have 3 connected Tables.

Votes Table has:
vote_id [PK]
user_id [FK]
post_id [FK]

Posts Table has:
post_id [PK]
user_id [FK]

Users Table has:
user_id [PK]

I want to interconnect them with Votes so I can access post_id and user_id from Votes

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 2020长安杯与连接网探
    • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么
    • ¥15 banner广告展示设置多少时间不怎么会消耗用户价值
    • ¥16 mybatis的代理对象无法通过@Autowired装填
    • ¥15 可见光定位matlab仿真
    • ¥15 arduino 四自由度机械臂
    • ¥15 wordpress 产品图片 GIF 没法显示
    • ¥15 求三国群英传pl国战时间的修改方法
    • ¥15 matlab代码代写,需写出详细代码,代价私
    • ¥15 ROS系统搭建请教(跨境电商用途)