Active records for beginners...

#1
[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...

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

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

#3
[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;

#4
[eluser]thesocialhacker[/eluser]
thanks cahva!


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.