Welcome Guest, Not a member yet? Register   Sign In
DATABASE CONNECTIVITY
#3

[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');

}


Messages In This Thread
DATABASE CONNECTIVITY - by El Forum - 01-16-2009, 08:41 AM
DATABASE CONNECTIVITY - by El Forum - 01-16-2009, 10:18 AM
DATABASE CONNECTIVITY - by El Forum - 01-17-2009, 12:14 AM
DATABASE CONNECTIVITY - by El Forum - 01-17-2009, 04:39 AM



Theme © iAndrew 2016 - Forum software by © MyBB