Codeigniter 3 Get future date recocords - upcoming records from database
public function getUpcomingevents($limit) {
$this->db->select('*');
$this->db->from('events');
$this->db->where('is_active',"1");
$this->db->where('date > DATE(now())');
$this->db->order_by('id', 'DESC');
$this->db->limit($limit);
$query = $this->db->get();
return $query->result();
}