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

'