Re: [xsl] Create a web interface to query a XML database

[Manuel Souto Pico <m.soutopico@xxxxxxxxx>]

I forgot to mention something which is important in taking a decision
as for what technology to use. With PHP-MySQL the user can send
queries to the database from a web form and get the results -- I
understood this can be done with XRX/XSLT/etc. However, with PHP-MySQL
I can also input data to the database and add new registers or
maintain the database updating the content of certain existing
registers, with phpmyadmin or with ad-hoc web forms. Can this be done
with the XML-based technologies?

Cheers, Manuel



2009/10/1 Manuel Souto Pico <m.soutopico@xxxxxxxxx>:
> Dear Vyacheslav and Martin,
>
> Thanks a lot for your replies. I don't know what differences there are
> exactly between the two versions but everything I've done so far in
> XSLT was with version 2.0 (because I had to use for-each-groups, for
> example). I wouldn't mind using version 1.0, however.
>
> Martin, is PHP the only way I can create HTML forms to send the
> parameters to XSLT? Assuming I use PHP for that, the workflow would be
> something like PHP-HTML page with a form to enter the search term,
> which is sent to the XSLT stylesheet, which uses it in a if or when
> condition to produce a HTML page with the results, is all this
> correct? And everything happens on the server-side.
>
> I'm also having a look at the eXist sugggestion by Vyacheslav, thanks
> ;) It seems that implies using XForms as well as XQuery, but on the
> client-side, so your browser needs to have support for XForms
> (IExplorer does, but latest version of Firefox does not).
>
> Thanks a lot, I'll keep checking this thread and, if I eventually
> manage, will post a summary of my adventure ;)
>
> Cheers, Manuel
>
> 2009/9/30 Martin Honnen <Martin.Honnen@xxxxxx>:
>> Manuel Souto Pico wrote:
>>
>>> Well, I just wanted to let you know what I intend to you, perhaps you
>>> can advice me some way to go. Am I on the right path? Is XSLT/XQuery
>>> easier or better than PHP-MySQL if my data is already in XML format?
>>
>> XSLT can be used to transform XML to HTML and it can take parameters so
you
>> can certainly write an XSLT stylesheet that takes search terms as
parameters
>> and then searches and transforms your XML input source into HTML. If you
>> have PHP 5 on the server then it comes with support for running XSLT 1.0
>> transformations with the help of libxslt I think.
>>
>> So that approach is possible. Whether it is better in terms of memory
>> consumption and performance on a web server than putting the data in a
MySQL
>> database you will have to measure.
>>
>> --
>>
>>        Martin Honnen
>>        http://msmvps.com/blogs/martin_honnen/