Comparing the usage of CodeIgniter's row_array() and result() methods [duplicate]

Question

I wonder if the following codes do the same thing?

if ($query->num_rows() == 1) {      
    $row = $query->row_array(); 
    $path = $row['path'];
    $photo = $row['photo'];
}

if ($query->num_rows() == 1) {           
    foreach ($query->result() as $row) {
        $path = $row->path;
        $photo = $row->photo;
    } 
}

I've been maintaining a large/old CodeIgniter application for more than 6 years and I can't think of one place in the entire codebase where I've actually needed num_rows(). In every possible scenario, there is a cleaner approach that doesn't need it. In your case, if you definitely need to unpack the two columns as two separate variables, then I'd probably recommend $row = $query->row_array(); [$path, $photo] = $row ?? [null, null]; It is easy to identify the row_array() return data as an array or null. — mickmackusa
– mickmackusa ♦, Commented Oct 17 at 4:27

Don Dickinson · Accepted Answer · 2014-08-10 12:07:59Z

2

Yes. One gets the result as an object the other an associative array. Same result.

answered Aug 10, 2014 at 12:07

Don Dickinson

6,2683 gold badges37 silver badges30 bronze badges

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

1 Answer 1