example2.php

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>

‘