Re: About PHP/XML/XSLT/MYSQL Web Sites

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@gmail.com> wrote in message news:46969A0F.7000706@gmail.com... > 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 > >