Has PHP a function to ENCODE a MySQL Table into XML like ...?

Question

<?xml>
<table>
    <row>
        <columnA>ValueA</columnA>
        <columnB>ValueB</columnB>
        <columnC>ValueC</columnC>
        <columnD>ValueD</columnD>
        <columnE>ValueE</columnE>
    </row>
    <row>
        <columnA>ValueA</columnA>
        <columnB>ValueB</columnB>
        <columnC>ValueC</columnC>
        <columnD>ValueD</columnD>
        <columnE>ValueE</columnE>
    </row>
...
</table>

you can likely adapt the code shown here

Gordon
– Gordon

2010-10-14 14:20:16 +00:00
Commented Oct 14, 2010 at 14:20 — Gordon
– Gordon, Commented Oct 14, 2010 at 14:20

VoteyDisciple · Accepted Answer · 2010-10-14 13:51:12Z

2

Some quick Googling reveals this as your best option: http://www.tonymarston.net/php-mysql/dom.html

answered Oct 14, 2010 at 13:51

VoteyDisciple

37.9k5 gold badges100 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fenton · Accepted Answer · 2010-10-14 13:50:09Z

0

You could either use...

htmlentities($table, ENT_QUOTES);

Or you could use CDATA...

<![CDATA[
<table>
    <row>
        <columnA>ValueA</columnA>
        <columnB>ValueB</columnB>
        <columnC>ValueC</columnC>
        <columnD>ValueD</columnD>
        <columnE>ValueE</columnE>
    </row>
    <row>
        <columnA>ValueA</columnA>
        <columnB>ValueB</columnB>
        <columnC>ValueC</columnC>
        <columnD>ValueD</columnD>
        <columnE>ValueE</columnE>
    </row>
...
</table>
]]>

answered Oct 14, 2010 at 13:50

Fenton

253k74 gold badges403 silver badges413 bronze badges

2 Comments

CRISHK Corporation Over a year ago

I'm looking for a function like json_encode that converts an array to JSON format, but in this case to XML

Fenton Over a year ago

There isn't a built-in function for that, but there custom functions available... like this one... snipplr.com/view/3491/…

Māris Kiseļovs · Accepted Answer · 2010-10-14 13:53:26Z

0

I prefer using MDB2-Schema PEAR class to store SQL table structure in XML files. http://pear.php.net/manual/en/package.database.mdb2-schema.dump.php

answered Oct 14, 2010 at 13:53

Māris Kiseļovs

17.3k5 gold badges43 silver badges50 bronze badges

Collectives™ on Stack Overflow

Has PHP a function to ENCODE a MySQL Table into XML like ...?

3 Answers 3

Comments

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Linked

Related