Question : insert current time using CodeIgniter
Answered by : manoj-kumar
$data = array( 'user_id' => $user_id, 'otp' => $otp
);
$this->db->set('create_at', 'NOW()', FALSE);
$this->db->insert('otp_expiry', $data);
//or 1 day expire
$this->db->set('create_at', 'NOW() + INTERVAL 1 DAY', FALSE);
$this->db->insert('otp_expiry', $data);
Source : | Last Update : Fri, 19 Mar 21