[eluser]barun the michael[/eluser]
Hi
I am using codeigniter version 1.6.3 and my model name is myart_model and writing class like this class Myart_model extends Model {
function Myart_model()
{
parent::Model();
}
function get_MyartData()
{
$sql = "SELECT * FROM users ";
$query = $this->db->query($sql);
//echo $query->num_rows();
//echo $str = $this->db->last_query();
if ($query->num_rows() > 0)
{
$result = array();
foreach ($query->result_array() as $row)
{
array_push($result,$row);
}
$query->free_result();
return $result;
}
else
return false;
}
}
This is my model code and its name is myart_mode.php
Here is my controller code
class Myart extends Controller
{
var $error_string = "";
function Myart()
{
parent::Controller();
//$this->freakauth_light->check();
}
function index()
{
$this->load->model('myart_model');
$data['myart'] = array();
$data['error_string'] = $this->error_string;
$data['myart'] = $this->myart_model->get_MyartData();
//$this->assetlibpro->add_css('css/backend.css');
$this->output->enable_profiler(FALSE);
//$header['title'] = 'Welcome to Myart4Home';
//$this->load->view('header_view',$header);
$this->load->view('myart_view', $data);
//$this->load->view('footer_view');
}