Is this what you need? (See below for inline suggestions).
[EMAIL PROTECTED] wrote:
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'];
Instead, try
$playlist[$row['artist_name']][] = array('english' => $row['english'],
'path' => $row['path'],
//add more here);
You could even add a sub-loop here:
$entry = array('english' => $row['english'],
'path' => $row['path'],
//add more here);
//guessing here
$sql = 'SELECT * FROM tracks WHERE artist = "'.$row['artist_name'].'"';
$sth = mysql_query($sql);
while($track = mysql_fetch_assoc($sth)) {
$entry['tracks'][$track['name']] = $track;
}
$playlist[$row['artist_name']][] = $entry;
//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
--
paperCrane <Justin Patrin>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
