Archief - PHP: Mysql -> Php -> Xml

<?php 

header("Content-type: text/xml"); 

$host = "localhost"; 
$user = "root"; 
$pass = ""; 
$database = "cms"; 

$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host."); 
mysql_select_db($database, $linkID) or die("Could not find database."); 

$query = "SELECT * FROM calendar ORDER BY date ASC"; 
$resultID = mysql_query($query, $linkID) or die("Data not found."); 

$xml_output = "<?xml version=\"1.0\"?>\n"; 
$xml_output .= "<calendar>\n"; 

for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){ 
    $row = mysql_fetch_assoc($resultID); 
    $xml_output .= "\t<events>\n"; 
    $xml_output .= "\t\t<date>" . $row['date'] . "</date>\n"; 
        // Escaping illegal characters 
        $row['text'] = str_replace("&", "&", $row['text']); 
        $row['text'] = str_replace("<", "<", $row['text']); 
        $row['text'] = str_replace(">", "&gt;", $row['text']); 
        $row['text'] = str_replace("\"", "&quot;", $row['text']); 
    $xml_output .= "\t\t<content>" . $row['content'] . "</content>\n"; 
    $xml_output .= "\t</events>\n"; 
} 

$xml_output .= "</calendar>"; 

echo $xml_output; 

?>

<?xml version="1.0" ?> 
 <calendar>
   <events>
      <date>2008-02-28</date> 
      <content>dit is een eerste test</content> 
   </events>
 </calendar>

$query = "SELECT * FROM calendar ORDER BY date ASC";

$query = "SELECT content, DATE_FORMAT(date, '%d %M %Y') from calendar ORDER BY date ASC";