XML and PHP

**Tulork** · 05-07-2008, 04: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, 06: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, 10: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

**nickohrn** · 05-07-2008, 10: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, 03: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** · 03: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 -->

05-07-2008, 04:24 PM	#1 (permalink) XML and PHP
Tulork Experienced Talker Posts: 32 Location: Sweden Talkupation:	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. __________________ Hurray for me (not)

05-07-2008, 06:55 PM	#2 (permalink) Re: XML and PHP
addonchat Skilled Talker Posts: 97 Name: Chris Duerr Talkupation:	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. __________________ Chris Duerr AddonChat Java Chat Software http://www.addonchat.com/ - Affiliate Program

05-07-2008, 10:02 PM	#3 (permalink) Re: XML and PHP
Datingsoftware Average Talker Posts: 15 Name: Mark Talkupation:	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 __________________ Setup your own dating agency today! Dating Software by eMeeting Ltd

05-07-2008, 10:12 PM	#4 (permalink) Re: XML and PHP
nickohrn Weightlifting CS Student Posts: 480 Name: Nick Ohrn Talkupation:	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. __________________ NickOhrn.com - My personal haven of insight to offer the world. Plugin-Developer.com - Custom plugin development to fit your needs. Plugins available for WordPress and Drupal, among others.

05-08-2008, 03:06 AM	#5 (permalink) Re: XML and PHP
Tulork Experienced Talker Posts: 32 Location: Sweden Talkupation:	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. __________________ Hurray for me (not)

05-08-2008, 03:21 AM	#6 (permalink) Re: XML and PHP
tripy Fetchez la vache! Latest Blog Post: Pretty pretty please…. Posts: 1,689 Name: Thierry Location: In the void Talkupation:	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 --> __________________ Listen to the ducky: "This is awesome!!!" Last edited by tripy : 05-08-2008 at 03:26 AM.