Although it is necessary to convert SQL data into XML before it can be processed in an XSL transformation, it is a waste of time converting user input into XML before it is added to the database as none of the SELECT/INSERT/UPDATE/DELETE commands can work with XML files. It is far easier to take the GET/POST array and convert it into an sql query
directly
without any intermediate XML.
This is what i have been trying to express to OP. Also, i havent had time to fully explore your application framework, but i have had a glimpse at it. i really appreciate your explanation of modularizing the xsl templates as i was struggling to grasp this with my limited exposure to xsl. i read up about you on your site and discovered you had been using xsl prior to php. i am the reverse of that, so while ive been using php for a few years now xsl is still very new to me. your documentation and articles are quite excellent. i hope you dont mind if i ask a couple questions in the future myself :) -nathan On 7/13/07, Tony Marston <tony@xxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Although it is necessary to convert SQL data into XML before it can be processed in an XSL transformation, it is a waste of time converting user input into XML before it is added to the database as none of the SELECT/INSERT/UPDATE/DELETE commands can work with XML files. It is far easier to take the GET/POST array and convert it into an sql query directly without any intermediate XML. FYI a complete framework which creates all HTML using XML+XSL has already been built, and is described at http://www.tonymarston.net/php-mysql/infrastructure.html#figure5, with a working sample application which is described in and can be downloaded from http://www.tonymarston.net/php-mysql/sample-application.html -- Tony Marston http://www.tonymarston.net http://www.radicore.org "Kelvin Park" <kelvinpark86@xxxxxxxxx> wrote in message news:46969A0F.7000706@xxxxxxxxxxxx > I'm trying to setup a XSLT based web site. > I wasn't exactly sure about the flow of the whole system when data from > relational database is transferred to XML and in turn the data inputted > from the user is relayed back to the database through XML (or directly > to the database with PHP DB connection). I built a flowchart > illustrating what the flow of the XSLT/PHP/MYSQL system might be like. > If you think it's the wrong way or an inefficient way of getting user > inputted data back to mysql, I would appreciate any comments. > If you cannot download the PDF file, you can bring it up with direct > address the the file: http://www.envigan.net/CMSFLOW.pdf > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
