/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

7 votes130 views1 answer
Laravel db seed specific class
PHP
1 vote154 views3 answers
Make model factory and controller laravel
PHP Laravel
2 votes158 views2 answers
Laravel simplexmlelement xml add attribute
PHP Laravel
5 votes153 views3 answers
Php.ini location mac
PHP
0 vote172 views1 answer
Get taxonomy term id from slug - WordPress
PHP Wordpress
0 vote152 views4 answers
How to redirect to another page after login in laravel
PHP Laravel
0 vote156 views1 answer
Compile custom/plain css with mix in laravel
PHP Laravel
1 vote141 views1 answer
Php trait example
PHP
0 vote139 views1 answer
Artisan command on live server
PHP
0 vote144 views1 answer
How to save the variable from query in mysql with php
PHP