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>
'
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>
'
上一篇: ftp类(myftp.php)
下一篇: 草原姑娘火辣辣
推荐阅读