我正在尝试执行一个查询,该查询通过以下查询使用相同的外键联接多个表,但返回false。$question_id = 11406;$query = $db->prepare("SELECT q.question_attempts_permitted, q.question_range, a.answer_text, r.attempt_count FROM checkup_questions q, checkup_answers a, user_responses r WHERE a.question_id=:question_id AND q.question_id=:question_id AND r.question_id=:question_id");$query->bindValue(':question_id', $question_id, PDO::PARAM_INT);$query->execute();但是,如果我直接注入question_id,则查询将返回所需的结果。$query = $db->prepare("SELECT q.question_attempts_permitted, q.question_range, a.answer_text, r.attempt_count FROM checkup_questions q, checkup_answers a, user_responses r WHERE a.question_id=11406 AND q.question_id=11406 AND r.question_id=11406");$query->execute();bindValue接口是否存在某些限制,导致第一个查询失败而第二个查询按预期返回?
1 回答
- 1 回答
- 0 关注
- 148 浏览
添加回答
举报
0/150
提交
取消