/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

35 votes248 views6 answers
Php current time
PHP
5 votes281 views1 answer
Limit 1 1 in laravel query
PHP Laravel
3 votes248 views2 answers
Valdidate laravel if falid
PHP
0 vote311 views1 answer
Wp table with hostname setup
PHP Wordpress
1 vote269 views1 answer
Php remove class attribute
PHP
-1 vote341 views1 answer
Validate rule if row exist laravel
PHP Laravel
1 vote242 views1 answer
Laravel Validation check array size min and max
PHP
0 vote330 views1 answer
Bagisto package generator
PHP
1 vote223 views1 answer
How login with phone in laravel
PHP
1 vote245 views1 answer
Publish config laravel
PHP