Hi I have a page containing xml data that is generated in a php page through mysql database. I have then performed an xsl transformation using an xsl stylesheet and a php script to print html.
what i want to know is, is there any benefit of spitting xml out then transforming it in this way as opposed to generating a styled php page straight away (cutting out the xml step) from the data in mysql database?
I use a similar technique. C# connecting to SQL server creates XML, which is then transformed through XSL. The site structure and content is defined within the database.
All the database form submission stuff is handled through XML creating updategrams fired straight into sql server - this is a definite benefit for me. It's very rare that i need to play around with creating db insert/update scripts.
The main benefit of this approach for me is that if i want to create a new site - i copy the database, XSL, c# and all i need to do to restyle is to change the base xsl stylesheets. i can knock out a full cms integrated site and just change the xsl to restyle as the new client desires. Saves me lots of time, hence more money :-)
Not looked into trying this approach with MySql yet, its gotta be worth it - SQL Server is too expensive to run
Another benefit that has not been mentioned is the multiusage potential. When all your data is XML first, you could easily transform the output to html for browsers, wml for wap.yourdomain.com and some pages could be directly transformed rss. And the list goes on.