MySqli query to multidimensional array

Question

I am trying to convert the results from a MySQLi select to a multidimensional array but am not getting the desired result. This is the data returned from the SELECT statement:

+----+------------+
| id | value      |
+----+------------+
| 2  | Red        |
| 2  | Blue       |
| 1  | Green      |
| 1  | Yellow     |
| 1  | Orange     |
| 3  | Teal       |
+----+------------+

There can be multiple values with the same id. My fetch statement looks like this:

while ($stmt->fetch()) {
    $colors[] = array($value);
}

The result looks like this:

Array
(
    [0] => Array
    (
        [0] => Red
    )
    [1] => Array
    (
        [0] => Blue
    )
    [2] => Array
    (
        [0] => Green
    )
    [3] => Array
    (
        [0] => Yellow
    )
    [4] => Array
    (
        [0] => Orange
    )
    [5] => Array
    (
        [0] => Teal
    )
)

However, want I really want is the array to look like this:

Array
(
    [0] => Array
    (
        [0] => Red
        [1] => Blue
    )
    [1] => Array
    (
        [0] => Green
        [1] => Yellow
        [2] => Orange
    )
    [2] => Array
    (
        [0] => Teal
    )
)

Any help would be appreciated!

Please, provide full select query. And fix your while loop.

sectus
– sectus

2014-10-10 04:38:27 +00:00
Commented Oct 10, 2014 at 4:38 — sectus
– sectus, Commented Oct 10, 2014 at 4:38

Kevin · Accepted Answer · 2014-10-10 04:39:30Z

2

Alternatively, you could use the id to group them inside the loop. Example:

$stmt->bind_result($id, $value);
while ($stmt->fetch()) {
    $colors[$id][] = $value;
}

// $colors = array_values($colors); // optional, if you want to reindex the keys

answered Oct 10, 2014 at 4:39

Kevin

41.9k12 gold badges57 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

MySqli query to multidimensional array

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