RE: Export MySQL table to formatted XML

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



You try with SimpleXML basic?

Saludos.
 --- Konstantinos Christodoulakis
<alavastros@xxxxxxxxx> escribió:


---------------------------------
I'm working on an integration between a Flash Gallery
(which use XML 
to present photos and data) and an PHP Admin Panel
(which saves the 
data in a MySQL database).

I have a mySQL table named "products" with the
following columns:

`products` (
  `id` int(11) NOT NULL auto_increment,
 `code` int(11) NOT NULL default '0',
  `collection` longtext NOT NULL,
  `product_name` longtext NOT NULL,
  `caption` longtext NOT NULL,
  `subtitle` longtext NOT NULL,
  `price` varchar(100) NOT NULL default '0',
  `status` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=29 ;

How can I export some of the data to an XML file with
the following 
structure, using php ? :

<?xml version="1.0" encoding="utf-8"?>
<collection name="xyz" subtitle="xyz" status="xyz">
<image filename="pic1x.jpg" caption="xyz" />
etc
etc
etc
</collection>

I know I may use an Select SQL Query to select the
data, but how can 
I map them to XML tags and attributes?
I'm using your class.mysql_xml PHP Class 
(http://www.phpclasses.org/browse/package/782.html),
but the 
exported XML is the following:

<?xml version='1.0' encoding='UTF-8'?>
<table>
            <ROW>
                        <ID>26</ID>
                        <CODE>1234567890</CODE>
                        <COLLECTION>1</COLLECTION>
                       
<PRODUCT_NAME>test</PRODUCT_NAME>
                        <CAPTION>test</CAPTION>
                        <SUBTITLE>TEST</SUBTITLE>
                        <PRICE>100</PRICE>
                        <STATUS>1</STATUS>
            </ROW>
</table>







PHP Data object relational mapping generator -
http://www.meta-language.net/

  
    
---------------------------------
  YAHOO! GROUPS LINKS

  
    Visit your group "php-objects" on the web.
   
    To unsubscribe from this group, send an email to:
 php-objects-unsubscribe@xxxxxxxxxxxxxxx
   
    Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.

  
---------------------------------





		
______________________________________________ 
Renovamos el Correo Yahoo! 
Nuevos servicios, más seguridad 
http://correo.yahoo.es




------------------------ Yahoo! Groups Sponsor --------------------~--> 
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/2jUsvC/tzNLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~-> 

PHP Data object relational mapping generator - http://www.meta-language.net/ 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/php-objects/

<*> To unsubscribe from this group, send an email to:
    php-objects-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Soap]     [Kernel Newbies]     [Yosemite]     [Yosemite Campsites]

  Powered by Linux