实现动态XML

最新推荐文章于 2024-05-06 10:40:30 发布

最新推荐文章于 2024-05-06 10:40:30 发布 · 138 阅读

文章标签：

#数据库

博客主要围绕实现动态XML展开，聚焦信息技术领域中XML的动态实现相关内容。

实现动态XML


首先建表： 
CREATETABLEbooks( 
bookidint(4)NOTNULLauto_increment, 
booknamevarchar(100)NOTNULL, 
bookauthvarchar(50)NOTNULL, 
bookpublishervarchar(50)NOTNULL, 
bookpubdatedatetimeNOTNULL, 
bookurlvarchar(50)NOTNULL, 
KEYbookid(bookid), 
); 

然后。。。这段是从MYSQL里取数据转化成XML的源代码： 
<? 
$connect_id=mysql_connect("localhost","root",""); 
mysql_select_db("bbs",$connect_id); 
$query="select*frombooksorderbybookid"; 
$rs=mysql_query($query,$connect_id); 
$numfields=mysql_num_fields($rs); 
$xmlfile="<?xmlversion="1.0"encoding="GB2312"?>n"; 
$xmlfile.="<books>n"; 

while($row=mysql_fetch_array($rs)){ 
for($i=0;$i<$numfields;$i++){ 
$fieldname=mysql_field_name($rs,$i); 
$xmlfile.="<".$fieldname.">".$row[$i]."</".$fieldname.">n"; 
} 
} 
mysql_free_result($rs); 
mysql_close($connect_id); 
$xmlfile.="</books>n"; 
$fp=fopen("xmldoc/xmldoc.xml","w"); 
if(fwrite($fp,$xmlfile)){ 
echo"写入文件成功!"; 
} 
else{ 
echo"写入文件失败!"; 
} 
?> 

这段是从XML里取数据转化成HTML的源代码。。。 
<? 
classxml{ 
var$parser; 

functionxml(){ 
$this->parser=xml_parser_create(); 
xml_set_object($this->parser,&$this); 
xml_set_element_handler($this->parser,"tag_on","tag_off"); 
xml_set_character_data_handler($this->parser,"cdata"); 
} 

functionparse($data){ 
xml_parse($this->parser,$data); 
} 

functiontag_on($parser,$tag,$attributes){ 
if(xml_get_current_line_number($parser)==2){ 
echo"<tr><tdcolspan="2"align="center">".$tag."</td>"; 
} 
else{ 
switch((xml_get_current_line_number($parser)-2)%6){ 
case0: 
echo"<tr><td>下载<td>"; 
break; 
case1: 
echo"<tr><td>ID号<td>"; 
break; 
case2: 
echo"<tr><td>书名<td>"; 
break; 
case3: 
echo"<tr><td>作者<td>"; 
break; 
case4: 
echo"<tr><td>出版社<td>"; 
break; 
case5: 
echo"<tr><td>出版日期<td>"; 
break; 
} 
} 
} 

functioncdata($parser,$cdata){ 
echo$cdata; 
} 

functiontag_off($parser,$tag){ 
echo"n"; 
} 
} 

$xml_parser=newxml(); 
$xmlfilename="xmldoc/xmldoc.xml"; 
$fp=fopen($xmlfilename,"r"); 
$xmldata=fread($fp,filesize($xmlfilename)); 
?> 
<html><head><title>图书信息</title></head> 
<body> 
<tableborder="0"cellspacing="1"cellpadding="2"width="80%"bgcolor="<? 
$xml_parser->parse($xmldata); 
?> 
</table>