database access by code igniter

[eluser]Aishwarya.M.B[/eluser]
i've worked out on your code.....
i've edited the code.
just do the following changes...

ci/application/config/routes.php
$route['default_controller'] = "AccessDatabase";

system/application/config/database.php
$db['default']['database'] = "efo";

Controller:
AccessDatabase.php
<?php

class AccessDatabase extends Controller{

function AccessDatabase()

{

parent::Controller();

}



function index()

{

$this->load->model('AccessDatabase_model');



$data['result'] = $this->AccessDatabase_model->getData();

$data['page_title'] = "CI Hello World App!";

$this->load->view('AccessDatabase_view',$data);

}

}

?>



Model

AccessDatabase_model.php
<?php

class AccessDatabase_model extends Model {

function AccessDatabase_model()

{

parent::Model();

}

function getData()

{

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

if ($query->num_rows() < 0)

{

show_error('Database is empty!');

}

else{

return $query->result();

}

}



}

?&gt;


VIEW
AccessDatabase_view.php

&lt;html&gt;

&lt;head&gt;

&lt;title&gt;&lt;?=$page_title?&gt;&lt;/title&gt;

&lt;/head&gt;

&lt;body&gt;

&lt;?php foreach($result as $row):?&gt;



&lt;?=$row->a?&gt;





&lt;?=$row->b?&gt;

&lt;?=$row->c?&gt;





&lt;?php endforeach;?&gt;

&lt;/body&gt;

&lt;/html&gt;



this code is working....
try this.