Gecko [ www.vortexaion.com ]

Windows NT KAMIDAKI 10.0 build 19045 (Windows 10) AMD64
Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.3.9
Server IP : 192.168.3.16 & Your IP : 216.73.216.84
Domains : Cant Read [ /etc/named.conf ]
User : SISTEMA

Name	Size	Permission	Date
BabelSans-B.fdb	39.25 KB	-rw-rw-rw-	2013-03-30 13:29
cds.xml	368 B	-rw-rw-rw-	2013-03-30 13:29
dom.php	1.4 KB	-rw-rw-rw-	2013-03-30 13:29
ftp-mit-perl.pl	275 B	-rw-rw-rw-	2013-03-30 13:29
ftp-mit-php.php	1.16 KB	-rw-rw-rw-	2013-03-30 13:29
interbase.php	754 B	-rw-rw-rw-	2013-03-30 13:29
interbase.pl	1016 B	-rw-rw-rw-	2013-03-30 13:29
mingstats.html	698 B	-rw-rw-rw-	2013-03-30 13:29
mingstats_swf.php	2.84 KB	-rw-rw-rw-	2013-03-30 13:29
mysql.php	644 B	-rw-rw-rw-	2013-03-30 13:29
mysql.pl	970 B	-rw-rw-rw-	2013-03-30 13:29
oracle.php	918 B	-rw-rw-rw-	2013-03-30 13:29
oracle.pl	960 B	-rw-rw-rw-	2013-03-30 13:29
postgresql.php	1006 B	-rw-rw-rw-	2013-03-30 13:29
postgresql.pl	986 B	-rw-rw-rw-	2013-03-30 13:29
sax.php	1 KB	-rw-rw-rw-	2013-03-30 13:29
soap.php	677 B	-rw-rw-rw-	2013-03-30 13:29
sql2xml.php	211 B	-rw-rw-rw-	2013-03-30 13:29
sqlite.php	745 B	-rw-rw-rw-	2013-03-30 13:29
sqlite.pl	962 B	-rw-rw-rw-	2013-03-30 13:29
testperldbi.pl	465 B	-rw-rw-rw-	2013-03-30 13:29
xmlrss.php	572 B	-rw-rw-rw-	2013-03-30 13:29

Rename

<?php

$dom = new DOMDocument('1.0', 'iso-8859-1');

$root = $dom->createElement('cds');
    $dom->appendChild($root);

mysql_connect("localhost","root","");
    mysql_select_db("cdcol");

$result=mysql_query("SELECT id,titel,interpret,jahr FROM cds ORDER BY interpret;");
    
    while( $row=mysql_fetch_array($result) )
    {
	    $cd = $dom->createElement('cd');
	    $cd->setAttribute('id', $row['id']);

$titel = $dom->createElement('titel');
	    $titel->appendChild($dom->createTextNode($row['titel']));
	    $cd->appendChild($titel);

$interpret = $dom->createElement('interpret');
	    $interpret->appendChild($dom->createTextNode($row['interpret']));
	    $cd->appendChild($interpret);

$jahr = $dom->createElement('jahr');
	    $jahr->appendChild($dom->createTextNode($row['jahr']));
	    $cd->appendChild($jahr);

$root->appendChild($cd);
    }

header("Content-Type: text/xml;");
	$xml="<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?> 
<rss version=\"2.0\" xmlns:rdf=\"http://www.w3.org/1999/02/22-rdf-syntax-ns#\" xmlns:admin=\"http://webns.net/mvcb/\" xmlns:dc=\"http://purl.org/dc/elements/1.1/\" xmlns:slash=\"http://purl.org/rss/1.0/modules/slash/\" xmlns:wfw=\"http://wellformedweb.org/CommentAPI/\" xmlns:content=\"http://purl.org/rss/1.0/modules/content/\">
<channel>
";
echo $xml;
print $dom->saveXML();
echo "</channel></rss>";
?>