Re: Create a web interface to query a XML database

Hi Vyacheslav,

Thanks a lot for the link. Unfortunately it seems that it's not
compatible with Firefox for Mac, i.e. the one I use.

Cheers, Manuel


2009/10/1 Vyacheslav Sedov <vyacheslav.sedov@xxxxxxxxx>:
> 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/