PHP Forum

**Tulork** · 05-07-2008, 05:24 PM

I have a questing regarding PHP and XML. Whats the best way for working with php and xml in the sense of presenting values from the database via PHP to the different xml files. The XML files are then used by flash to generate grafic and so on, based on the values in the xml files.

**addonchat** · 05-07-2008, 07:55 PM

Typically, I would just read a record in from the database, perhaps store it in an object, and call an object function to spit out the XML code manually to suit your DTD spec -- either to display or a file.

Parsing XML is usually where people will need help with pre-built functions/classes. http://www.php.net/xml for that.

**Datingsoftware** · 05-07-2008, 11:02 PM

something like this is works well;

PHP Code:


			
 //// YOUR DATABASE CONNECTION AND DATA HERE ///
header("Content-type: text/xml"); 
print '<?xml version="1.0" encoding="utf-8"?>
<CONFIG>
    <SETTINGS>
        <PLAYER_SETTINGS Name="name" Value="valu"/>     
    </SETTINGS>
</CONFIG>';

easy

**Plugin-Developer** · 05-07-2008, 11:12 PM

If you're using PHP5, I would investigate using the DomDocument class for building up your XML document. Also, are you only going to be using the data in the database for this purpose? If so, why not just store the data as XML in the first place.

**Tulork** · 05-08-2008, 04:06 AM

The xml documents will contain different values for different users... they have to be dynamic... the structure of the xml files will be the same in all of them though. With Dom, doesnt that just create files over and over again? Either overwrightes the old file, or creates a new one? I probably wrong.

**tripy** · 04:26 AM

I personaly like the phpWriter extension.
I've used it in my framework quixml [ http://www.quixml.org ]

I end up the XML generation with something like this:

PHP Code:


			
$objXml->setRendering('html');

$objXml->setXsl('org.quixml.index');

$objXml->start();

   $objXml->open('DATAS');

      $objXml->att('demo','true');

      $objXml->data('feeling','Happy');

      $objXml->open('subcat');

        $objXml->data('test','data comes here');

      $objXml->close();

   $objXml->close();

$objXml->end();



$objXml->output();

which output something like that:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE HTML>
<?xml-stylesheet href="/xsl/org.quixml.index" type="text/xsl"?>
<ROOT>
 <DATAS demo="true">
  <feeling>happy</feeling>
  <subcat>
    <test>data comes here</data>
  </subcat>
 </DATAS>
</ROOT>
<!-- Generation time: 0.00999999046326 -->