Multidimensional arrays

[eluser]Colin Williams[/eluser]
Absolutely, PvOostrom, that is expected. It is this array of rows that you must loop through and build your multidimensional array. Let me try to construct a very simple one for you:

We query a user table and join a user_attribute table. Our result looks like this:

Code:

$result = array(
  object ('uid' => '1', 'email' => '[email protected]', 'name' => 'nickname', 'value' => 'Pablo'),
  object ('uid' => '1', 'email' => '[email protected]', 'name' => 'birthdate', 'value' => '01/01/1980'),
);

Let's get a multidimensional array where each item contains uid, email, and an array of attributes:

Code:

$users = array();
foreach ($result as $row)
{
  if (!isset($users[$row->uid]))
  {
    $users[$row->uid] = array();
  }
  $users[$row->uid]['uid'] = $row->uid;
  $users[$row->uid]['email'] = $row->email;
  if (!isset($users[$row->uid]['attribute'])
  {
    $users[$row->uid]['attribute'] = array();
  }
  $users[$row->uid]['attribute'][$row->name] = $row->value;
}

By always updating the $users array with $users[$row->uid], we essentially create and maintain an array grouped by uid.

The result:

Code:

$users = array(
'1' => array(
  'uid' => '1',
  'email' => '[email protected]',
  'attribute' = array('nickname' => 'Pablo', 'birthdate' => '01/01/1980'),
));