CakePHP删除超过5天的记录 - CakePHP delete records older than 5 days

CakePHP delete records older than 5 days

本文关键字：记录 5天删除 CakePHP | 更新日期: 2023-09-27

基本上，我想在CakePHP中做到这一点:

delete from myTable as mytable where datediff(now(), mytable.date) > 5

我不知道怎么用$this->Model->delete()函数来做?

您需要使用deleteAll:

$this->Model->deleteAll(array(
    'datediff(now(), Model.date) > 5'
)) ;

执行自定义查询的最简单方法是使用Model::query方法。这不是推荐的方法，但你似乎想要一个快速/肮脏的答案。

$this->MyModel->query("delete from myTable as mytable where datediff(now(), 
                        mytable.date) > 5");

如果使用此方法，请确保转义查询字符串以防止SQLi攻击。

建议道:

Use Model::deleteAll(mixed $conditions, $cascade = true, $callbacks = false)
$conditions = array('datediff(now(), Model.date) > 5');
$this->MyModel->deleteAll($conditions,false);

你应该这样做:

// In a controller or table method.
$time = 'Cake'I18n'Time::now();
$time->modify('-5 days');
$query = $this->Model->deleteAll(['Model.date <=' => $time->format('Y-m-d H:i:s')]);