RE: [PHP-DB] Re: XML

Yup! To be specific Buyer places order via our php/mysql ecommerce site (a la Amazon) OR { The order is generated by software on buyers server (some orders are in excess of 150 items). The buyers server sends the order in XML format to our server Our server decodes the order and feeds it into the existing php/mysql order processing } Then, in both cases Our server queries suppliers remote servers to check prices and availability, communicating using XML and returns best price/availability to buyer Buyer selects supplier and the order is sent to that supplier in XML format. Hope this paints a clear picture Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net info@sunmaia.net tel. 0121-242-1473 ----------------------------------------------- > -----Original Message----- > From: MikeParton [mailto:mike.parton@nimblesdg.com] > Sent: 28 June 2002 18:19 > To: Peter Lovatt; php-db@lists.php.net; mysql@lists.mysql.com > Subject: Re: [PHP-DB] Re: XML > > > To restate what might be the obvious, you're attempting to build a web > service for accepting XML "messages", convert the data to store in a MySQL > database and be able to extract the data into an XML document and send. > More or less correct? > > You might want to get on an xml-rpc or SOAP list and ask for > pointers there. > > Mike > ----- Original Message ----- > From: "Peter Lovatt" <pjln1@sunmaia.net> > To: <php-db@lists.php.net>; <mysql@lists.mysql.com> > Sent: Friday, June 28, 2002 12:45 PM > Subject: RE: [PHP-DB] Re: XML > > > > Hi > > > > Interesting discussion. The question was actually about converting XML > data > > and loading it into a MySql database. Should have been clearer in the > > original question :) > > > > i.e. > > > > XML -> convert to field data -> MySql table > > > > We have a website that has been self contained but increasingly needs to > > interface with other sites and servers. We are a portal site which takes > > orders from customers, finds the best supplier and passes the > order to the > > supplier. To date, data interchange as been by users uploading csv data. > We > > are progressing to live interfacing and want to use XML to query and/ or > > load data to and from remote servers. > > > > Not having worked with XML before and having to put a fixed price on the > > contract I was looking for techniques for converting XML -> MySql and > > MySql -> XML and any problems - don't want to over or under quote. > > > > Thanks for the replies, if anybody has anything to add in the > light of the > > above I would be interested to hear from you. > > > > Peter > > > > ----------------------------------------------- > > Excellence in internet and open source software > > ----------------------------------------------- > > Sunmaia > > www.sunmaia.net > > info@sunmaia.net > > tel. 0121-242-1473 > > ----------------------------------------------- > > > > > -----Original Message----- > > > From: MikeParton [mailto:mike.parton@nimblesdg.com] > > > Sent: 28 June 2002 02:33 > > > To: Ed Carp; Peter Lovatt; php-db@lists.php.net; mysql@lists.mysql.com > > > Subject: [PHP-DB] Re: XML > > > > > > > > > Would be interesting to hear from Peter on why he feels the urge to > store > > > XML docs in MySQL (or, better said: I would be interested in hearing > what > > > he is trying to accomplish and why he...or someone...feels > XML stored in > a > > > relational database is the way to go). > > > > > > mysql, sql, xql, xquery, query....what did I miss? > > > > > > Mike > > > > > > > > > ----- Original Message ----- > > > From: "Ed Carp" <erc@pobox.com> > > > To: "MikeParton" <mike.parton@nimblesdg.com>; "Peter > > > Lovatt" > > > <pjln1@sunmaia.net>; <php-db@lists.php.net>; > > > <mysql@lists.mysql.com> > > > Sent: Thursday, June 27, 2002 9:14 PM > > > Subject: RE: XML > > > > > > > > > > > On the other hand, proclaimed "native" XML databases (eg, > > > Software AG's > > > > > Tamino, Ixiasoft's TEXTML) store the "XML-wrapped" data in > > > > > the > > > database...no > > > > > need to wrap and unwrap the metadata, document/data structure from > the > > > data. > > > > > > > > Isn't that more than a bit stupid? Databases are for storing data, > not > > > metadata. Ask Monty why he doesn't store data natively as > > > > XML. Short answer: it's stupid, unless all you ever want to > > > see from your > > > database is XML-wrapped data and never want to see it any > > > > other way. > > > > > > > > The whole world isn't XML, nor should it be. 40+ years of working > with > > > data tells us that you ALWAYS want to store data in its > > > > simplest form. > > > > > > > > sql,db,mysql > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > Before posting, please check: > > > > http://www.mysql.com/manual.php (the > > > > manual) > > > > http://lists.mysql.com/ (the list > > > > archive) > > > > > > > > To request this thread, e-mail <mysql-thread113254@lists.mysql.com> > > > > To unsubscribe, e-mail > > > <mysql-unsubscribe-mike.parton=nimblesdg.com@lists.mysql.com> > > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <mysql-thread113328@lists.mysql.com> > To unsubscribe, e-mail <mysql-unsubscribe-mike.parton=nimblesdg.com@lists.mysql.com> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php