Creating XML via PHP/MySQL

[Medyman]

Hello all...

Someone asked a question about this in the Flash forum and it stirred my curiosity, so I am trying to build a system to create an XML file via data pulled from MySQL.

After some googling, I came across this:


<?php

// Simon Willison, 16th April 2003
// Based on Lars Marius Garshol's Python XMLMaker class
// See http://www.xml.com/pub/a/2003/04/09/py-xml.html

class XMLMaker {
var $xml;
var $indent;
var $stack = array();
function XMLMaker($indent = ' ') {
$this->indent = $indent;
$this->xml = '<?xml version="1.0" encoding="utf-8"?>'."\n";
}
function _indent() {
for ($i = 0, $j = count($this->stack); $i < $j; $i++) {
$this->xml .= $this->indent;
}
}
function push($element, $attributes = array()) {
$this->_indent();
$this->xml .= '<'.$element;
foreach ($attributes as $key => $value) {
$this->xml .= ' '.$key.'="'.htmlentities($value).'"';
}
$this->xml .= ">\n";
$this->stack[] = $element;
}
function element($element, $content, $attributes = array()) {
$this->_indent();
$this->xml .= '<'.$element;
foreach ($attributes as $key => $value) {
$this->xml .= ' '.$key.'="'.htmlentities($value).'"';
}
$this->xml .= '>'.htmlentities($content).'</'.$element.'>'."\n";
}
function emptyelement($element, $attributes = array()) {
$this->_indent();
$this->xml .= '<'.$element;
foreach ($attributes as $key => $value) {
$this->xml .= ' '.$key.'="'.htmlentities($value).'"';
}
$this->xml .= " />\n";
}
function pop() {
$element = array_pop($this->stack);
$this->_indent();
$this->xml .= "</$element>\n";
}
function getXml() {
return $this->xml;
}
}



$xml = new XMLMaker();
$array = array(
array('title', 'creator', 'image', 'location'),
array('title', 'creator', 'image', 'location'),
array('title', 'creator', 'image', 'location'),
);

$xml->push('playlist');
foreach ($array as $song) {
$xml->push('title', array('species' => $song[0]));
$xml->element('creator', $song[1]);
$xml->element('image', $song[2]);
$xml->element('location', $song[3]);
$xml->pop();
}
$xml->pop();

print $xml->getXml();


?>


This creates an XML file to the specs that I need.

My next step is to figure out how to save this data as an XML file so it can be read by a Flash mp3 player.

Does anyone know how to go about doing this?

The second issue is how to link it to a MySQL database and get those arrays the way that I need. Any help with that is also appreciated.

Thanks!