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/
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format