1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
<?php
include_once("connect.php");
mysql_select_db($dbname, $conn);
$sql = "SELECT * FROM `joM_1`,'joM_1','joM_75','joM_76'";
$db_items = mysql_query($sql);
$xml = new DOMDocument('1.0', 'UTF-8');
if (mysql_num_rows($db_items) != 0){
$items = $xml->createElement(« items »);
while ($db_item = mysql_fetch_assoc($db_items)){
$item = $xml->createElement(« item »);
foreach($db_item as $key => $value){
$node = $xml->createElement($key,$value);
$item->appendChild($node);
}
$items->appendChild($item);
}
$xml->appendChild($items);
}
echo $xml->saveXML();
?> |
Partager