XML Output from MySQL

Category:	XML
Author/Contact Info	Anton van der Steen anton.vandersteen@chello.nl Eindhoven/The Netherlands/Europe
Description:	With this piece of code you can extract data from a table within MySQL and put in a XML document. The perl packages I use in this listing are standard packages, which can be found at ActiveState.com and be installed with ppm. Have fun.
`#!perl/bin/perl use strict; use DBIx::XML_RDB; my $dsn = "DBI:mysql:database=test;host=localhost"; my $dbx = DBIx::XML_RDB->new($dsn, 'mysql', 'root', 'admin'); $dbx->DoSql(qq{ SELECT * from table }); open(XML, ">table.xml") or die "Could not open file for writing: $! \n"; print XML $dbx->GetData; close XML or die "Error closing file: $!\n";`

Comment on XML Output from MySQL Download Code

Replies are listed 'Best First'.
Re: XML Output from MySQL by jeffa (Bishop) on Apr 17, 2006 at 19:45 UTC
Hi. DBIx::XML_RDB has been replaced by XML::Generator::DBI. Check out my XML::Generator::DBI Tutorial for more info. It's pretty complex, however, and while your code is much simpler, i would be more tempted to solve this problem with jZed's DBD::AnyData instead. jeffa L-LL-L--L-LL-L--L-LL-L-- -R--R-RR-R--R-RR-R--R-RR B--B--B--B--B--B--B--B-- H---H---H---H---H---H--- (the triplet paradiddle with high-hat)	[reply]

Replies are listed 'Best First'.

Re: XML Output from MySQL
by jeffa (Bishop) on Apr 17, 2006 at 19:45 UTC

Hi. DBIx::XML_RDB has been replaced by XML::Generator::DBI. Check out my XML::Generator::DBI Tutorial for more info. It's pretty complex, however, and while your code is much simpler, i would be more tempted to solve this problem with jZed's DBD::AnyData instead.

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)