example2.php <?php include_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> '