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

Subject: Re: [xsl] Create a web interface to query a XML database
From: Vyacheslav Sedov <vyacheslav.sedov@xxxxxxxxx>
Date: Thu, 1 Oct 2009 09:15:27 +0400
XForms for Firefox 3.5 is here

http://philipp.wagner.name/blog/2009/07/hooray-xforms-for-firefox-3-5-is-here
/



On Thu, Oct 1, 2009 at 4:35 AM, Manuel Souto Pico <m.soutopico@xxxxxxxxx>
wrote:
> 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/

Current Thread