PHP XML Generation
<?php
function &last(&$array) {
if (!count($array)) return null;
end($array);
return $array[key($array)];
}function
myParseXML(&$vals, &$dom, &$lev) {
do {
$curr = current($vals);
$lev = $curr['level'];
switch ($curr['type']) {
case 'open':
if (isset($dom[$curr['tag']])) {
$tmp = $dom[$curr['tag']];
if (!$tmp['__multi'])
$dom[$curr['tag']] = array('__multi' => true, $tmp);
array_push($dom[$curr['tag']], array());
$new =& last($dom[$curr['tag']]);
} else {
$dom[$curr['tag']] = array();
$new =& $dom[$curr['tag']];
}
next($vals);
myParseXML(&$vals, $new, $lev);
break;
case 'cdata':
break;
case 'complete':
if (!isset($dom[$curr['tag']]))
$dom[$curr['tag']] = $curr['value'];
else {
if (is_array($dom[$curr['tag']]))
array_push($dom[$curr['tag']] , $curr['value']);
else
array_push($dom[$curr['tag']] = array($dom[$curr['tag']]) , $curr['value']);
}
break;
case 'close':
return;
}
}
while (next($vals)!==FALSE);
}function
MyXMLtoArray($XML) {
$xml_parser = xml_parser_create();
xml_parse_into_struct($xml_parser, $XML, $vals);
xml_parser_free($xml_parser);
reset($vals);
$dom = array(); $lev = 0;
myParseXML($vals, $dom, $lev);
return $dom;
}function
mysql2xml($sql, $dblink) {
$counter = 0;
unset($fields);$output = "<?phpxml version=\"1.0\" encoding=\"iso-8859-1\"?>\n";
$output .= "<coredata>\n";$res = mysqli_query($dblink, $sql); for (
$i=0; $i<mysqli_num_fields($res); $i++)
$fields[] = mysqli_field_name($res, $i); while (
$myr = mysqli_fetch_array($res)) {
$counter++;$output .= " <entry$counter>\n"; for (
$i=0; $i<count($fields); $i++) {
$field = $fields[$i];
$data = $myr[$field];$output .= " <$field>$data</$field>\n";
}$output .= " </entry$counter>\n";
}$output .= "</coredata>\n"; return
$output;
}