/PHP/CodeIgniter/Codeigniter 3 Get future date recocords - upcoming records from database

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();
    }

Similar codes

3 votes247 views1 answer
Codeigniter check affected rows
PHP CodeIgniter
7 votes241 views5 answers
Codeigniter count rows
PHP CodeIgniter
2 votes124 views1 answer
Codeigniter row count returns 1 always
PHP CodeIgniter
0 vote144 views1 answer
How to write orderby in join query with where clause in codeigniter
PHP CodeIgniter
0 vote151 views1 answer
Codeigniter check view file exists
PHP CodeIgniter
3 votes247 views3 answers
How to get last id in database codeigniter 4
PHP CodeIgniter
0 vote194 views1 answer
Upload image with watermark in codeigniter
PHP CodeIgniter
0 vote161 views1 answer
Codeigniter 4 query builder get inserted id
PHP CodeIgniter
0 vote159 views1 answer
Codeigniter update query return value
PHP CodeIgniter
0 vote156 views1 answer
Gd2 image resizing library in codeigniter
PHP CodeIgniter