欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

example2.php

程序员文章站 2022-07-21 20:20:18
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>

'