Re: Create a web interface to query a XML database

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/