Dynamically creating XML data inline

Anon

Ok, what I want to do is this:

1.) run a database query to get my data(of course)

2.) write this data out dynamically in xml format in my php file.

3.) use an xsl stylesheet to format the data in html

Can it be done and where should I be looking for specific information, functions etc.

-Mark

Anon

Hi Mark,
I'm working on the same problem. Here's what I've found so far: Check out the XML-section of the phpbuilder-columns. I think Cocoon would be a nice tool, though I'm not really happy with the solution provided (writing a text file for each request).
Also, there's an article and some tools at IBM about php/java/xml:
http://www-4.ibm.com/software/developer/library/php-xml-toolkit.html?dwzone=xml

if you find any other resources, please let me know
cheers
/ken

Anon

Hi,

Thanks for replying, I've read the php builder articles and I'm with you, I can't believe this is the only way. As for Cocoon, We are running Solaris/NES and I doubt it will work with this setup. I still might give it a try though just for fun.

I really think XML is the future on so many levels. What I'd really like to do is dynamically generate xml with auto xsl transformation using php now that would be a work horse.

Maybe once the b2b developers see this it might pick up a little momentum.

-Mark

Anon

Cocoon is awsome. I'm making the transision from php to Cocoon on our corporate site now. It's a lot to learn, and pretty difficult to digest for a while, but once you get the concept and build a foundation system for your website it's beautiful.

Unfortunatly I'm not very versed with java servlets, which is the language used for most logic in Cocoon. Supposedly we'll be able to use PHP for the logic come Cocoon2. It may be a while before a solid version of Cocoon2 with PHP support is out though. For now I'm just gonna learn java servlets... guess it never hurts to learn something popular.

Matt

Anon

I agree, cocoon rules and I'm working on that java thing, too. But I still would prefer php, because this gives me far more flexibility (you don't have to set up a servlet engine). Hope ther will be a solution soon.
Matt: Cocoon should be running on your environment, at least they say so on their website.

/ken

Anon

Then why don't you just use the XSLT transformer in PHP? (I'm thinking about Sablotron)