Question : Codeigniter 3 Get future date recocords - upcoming records from database
Answered by : irfan-majeed
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(); }
Source : | Last Update : Mon, 18 Oct 21