123187643
技术员
帖子
47
精华
0
无忧币 265
积分 255
阅读权限 30
|
发表于:2007-8-20 10:38
标题：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>
|
网络虽虚拟，技术无边界，来看看大家“真面目”！ |
|
| 诚征版主 | 版主堂 | 意见建议 | 大史记 | 论坛地图