Creating An Associative Multi Dimensional Array from loop in PHP

Question

How can I create an array like the following in PHP from a database result set using a loop:

Array
(
    [T] => Array
        (
            [0] => Array
                (
                    [id] => 1
                    [name] => Timer
                )

            [1] => Array
                (
                    [id] => 2
                    [name] => Tub
                )

        )

    [P] => Array
        (
            [0] => Array
                (
                    [id] => 3
                    [name] => Paper
                )

            [1] => Array
                (
                    [id] => 4
                    [name] => Puppy
                )

        )

)

You will notice that the array keys are a letter, which is taken from the 'name' value in the result set. The loop will be something like this:

while($result = $db->fetch($query) {

  $key = $result['name']{0};

  //  your answer  :-)

}

nickb · Accepted Answer · 2011-12-08 20:40:59Z

7

I think something like this should do it:

$sql = 'SELECT id, name FROM table';
$result = mysql_query( $sql);
$answer = array();
while( $row = mysql_fetch_assoc( $result))
{
    $answer[ strtoupper($row['name'][0]) ][] = $row;
}
mysql_free_result( $result);
var_dump( $answer);

OR, to be more specific (if your query is returning more columns than just id and name):

while( $row = mysql_fetch_assoc( $result))
{
    $answer[ strtoupper($row['name'][0]) ][] = array(
        'id' => $row['id'],
        'name' => $row['name']
    );
}

answered Dec 8, 2011 at 20:40

nickb

59.7k13 gold badges115 silver badges149 bronze badges

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

1 Comment

Billy Over a year ago

Ahh great, thanks! The part that makes this happen is the extra [] >> $array[$key][] = $result; rather than $array[$key] = $result;. Without that, the previous gets overwritten as we loop.

PseudoNinja · Accepted Answer · 2011-12-08 20:43:54Z

0

$indexArray = array(); // Array from Example
while($result = $db->fetch($query) {
    $key = $result['name']{0};
    if(!isset($indexArray[$key])) {
        $indexArray[$key] = array();
    }
    array_push($indexArray[$key], $result);
}

answered Dec 8, 2011 at 20:43

PseudoNinja

2,8661 gold badge29 silver badges37 bronze badges

Comments

connec · Accepted Answer · 2011-12-08 20:48:07Z

0

$results = array();
while($result = $db->fetch($query)) {
  $key = strtoupper($result['name'][0]);
  if(!isset($results[$key]))
    $results[$key] = array();
  $results[$key][] = $result;
}

answered Dec 8, 2011 at 20:48

connec

7,4713 gold badges26 silver badges27 bronze badges

Collectives™ on Stack Overflow

Creating An Associative Multi Dimensional Array from loop in PHP

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related