如何在半小时后删除数据 - How to delete data after half an hour?

How to delete data after half an hour?

本文关键字：删除数据半小时 | 更新日期: 2023-12-15

我的代码如下：

function insert_delete()
{
    ...
    $hotel             = $hotel;
    $address        = $address;
    $created_date     = date('Y/m/d H:i:s');
    $data = array('hotel'     => $hotel,
                  'address'     => $address,
                  'created_date' => $created_date
                 );
    $this->db->insert('tb_hotel',$data);
    $query = "DELETE FROM tbl_hotel WHERE created_date='$created_date'";
    $this->db>query($query);
}

当调用insert_delete函数时，它将运行insert查询和delete查询。

插入数据时如何操作，是直接删除数据，但半小时后删除数据？

感谢

我希望你的意思不是希望删除在半小时后运行，所以我假设你希望删除整理任何超过30分钟的行。

public function insert_delete()
{
    ...
    $hotel        = $hotel;
    $address      = $address;
    $created_date = date('Y/m/d H:i:s');
    $data = array('hotel'        => $hotel,
                  'address'      => $address,
                  'created_date' => $created_date
                 );
    $this->db->insert('tb_hotel',$data);
    // delete old rows more than 30 minutes old
    $date = new DateTime($created_date);
    $date->sub(new DateInterval('PT30M'));
    $del_dt = $date->format('Y-m-d H:i:s');
    $query = "DELETE FROM tbl_hotel WHERE created_date < '$del_dt'";
    $this->db>query($query);
}