Tutorials to .com

Tutorials to .com » Php » Xml » example2.php

example2.php

Print View , by: iSee ,Total views: 6 ,Word Count: 361 ,Date: Thu, 16 Apr 2009 Time: 1:09 AM

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");
?>


Output
$ 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> [AutoPage]
</ result>
</ root>

'


Php XML Application Articles


Can't Find What You're Looking For?


Rating: Not yet rated

Comments

No comments posted.