CodeIgniter Forums

Full Version: Active records for beginners...
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]thesocialhacker[/eluser]
Hello all,


Sorry to bother the forums, but I'm having a bit of a tricky time with the active record and "Objects" it returns... Currently i'd like to retrieve a single records, so i
Code:
function getmy ($id) {
         $q = $this->db->get_where('socialhubspot', array('company_id' => $id));
         if ($q->num_rows() > 0) {
             $data=$q->row(0);
             return $data;
         }

in my controller i
Code:
$data['row']=$this->backend->getmy($my_id);
      $this->load->view('frontend',$data);

and in my view i
Code:
<?php  $mydata = $row[0]; ?>

My god, i just know that can't be a proper way to go about this...

El Forum

[eluser]jdav3579[/eluser]
<?php $mydata = $row[0]; ?>

Think $row is now an object not an array!
do <ppre> print_r($row)</pre>

El Forum

[eluser]cahva[/eluser]
You can safely shorten your model method to this:
Code:
function getmy ($id)
{
    return $this->db->get_where('socialhubspot', array('company_id' => $id))->row();
}

row() method always returns only one row so you dont have to use "$q->row(0)".

now in the controller:
Code:
$data['row']=$this->backend->getmy($my_id);
$this->load->view('frontend',$data);

In view:
Code:
&lt;?php echo $row->somefield ?&gt;

El Forum

[eluser]thesocialhacker[/eluser]
thanks cahva!