Re: [PHP] Re: About PHP/XML/XSLT/MYSQL Web Sites
- From: quickshiftin@xxxxxxxxx ("Nathan Nobbe")
- Date: Fri, 13 Jul 2007 11:22:07 -0400
Although it is necessary to convert SQL data into XML before it can bedirectly
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
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
- References:
- About PHP/XML/XSLT/MYSQL Web Sites
- From: Kelvin Park
- Re: About PHP/XML/XSLT/MYSQL Web Sites
- From: "Tony Marston"
- About PHP/XML/XSLT/MYSQL Web Sites
- Prev by Date: Re: [PHP] The end of PHP4 is nigh!
- Next by Date: Re: Announcing Xaja, a PHP Reverse Ajax framework
- Previous by thread: Re: About PHP/XML/XSLT/MYSQL Web Sites
- Next by thread: Web Developer - interesting opportunity in SFO
- Index(es):
Relevant Pages
|
Loading
