php - Wrong date format codeigniter -

php - Wrong date format codeigniter -

when date database shows 2014-09-27 05:06:14.

i should show date 27-09-2014 05:06:14

in config folder have set default time zone to

date_default_timezone_set('australia/queensland');

in model or controller there away alter date part after.

model

<?php if ( ! defined('basepath')) exit('no direct script access allowed'); class users_model extends ci_model { public function getusers() { $this->db->select('user_id'); $this->db->select('username'); $this->db->select('date_added'); $this->db->select('status'); $this->db->from('user'); $this->db->limit(20); $this->db->order_by('username', 'asc'); $query_user = $this->db->get(); if ($query_user->num_rows) { homecoming $query_user->result_array(); homecoming true; } else { homecoming false; } } }

controller function

<?php if ( ! defined('basepath')) exit('no direct script access allowed'); class users extends mx_controller { public function __construct() { parent::__construct(); $this->lang->load('admin/user/users', 'english'); $this->load->model('admin/user/users_model'); if ($this->session->userdata('islogged')) { homecoming true; } else { redirect('admin'); } } public function index() { $this->document->settitle($this->lang->line('heading_title')); $this->getlist(); } private function getlist() { $data['heading_title'] = $this->lang->line('heading_title'); // breadstuff crumbs $data['breadcrumbs'] = array(); $data['breadcrumbs'][] = array( 'text' => '<i class="fa fa-home"></i>' .' '. $this->lang->line('text_home'), 'href' => site_url('admin/dashboard') ); $data['breadcrumbs'][] = array( 'text' => $this->lang->line('heading_title'), 'href' => site_url('admin/users') ); // db results $data['users'] = array(); $results = $this->users_model->getusers(); foreach ($results $result) { $data['users'][] = array( 'user_id' => $result['user_id'], 'username' => $result['username'], 'date_added' => $result['date_added'], 'status' => ($result['status'] ? $this->lang->line('text_enabled') : $this->lang->line('text_disabled')), 'edit' => site_url('admin/users/edit/' . $result['user_id']), 'delete' => site_url('admin/users/delete/' . $result['user_id']) ); } // set info $data['column_username'] =$this->lang->line('column_username'); $data['column_status'] =$this->lang->line('column_status'); $data['column_date_added'] =$this->lang->line('column_date_added'); $data['column_action'] =$this->lang->line('column_action'); if (trim($this->input->post('selected'))) { $data['selected'] = (array)$this->input->post('selected'); } else { $data['selected'] = array(); } homecoming $this->load->view('user/users', $data); } }

try this:

'date_added' => date('d-m-y h:i:s', strtotime($result['date_added'])),

php codeigniter