/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

96 votes170 views5 answers
Append in php
PHP
2 votes102 views1 answer
Regex for email php
PHP
1 vote125 views3 answers
Print query statement in laravel
PHP
0 vote107 views2 answers
Php check if user exists in database
PHP
0 vote110 views2 answers
Php loop backwards through array
PHP
0 vote173 views1 answer
Check multiple roles with Blade directive @can?
PHP
1 vote142 views1 answer
Php foreach if last item
PHP
0 vote134 views6 answers
Socialite laravel 7
PHP Laravel
0 vote136 views1 answer
Php list *files
PHP
0 vote113 views1 answer
Laravel datatable columnDefs
PHP Laravel