PDO的绑定参数行为异常 [英] PDO misbehaving with bind parameters

问题描述

我有一个可以从绑定变量中受益的简单SQL查询，所以我这样写:

I have simple SQL query that could benefit from bind variables so I have written like this:

$stmt = $this->db->prepare("SELECT * FROM activities WHERE user_id=':user_id' AND date(start_time)=date(':on_specific_day')");
$stmt->bindParam(':user_id',$where['user_id']); 
$stmt->bindParam(':on_specific_day',$where['on_specific_day']); 

如您所见，有一个名为where的关联数组，用于存储我的where条件.当我执行此语句时，它不返回任何错误，但行数为零.相反，如果我放弃了使用绑定变量的梦想，那就这样做:

As you can see there is an associative array called where which is used to store my where conditions. When I execute this statement it doesn't return any errors but the row count is zero. If I instead discard my dream of using bind variables and do this:

$stmt = $this->db->prepare("SELECT * FROM activities WHERE user_id='{$where['user_id']}' AND date(start_time)=date('{$where['on_specific_day']}')");

查询运行得很好，并在我的测试用例中返回2个结果.有人可以帮我摆脱疯狂. :^)

The query runs just fine and returns 2 results in my test case. Can someone help me from slipping into madness. :^)

推荐答案

您无需在PDO parameters周围加上引号:

You don't need to enclose your PDO parameters with quote marks:

$stmt = $this->db->prepare("SELECT * FROM activities WHERE user_id=:user_id AND date(start_time)=date(:on_specific_day)

这篇关于PDO的绑定参数行为异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！