php - 如何将诸如 "now() -interval ' 2 minutes'"之类的内容插入 PHP PDO 查询？

Question

我有这样的查询:(在 Postgresql 8.4 上，PHP-fpm 5.3.10 (fpm-fcgi))

select * from users where now() - interval '2 minutes' < seenlast ORDER BY seenlast;

我想使用 PHP/PDO 查询，所以:

$mymin=5; //this is a variable can be changed by $_GET
$query = $db_conn->prepare("select * from users where now() - interval ':myminute minutes' < seenlast ORDER BY seenlast"); 
$query->bindParm(":myminute",$mymin)
$query->execute;

这行不通，我找不到以正确方式传递 session 记录 ($mymin) 的方法。如果我硬编码时间数据一切正常，那么代码的其他部分必须正确。

我也试过:

$temp=$mymin." minutes";
$query = $db_conn->prepare("select * from users where now() - interval :myminute < seenlast ORDER BY seenlast"); 
$query->bindParm(":myminute",$temp)

I already saw this, didn't help

Answer 1

间隔可以乘以数字。因此，一种方法是准备语句 interval '1 minute' * :myminutes，将“myminutes”参数作为简单整数传递。