codeigniter cannot return several values instead of the whole row(from model to controller)

Question

I use codeigniter and I want to return from model to controller the following variables only $a, $b, $c, $d instead of the whole row but I am not sure if I wrote the code correctly. Could you please have a look at it.

if ($query->num_rows() == 1){

            $row= $query->row_array(); 
            $a = $row['a'];
            $b= $row['b'];
            $c= $row['c'];
            $d= $row['d'];            

    return $query->result(); // return $row[]; ???

}

MH2K9 · Accepted Answer · 2014-08-10 15:47:22Z

1

Try something like below

$row = $query->row();
return array('a' => $row->a, 'b' => $row->b, 'c' => $row->c, 'd' => $row->d);
//$row->a, here a is column name of DB table

answered Aug 10, 2014 at 15:47

MH2K9

12.1k7 gold badges34 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

codeigniter cannot return several values instead of the whole row(from model to controller)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related