Welcome Guest, Not a member yet? Register   Sign In
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!




Theme © iAndrew 2016 - Forum software by © MyBB