Return array of model objects instead of array of arrays in CodeIgniter 3

Question

I have a CodeIgniter model:

<?php
class Person_model extends CI_Model {
    public function __construct() {
        $this->load->database();
    }

    public function list_persons() {
        $query = $this->db->get('persons');
        return $query->result_array();
    }

    public function foobar() {
        return 'Custom function here';
    }
}
?>

The function list_persons() is quite self-explained. It fetches all results from persons database table.

Currently it returns results in a list of arrays, like this:

array(2) {
  [0] => array(3) {
    ["id"] => string(1) "1"
    ["first_name"] => string(6) "Test 1"
  }
  [1] => array(3) {
    ["id"] => string(1) "2"
    ["first_name"] => string(6) "Test 2"
  }
}

Is it possible to let the function list_persons() to return:

array(2) {
  [0] => Person_model {
    "id" => 1
    "first_name" => "Test 1"
  }
  [1] => Person_model {
    "id" => 2
    "first_name" => "Test 2"
  }
}

so that I can use the custom functions I wrote in the Person_model, such as:

foreach($this->person_model->list_persons() as $person) {
    echo $person->foobar();
}

Thanks in advance.

Rendy Eko Prastiyo · Accepted Answer · 2017-05-16 04:17:27Z

6

Update your list_person() method like this (use $query->result()):

public function list_persons() {
    $query = $this->db->get('persons');
    return $query->result('Person_model');
}

edited May 16, 2017 at 4:17

answered May 16, 2017 at 3:56

Rendy Eko Prastiyo

1,0987 silver badges16 bronze badges

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

4 Comments

Raptor Over a year ago

Nice. However, the class returned is a stdClass instead of a Person_model, which the foobar() cannot be called. Any advise?

Rendy Eko Prastiyo Over a year ago

I have updated the answer. Pass a string which represents the model class to the $query->result(), for example $query->result('Person_model') to convert it to your model class.

Raptor Over a year ago

Works perfectly. Thanks!

Dewald Els Over a year ago

This is awesome! I never knew about this! Thank you @RendyEkoPrastiyo

Collectives™ on Stack Overflow

Return array of model objects instead of array of arrays in CodeIgniter 3

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related