[PHP-DB] Re: xml to mysql tables using php
babu wrote: Hi all, I have seen in zend.com about parsing an xml document using php. i have also seen an interesting article which uses perl or java to move data from xml to database and vice versa. Does php has such functions to do so. Thanks It certainly does support parsing XML - see http://php.net/xml for all the gory details. Of course, you'll need to write your own code to insert the parsed data into your favourite database. Cheers -- David Robley Everything bows to success, even grammar. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: XML to MySQL
any one ?? Nabil [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Dear All ; I have an XML files like the following and i want to make an PHP code to insert it into my MySQL how can i read the nodes ot tages??? by the way i can export like this file from PhpMyAdmin but i cann't dump it back... Thanks in advance Nabil ?xml version=1.0 encoding=windows-1252 ? - scs-dist - !-- table dist -- - dist id1/id fnameMark/fname lnameSmith/lname companycompany1/company phone123456/phone governcity1/govern addressfirst street/address area12/area /dist -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: XML to MySQL
Search, please. http://marc.theaimsgroup.com/?l=php-dbw=2r=1s=XML+MySQLq=b Edward Dudlik Becoming Digital www.becomingdigital.com Did I help you? Want to show your thanks? www.amazon.com/o/registry/EGDXEBBWTYUU - Original Message - From: Nabil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, 03 July, 2003 02:39 Subject: [PHP-DB] Re: XML to MySQL any one ?? Nabil [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Dear All ; I have an XML files like the following and i want to make an PHP code to insert it into my MySQL how can i read the nodes ot tages??? by the way i can export like this file from PhpMyAdmin but i cann't dump it back... Thanks in advance Nabil ?xml version=1.0 encoding=windows-1252 ? - scs-dist - !-- table dist -- - dist id1/id fnameMark/fname lnameSmith/lname companycompany1/company phone123456/phone governcity1/govern addressfirst street/address area12/area /dist -- 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
[PHP-DB] RE: XML
I am looking at a project using XML to import and export data into MySql directly or using php. The datasets are quite large (40-50 million records) XML is a metadata technology - you wrap data in XML. You don't use XML to import or export data. You don't store XML in a database, you store data. When you fetch the data from the database, you wrap it in XML and send it on its way. Does that make it simpler? sql,mysql -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] 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. - Original Message - From: Ed Carp [EMAIL PROTECTED] To: Peter Lovatt [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 7:10 PM Subject: RE: XML I am looking at a project using XML to import and export data into MySql directly or using php. The datasets are quite large (40-50 million records) XML is a metadata technology - you wrap data in XML. You don't use XML to import or export data. You don't store XML in a database, you store data. When you fetch the data from the database, you wrap it in XML and send it on its way. Does that make it simpler? sql,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 [EMAIL PROTECTED] To unsubscribe, e-mail [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-DB] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: XML
On Thu, Jun 27, 2002 at 08:16:52PM -0400, MikeParton wrote: 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. That doesn't make it smart. :-) -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 29 days, processed 630,288,757 queries (251/sec. avg) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: XML
All depends on what you're trying to accomplish and the drivers behind the path you wish (or need or have been mandated) to take. Having said that, I make no claims with respect to the smartness of others (I find I too often question that in myself to serve as a judge of others). Nice little philosophical exchange...good to break the monotony of real life from time to time. Cheers to all and hope ya find the answers you seek. Mike - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: MikeParton [EMAIL PROTECTED] Cc: Ed Carp [EMAIL PROTECTED]; Peter Lovatt [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 9:10 PM Subject: Re: XML On Thu, Jun 27, 2002 at 08:16:52PM -0400, MikeParton wrote: 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. That doesn't make it smart. :-) -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 29 days, processed 630,288,757 queries (251/sec. avg) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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, querywhat did I miss? Mike - Original Message - From: Ed Carp [EMAIL PROTECTED] To: MikeParton [EMAIL PROTECTED]; Peter Lovatt [EMAIL PROTECTED]; [EMAIL PROTECTED]; [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 [EMAIL PROTECTED] To unsubscribe, e-mail [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-DB] Re: XML
At 21:33 -0400 6/27/02, MikeParton wrote: 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). C'mon. XML is just data. There's no particular reason *not* to store it in a database. Is there? But usually people who ask about storing XML in MySQL seem to think MySQL should do something for them other than *just* store and retrieve it. The question is, what? That's what doesn't seem to get answered. mysql, sql, xql, xquery, querywhat did I miss? Mike - Original Message - From: Ed Carp [EMAIL PROTECTED] To: MikeParton [EMAIL PROTECTED]; Peter Lovatt [EMAIL PROTECTED]; [EMAIL PROTECTED]; [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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: XML
If: An XML database is analogous to a pure data database Then: An XML document is the analog of a table XML Entities are analogs of columns XML Attributes are analogs of column properties (aren't these metadata?) So: Not sure there is much more metadata in an XML database than in a data database. - Original Message - From: Ed Carp [EMAIL PROTECTED] To: MikeParton [EMAIL PROTECTED]; Peter Lovatt [EMAIL PROTECTED]; [EMAIL PROTECTED]; [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 [EMAIL PROTECTED] To unsubscribe, e-mail [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-DB] RE: XML
Not sure there is much more metadata in an XML database than in a data database. In a standard database, the data and metadata are stored separately, not so with XML. When the next new latest and greatest thing comes along, you'll have to strip all that metadata out of your data. It also makes for bigger databases, and a lot more wasted space, like comparing normalized and unnormailzed tables. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php