Retrieve single data from model - controller - view

[eluser]nOsCiRe[/eluser]
Code in Model
<?php
Class user extends CI_MODEL{

function login($username, $password)
{
$this -> db -> select('username,password');
$this -> db -> from('ad_users');
$this -> db -> where('username = '."'".$username."'");
$this -> db -> where('password = '."'".$password."'");
$this -> db -> limit(1);

$query = $this -> db -> get();

if($query -> num_rows() == 1)
{
return $query -> result();
}
else
{
return false;
}
}
function userdetails($username)
{
$this->load->database();
$query = $this->db->get_where('ad_users', array('username' => $username));
return $query->row_array();
}


}
?>

Code in Controller

<?php if(!defined('BASEPATH')) exit('No direct script access allowed');
session_start();
Class Home extends CI_Controller {

function _construct()
{
parent:: _construct();
}
function index()
{
if($this->session->userdata('logged_in'))
{
$session_data = $this->session->userdata('logged_in');
$data['username']= $session_data['username'];
$this->load->view('home_page',$data);
}
else
{
redirect('','refresh');
}
}
function userprofile($username='')
{
$username = $this->input->post('username');
$this->load->model('user');
$query = $this->user->userdetails($username);
$data['username']['value'] = $query['username'];
$data['firstname']['value'] = $query['first_name'];
$this->load->view('userprofile_page',$data);
}


function logout()
{
$this->session->unset_userdata('logged_in');
session_destroy();
redirect('home','refresh');
}
}
?>

No data retrieve in views it only says "array"
Please help me on this thanks in advance

[eluser]CroNiX[/eluser]
Hi, a few things.
1) CI_MODEL should be CI_Model
2) session_start(); is doing nothing. CI Sessions are initiated when you load it (in autoload?)
3) If you are only returning one row, use

Code:

$query->row()

instead of

Code:

$query -> result();

result() will ALWAYS return an array of objects, even if there is only 1 row in the result.

[eluser]nOsCiRe[/eluser]
thanks cronix