/PHP/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

0 vote156 views1 answer
Laravel resourece type
PHP Laravel
0 vote122 views1 answer
Php location same page
PHP
37 votes132 views4 answers
Foreign key in laravel migration
PHP Laravel
4 votes140 views1 answer
Disable register laravel
PHP Laravel
0 vote124 views1 answer
Convert text file to json php
PHP
0 vote220 views1 answer
Yii::app()->request->get yii1
PHP Yii
0 vote141 views10 answers
Event handler with worker laravel
PHP Laravel
18 votes126 views6 answers
Laravel routes
PHP
0 vote125 views1 answer
Add action hook
PHP
0 vote151 views2 answers
Laravel-check-if-related-model-exists
PHP Laravel