Multidimensional Array advice from a newbie
| From: | grahama at siren dot cc | Date: | Sat, 12 Jun 2004 23:18:17 +0000 |
| Subject: | Multidimensional Array advice from a newbie | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-188164@lists.php.net to get a copy of this message | ||
Hi :)
I am creating an XML file out of a mysql query with nested arrays.
Currently I can get 1 element and 1 child with a properly formatted XML file with the below script .
My question is: How do I add 3 to 4 more child elements to the below 'playlist' array ?
Currently ,I have one parent 'Artist' and one child 'english' ...
I need to add more child elements to the 'Artist' array like urlPath, spanish, biography, etc
My addled thoughts...
So, would the multidimensional array be like:
$playlist[ [$artist [ ] ] [$media[ ] ] [$mediaElement] ] ?for the 'trackName' child: $playlist [ "Artist 1" ] [ "Track 1" ] [ "trackName" ] or for 'urlPath' child : $playlist [ "Artist 1" ] [ "Track 1" ] [ "urlPath" ] Do I have to add another dimension to the 'playlist' array? Do I need another foreach loop ? Is there an easier more efficient way to do this? Be nice to spell out the schema in some way in the script...in case you need to add more levels...like a 'subCategory' I am a bit new to this so any help would be greatly appretiated .... head is spinning a bit <?php @ $db = mysql_connect('127.0.0.1','name','pass'); if (!$db) { echo 'Error:Could Not Connect'; exit; } mysql_select_db('univision'); $sql = 'SELECT artist.artist_name, media.english, media.path '; $sql .= 'FROM media, artist '; $sql .= 'WHERE artist.artist_id = media.artist_id LIMIT 0, 30 '; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $playlist[$row['artist_name']] [] = $row['english']; //would like to add more children here... } $xml = "<sirenreels>\n"; foreach ($playlist as $artist => $media) { $num_media = count($media); $xml .= "<artist>\n"; $xml .= "\t<meta>\n"; $xml .= "\t\t<title>".$artist."</title>\n"; $xml .= "\t</meta>\n"; $xml .= "\t<content>\n"; foreach ($media as $mediaVal) { $xml .= "\t\t<media>\n"; $xml .= "\t\t\t<english_name>".$mediaVal."</english_name>\n"; ///add more children ///add more children $xml .= "\t\t</media>\n"; } $xml .= "\t</content>\n"; $xml .= "</artist>\n"; } $xml .= "</sirenreels>\n"; print $xml