RE: [PHP-DB] Re: XML From: Peter Lovatt (pjln1 <email protected>)
Date: 06/28/02

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 <email protected>
tel. 0121-242-1473
-----------------------------------------------

> -----Original Message-----
> From: MikeParton [mailto:mike.parton <email protected>]
> Sent: 28 June 2002 18:19
> To: Peter Lovatt; php-db <email protected>; mysql <email protected>
> 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 <email protected>>
> To: <php-db <email protected>>; <mysql <email protected>>
> 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 <email protected>
> > tel. 0121-242-1473
> > -----------------------------------------------
> >
> > > -----Original Message-----
> > > From: MikeParton [mailto:mike.parton <email protected>]
> > > Sent: 28 June 2002 02:33
> > > To: Ed Carp; Peter Lovatt; php-db <email protected>; mysql <email protected>
> > > 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 <email protected>>
> > > To: "MikeParton" <mike.parton <email protected>>; "Peter Lovatt"
> > > <pjln1 <email protected>>; <php-db <email protected>>; <mysql <email protected>>
> > > 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 <email protected>>
> > > > To unsubscribe, e-mail
> > > <mysql-unsubscribe-mike.parton=nimblesdg.com <email protected>>
> > > > 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 <email protected>>
> To unsubscribe, e-mail
<mysql-unsubscribe-mike.parton=nimblesdg.com <email protected>>
> 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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php