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@marston-home.demon.co.uk> 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@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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php