MySQL to XML using PHP

[mrrodger]

Are any of you familiar with fusioncharts? http://www.infosoftglobal.com/FusionCharts/

I recently purchased this to create cool flash graphs from my MySQL database. The flash files require XML to work and the tutorials only came with ASP examples.

I need help writing PHP that will grab my data from MySQL and then create an XML document on the fly so that fusioncharts .swf file can understand. Can anyone help? I've had a hard time finding tutorials on this. Here is a some sample XML that they sent me (and what it should loook like after being exported):

<graph caption='Site hits per hour'>
<categories><category name='0000' showName='1' />
<category name='0100' showName='0' />
</categories>
<dataset seriesname='Sat' color='0080C0' showValue='0' lineThickness='2'>
<set value='36' />
<set value='71' />
</dataset>
<dataset seriesname='Sun' color='008040' showValue='0' lineThickness='2'>
<set value='23' />
<set value='40' />
</dataset>
</graph>

Thank you!!

Roger

[yelvington]

PHP doesn't care whether you output HTML, XML or something else. You have a sample; consider it to be a template. Query the database. Then, where the values go in your XML example, echo the retrieved data.

[mrrodger]

I ended up putting an echo in front of everything I wanted it to outputin XML and it seems to be working. But I also had to put the following tag:

echo "<?xml version='1.0' standalone='yes' ?>\n\n";

I suppose this is neccessary for it to ouput the XML?

The only thing I'm having trouble with now is that this page is not wanting to recognize my variables that are stored in the cookies. I'm trying to query my database where ID = $ID (this being the stored cookie varibale) but the query is not recognizing it on this page...but it does on all other pages. Any ideas?? Thank you!!

Roger