如何使Doctrine_Expression(doctrine 1.2)尝试获取最近7天 [英] how to make Doctrine_Expression ( doctrine 1.2 ) try to get last 7 days

问题描述

我尝试使用教义1.2进行此查询:

I try to make this query with doctrine 1.2:

 $q->where('date > ?', 
             new Doctrine_Expression('DATE_SUB(CURDATE() , INTERVAL 7 DAY)'));

但是它没有返回任何结果.

but it's not return me any results.

有什么主意吗?

谢谢

推荐答案

它不返回任何内容的原因是因为Doctrine对表达式进行了转义-生成的SQL是

The reason why it doesn't return anything is because Doctrine escapes the expression - the generated SQL is

WHERE (date > 'DATE_SUB(CURDATE(), INTERVAL 7 DAY)')

而不是

WHERE (l.action_time > DATE_SUB(CURDATE(), INTERVAL 7 DAY))

您可以强迫它像这样工作:

You could force it to work like this:

$date = new Doctrine_Expression('DATE_SUB(CURDATE() , INTERVAL 7 DAY)');
$q->where('date > ' . $date);

但这不是最安全的选择，因为输入无法转义，也不是很好的做法...

This isn't the safest option however, as the input doesn't get escaped and isn't good practice...

这篇关于如何使Doctrine_Expression(doctrine 1.2)尝试获取最近7天的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！