1#@!#!123s

��JFIF�� 1#@!#!123s

: / var / www / html / projects / cando / application / models /

Filename : Dashboard_model.php

back

<?php
defined('BASEPATH') or exit('No direct script access allowed');

class Dashboard_model extends CI_Model
{
    public function __construct()
    {
        parent::__construct();
        $this->load->database();
    }

    public function get_events()
    {
        $this->db->where('status', 1);
        $query = $this->db->get('tbl_event');
        return $query->result();
    }

    public function get_upcoming_events()
    {
        $this->db->where('event_startdatetime >', date('Y-m-d H:i:s'));
        $this->db->order_by('event_startdatetime', 'ASC');
        $this->db->where('status', 1);
        $query = $this->db->get('tbl_event');
        return $query->result();
    }
}