记录小于15分钟的活动记录 [英] Active record where record is less than 15 minutes old

问题描述

我使用Codeingiter的活动记录，需要检查小于15分钟的条目。

I am using Codeingiter's active record and need to check for entries that are less than 15 minutes old.

我已经尝试过以下，我认为会工作。

I have tried the following, which I thought would work.

$this->EE->db->select('entry_id')
             ->from('exp_channel_titles')
             ->where('status', $status)
             ->where('channel_id', $channel)
             ->where(FROM_UNIXTIME('entry_date') >= DATE_SUB(CURDATE(), INTERVAL 15 MINUTE))
             ->order_by('entry_date', 'desc'); 

有没有人知道是否可以这样做？

Does anyone know if its possible to do this?

我希望这会在where子句中执行。

I had hoped this would do work in a where clause"

FROM_UNIXTIME('entry_date') >= DATE_SUB(CURDATE(), INTERVAL 15 MINUTE)

推荐答案

a href =https://ellislab.com/codeigniter/user-guide/database/active_record.html =nofollow> https://ellislab.com/codeigniter/user-guide/database/active_record.html ：

From https://ellislab.com/codeigniter/user-guide/database/active_record.html:

$ this-> db-> where（）接受一个可选的第三个参数如果你设置
到FALSE，CodeIgniter不会尝试保护您的字段或表
名称与反引号。

$this->db->where() accepts an optional third parameter. If you set it to FALSE, CodeIgniter will not try to protect your field or table names with backticks.

$ this-> db-> where（'MATCH AGAINST（value）'，NULL，FALSE）;

$this->db->where('MATCH (field) AGAINST ("value")', NULL, FALSE);

所以你应该能够传递一个字符串：

So you should be able to pass a string like:

 ->where('FROM_UNIXTIME(`entry_date`) >= DATE_SUB(CURDATE(), INTERVAL 15 MINUTE)', NULL, FALSE)

这篇关于记录小于15分钟的活动记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！