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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux