example2.php

example2.php <?phpinclude_once("XML/sql2xml.php");$sql2xmlclass = new xml_sql2xml("mysql://username:password@localhost/xmltest");$xmlstring = $sql2xmlclass->getxml("select * from bands left join albums on bands.id = bandsID");?>输出结果$xmlstring = "<?xml version="1.0"?>    <root>        <result>            <row>                <id>1</id>                <name>The Blabbers</name>                <birth_year>1998</birth_year>                <birth_place>London</birth_place>                <genre>Rock"n"Roll</genre>                <row>                    <id>1</id>                    <bandsID>1</bandsID>                    <title>BlaBla</title>                    <year>1998</year>                    <comment>Their first one</comment>                </row>                <row>                    <id>2</id>                    <bandsID>1</bandsID>                    <title>More Talks</title>                    <year>2000</year>                    <comment>The second one</comment>                </row>            </row>            <row>                <id>2</id>                <name>Only Stupids</name>                <birth_year>1997</birth_year>                <birth_place>New York</birth_place>                <genre>Hip Hop</genre>                <row>                    <id>3</id>                    <bandsID>2</bandsID>                    <title>All your base...</title>                    <year>1999</year>                    <comment>The Classic</comment>                </row>            </row>        </result>    </root>"