PHP to XML

[timmah1]

Can someone help me with this?

I'm not sure what the problem is.

I want to select items out of my database, and parse them as XML, the problem I'm having is that the XML is not showing up the variables.

Here is my PHP page:
[code]
$query = "SELECT * FROM database";
$mysql_result = mysql_query($query);

define('NEWLINE',  "\n", true);

$xml  = '<?xml version="1.0" encoding="iso-8859-1"?>' . NEWLINE;

$xml .= '<songs>' . NEWLINE;       

while($myrow = mysql_fetch_assoc($mysql_result))
$file = $myrow['file'];
$name = $myrow['name'];
{

    $xml .= '<song name='.$name.' file='.$file.'>'. NEWLINE;
}

$xml .= '</songs>';       

$fp = fopen('file.xml','w');
fwrite($fp, $xml);
fclose($fp);
[/code]

And what it parses is this:
[code]
<?xml version="1.0" encoding="iso-8859-1"?>
<songs>
<song name= file=>
</songs>
[/code]


Can anybody help me clarify this?

thanks

[roopurt18]

[code]
while($myrow = mysql_fetch_assoc($mysql_result))
$file = $myrow['file'];
$name = $myrow['name'];
{

    $xml .= '<song name='.$name.' file='.$file.'>'. NEWLINE;
}
[/code]

Your while loop is effectively:
[code]
while($myrow = mysql_fetch_assoc($mysql_result))
$file = $myrow['file'];
[/code]

Try this:
[code]
while($myrow = mysql_fetch_assoc($mysql_result)){
    $file = $myrow['file'];
    $name = $myrow['name'];
    $xml .= '<song name='.$name.' file='.$file.'>'. NEWLINE;
}
[/code]

[timmah1]

Now it does this:

[code]
<?xml version="1.0" encoding="iso-8859-1"?>
<songs>
<song name=name file=file>
</songs>
[/code]

It's not recognizing the variable for some reason

[timmah1]

Nevermind, I got it to work

Thanks for the help

[roopurt18]

You should keep in mind that valid XML requires attributes to be placed in quotes.

[timmah1]

ok, it worked like one time, and now it doesn't.

this is what it's outputting:
[code]
<?xml version="1.0" encoding="iso-8859-1"?>
<songs>
</songs>
[/code]


It works for awhile, and then it don't.

I fixed it so that it parses the quotes
[code]
$query = "SELECT * FROM database ";
$mysql_result = mysql_query($query);


define('NEWLINE',  "\n", true);



$xml  = '<?xml version="1.0" encoding="iso-8859-1"?>' . NEWLINE;


$xml .= '<songs>' . NEWLINE;       


while($myrow = mysql_fetch_assoc($mysql_result)){
    $song = $myrow['song'];
    $name = $myrow['name'];
    $xml .= '<song name="'.$song.'" file="'.$name.'">'. NEWLINE;
}



$xml .= '</songs>';       



$fp = fopen('playlist.xml','w');
fwrite($fp, $xml);
fclose($fp);

?>
[/code]

[timmah1]

I have it working now.

But now I'm having a different problem, It's only listing one value.

I put in 2 fields in the database, both or different, but the xml is only producing 1 of the entries.

Anybody have an idea?