Codeigniter: Produce Array instead of Object in Active Record

Question

I want Codeigniter produce array result in active record, just like mysql_fetch_array() does in standard PHP.

Let's just say, we have this table in our mysql database, called students.

+-----+------+
| id  | name |
+-----+------+
|  1  | Elto |
|  2  | John |
+------------+

This is the conditions.
I generate the query in separated way. It's Just like :

$this->db->select('id, name');
$this->db->order_by('name', 'asc');
$q = $this->db->get('students');
$r = $q->result();

$r will produce:

[0] (name => 'Elto')
[1] (name => 'John')

Instead of that, I want the query produce something like this:

[0][0] => 'Elto'
[1][0] => 'John'

I don't know if this can be done. If anyone wants to help this problem, I would be very grateful.

devpro · Accepted Answer · 2016-02-04 14:11:22Z

2

You just need to use result_array() instead of result():

$this->db->select('id, name');
$this->db->order_by('name', 'asc');
$q = $this->db->get('students');
$r = $q->result_array();

result() will return you rows in Object format.

result_array() will return you rows into array format.

Please explore CodeIgniter Generating Query Results

edited Feb 4, 2016 at 14:11

answered Feb 4, 2016 at 11:35

devpro

16.1k3 gold badges29 silver badges39 bronze badges

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

2 Comments

dkregen Over a year ago

Thank you for your response. This method works well, but does not produce what I wanted. result_array() will generate an associative array while indexed array is what I need. But it can be tricked with a php function: array_values(). But I do not know if there are any performance issues that may occur.

mickmackusa Over a year ago

How counter intuitive for this answer to not provide the desired result, yet has been accepted. How confusing for researchers.

Peter Black Moore · Accepted Answer · 2016-02-04 11:38:26Z

1

You can use

$r = $q->result_array();

or you can use

$r = $q->row_array();

To retrive only one item.

Check offical documentation for more information:

http://www.codeigniter.com/user_guide/database/results.html

Regards.

answered Feb 4, 2016 at 11:38

Peter Black Moore

925 bronze badges

Comments

TV-C-1-5 · Accepted Answer · 2023-05-16 22:57:11Z

0

Codeigniter 4:

$r = $q->getResultArray();

answered May 16, 2023 at 22:57

TV-C-1-5

7342 gold badges13 silver badges19 bronze badges

Comments

mickmackusa · Accepted Answer · 2025-07-17 10:41:45Z

To ensure that not only the first level contains indexed arrays, but also that each row contains indexed elements, apply a numeric alias to the name column in your SELECT statement and then use result_array() or getResultArray() (depending on your CI version).

Depending on your database driver, the alias quoting character may vary. Tested on my application running firebird, double quoting the numeric alias rendered properly.

return $this->db
    ->select(
        vsprintf(
            '%s %s, %s %s',
            $this->db->escape_identifiers(['id'，'0', 'name', '1'])
        ),
        false
    )
    ->order_by('name')
    ->get('students')
    ->result_array();

Will return an indexed array of single-element, indexed arrays.

[
    [0 => 1, 1 => 'Elto'],
    [0 => 2, 1 => 'John'],
]

Otherwise, you can iterate the row of the resultset and re-index them.

return array_map(
    'array_values', // or array_values(...)
    $this->db
        ->select('id, name')
        ->order_by('name')
        ->get('students')
        ->result_array()
);

Collectives™ on Stack Overflow

Codeigniter: Produce Array instead of Object in Active Record

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related