Simple formatting of multidimensional array from mysql in php

Question

I have an array of results from mysql relational tables. It looks similar to this:

array(10) {
  [0]=>
  object(stdClass)#14 (35) {
    ["eventID"]=>
    string(1) "1"
    ["eventTitle"]=>
    string(7) "EVENT 1"
    ["artistID"]=>
    string(1) "1"
    ["artistName"]=>
    string(8) "ARTIST 1"
    ["artistDescription"]=>
    string(20) "ARTIST 1 description"
    // etc.
  }
  [1]=>
  object(stdClass)#15 (35) {
    ["eventID"]=>
    string(1) "1"
    ["eventTitle"]=>
    string(7) "EVENT 1"
    ["artistID"]=>
    string(1) "2"
    ["artistName"]=>
    string(8) "ARTIST 2"
    ["artistDescription"]=>
    string(20) "ARTIST 2 description"
    // etc.
  }
  [2]=>
  object(stdClass)#16 (35) {
    ["eventID"]=>
    string(1) "1"
    ["eventTitle"]=>
    string(7) "EVENT 1"
    ["artistID"]=>
    string(1) "3"
    ["artistName"]=>
    string(8) "ARTIST 3"
    ["artistDescription"]=>
    string(20) "ARTIST 3 description"
    // etc.
  }
  [3]=>
  object(stdClass)#17 (35) {
    ["eventID"]=>
    string(1) "2"
    ["eventTitle"]=>
    string(7) "EVENT 2"
    ["artistID"]=>
    string(1) "5"
    ["artistName"]=>
    string(8) "ARTIST 5"
    ["artistDescription"]=>
    string(20) "ARTIST 5 description"
    // etc.
  }
  [4]=>
  object(stdClass)#17 (35) {
    ["eventID"]=>
    string(1) "2"
    ["eventTitle"]=>
    string(7) "EVENT 2"
    ["artistID"]=>
    string(1) "7"
    ["artistName"]=>
    string(8) "ARTIST 7"
    ["artistDescription"]=>
    string(20) "ARTIST 7 description"
    // etc.
  }
//etc.
}

I want to make a multidimensional array which would look like this one:

array(2) {
  [1]=>
  array(9) {
    ["eventID"]=>
    string(1) "1"
    ["eventTitle"]=>
    string(7) "EVENT 1"
    ["artists"]=>
    array(3) {
      [1]=>
      array(2) {
        ["artistName"]=>
        string(8) "ARTIST 1"
        ["artistDescription"]=>
        string(20) "ARTIST 1 description"
      }
      [2]=>
      array(2) {
        ["artistName"]=>
        string(8) "ARTIST 2"
        ["artistDescription"]=>
        string(20) "ARTIST 2 description"
      }
      [2]=>
      array(2) {
        ["artistName"]=>
        string(8) "ARTIST 3"
        ["artistDescription"]=>
        string(20) "ARTIST 3 description"
      }
    }
  }
  [2]=>
  array(9) {
    ["eventID"]=>
    string(1) "2"
    ["eventTitle"]=>
    string(7) "EVENT 2"
    ["artists"]=>
    array(3) {
      [1]=>
      array(2) {
        ["artistName"]=>
        string(8) "ARTIST 5"
        ["artistDescription"]=>
        string(20) "ARTIST 5 description"
      }
      [2]=>
      array(2) {
        ["artistName"]=>
        string(8) "ARTIST 2"
        ["artistDescription"]=>
        string(20) "ARTIST 7 description"
      }
      [2]=>
      array(2) {
        ["artistName"]=>
        string(8) "ARTIST 3"
        ["artistDescription"]=>
        string(20) "ARTIST 7 description"
      }
    }
  }
}

I started to create an array in a FOR loop but I was stuck with creating this artists[] array and I'm totally confused last 30 mins =)

Thank you in advance for any help!

txyoji · Accepted Answer · 2009-10-11 00:29:50Z

3

<?php
$output = array();
foreach($resultset as $event)
{

   $eventId = $event['eventID'];
   $artistId = $event['artistID'];
   //Using the eventId as the index ensures the event is unique and easy to lookup in the array.
   $output[$eventId]['eventTitle'] = $event['eventTitle'];
   $output[$eventId]['eventID'] = $event['eventID'];
   //Using the 'artistID' as the index of artists ensures each artist is unique and easy to lookup.
   $output[$eventId]['artists'][$artistId]['artistID'] = $artistId;
   $output[$eventId]['artists'][$artistId]['artistName'] = $event['artistName'];
   $output[$eventId]]['artists'][$artistId]['artistDescription'] = $event['artistDescription'];
}
echo '<pre>' . print_r($output,true) . '</pre>';

answered Oct 11, 2009 at 0:29

txyoji

6,8881 gold badge48 silver badges47 bronze badges

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

1 Comment

errata Over a year ago

Many thanks! Exactly what I needed! The only thing I needed to change was $event['eventID'] to object syntax $event->eventID. Thanks for quick help ;-)

Collectives™ on Stack Overflow

Simple formatting of multidimensional array from mysql in php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related