php xml

[Derzz]

ya aki esta en comillas simples

Código PHP:

<?php
 
/*
This is a sample file that extracts a list of records from a mysql database and 
builds a playlist from it. After looking through this file, you'll probably
'get the idea' and'll be able to connect the flash player
to your own database.
*/
 
 
// first connect to database
$dbcnx = @mysql_connect("localhost","derzz_web","c4rl0z!");
$dbselect = @mysql_select_db("derzz_db");
if ((!$dbcnx) || (!$dbselect)) { echo "Can't connect to database"; }
 
 
// next, query for a list of titles, files and links.
$query = "SELECT nombre,ruta FROM archivos_mp3";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
 
 
// third, the playlist is built in an xspf format
// we'll first add an xml header and the opening tags .. 
header("content-type:text/xml;charset=utf-8");
 
 
echo '<?xml version="1.0" encoding="utf-8"?>\n';
echo '  <songs>\n';
 
// .. then we loop through the mysql array ..
while($row = @mysql_fetch_array($result)) {
    echo '<song title="'|||.$row['nombre']'"' 'path="'.$row['ruta'] '"/>\n';
    
}
//<song title="La amante - grupo 5" path="llamado.mp3"/>
// .. and last we add the closing tags
echo '  </songs>\n';
 
 
 
/*
That's it! You can feed this playlist to the SWF by setting this as it's 'file' 
parameter in your HTML.
*/
 
?>