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@xxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>; <mysql@xxxxxxxxxxxxxxx>
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@xxxxxxxxxxx
> tel. 0121-242-1473
> -----------------------------------------------
>
> > -----Original Message-----
> > From: MikeParton [mailto:mike.parton@xxxxxxxxxxxxx]
> > Sent: 28 June 2002 02:33
> > To: Ed Carp; Peter Lovatt; php-db@xxxxxxxxxxxxx; mysql@xxxxxxxxxxxxxxx
> > 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@xxxxxxxxx>
> > To: "MikeParton" <mike.parton@xxxxxxxxxxxxx>; "Peter Lovatt"
> > <pjln1@xxxxxxxxxxx>; <php-db@xxxxxxxxxxxxx>; <mysql@xxxxxxxxxxxxxxx>
> > 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@xxxxxxxxxxxxxxx>
> > > To unsubscribe, e-mail
> > <mysql-unsubscribe-mike.parton=nimblesdg.com@xxxxxxxxxxxxxxx>
> > > 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@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail
<mysql-unsubscribe-mike.parton=nimblesdg.com@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.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-thread113332@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php