public function list_items($limit = null, $offset = null, $col = 'start_date', $order = 'desc', $just_count = FALSE) { $this->db->select('events.id, events.name, start_date, end_date, events.published', FALSE); $data = parent::list_items($limit, $offset, $col, $order, $just_count); if (!$just_count) { foreach ($data as $key => $val) { $data[$key]['start_date'] = date_formatter($val['start_date'], 'm/d/Y g:ia'); $data[$key]['end_date'] = date_formatter($val['start_date'], 'm/d/Y g:ia'); } } return $data; }
public function list_items($limit = null, $offset = null, $col = 'name', $order = 'asc', $just_count = FALSE) { $this->db->select('news.id, news.title, news.publish_date, news.published', FALSE); $data = parent::list_items($limit, $offset, $col, $order); if (!$just_count) { foreach ($data as $key => $val) { // format with PHP instead of MySQL so that ordering will still work with MySQL if (!empty($val['publish_date'])) { $data[$key]['publish_date'] = date_formatter($val['publish_date'], 'm/d/Y h:ia'); } } } return $data; }