example2.php

example2.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 = '

    
        
            
                1
                The Blabbers
                1998
                London
                Rock'n'Roll
                
                    1
                    1
                    
                    1998
                    Their first one
                
                
                    2
                    1
                    
                    2000
                    The second one
                
            
            
                2
                Only Stupids
                1997
                New York
                Hip Hop
                
                    3
                    2
                    
                    1999
                    The Classic
                
            
        
    

'