ysoo
(PHPSOFT)
高级会员
高级无限制会员
UID 16618
精华
0
积分 903
帖子 853
金钱 903 喜悦币
威望 0
人脉 0
阅读权限 50
注册 2002-9-20
状态 离线
|
当遇到数据量大的时候，用XML还真实快啊
我写了个简单的测试页面：
/*HTML框架，调用XML数据*/
xml_1.php
<html>
<head>
<script language=javascript>
<!--
function frm_click(field){
var row=field.rowIndex;
xml1.recordset.absoluteposition = row + 1;
td_id.innerHTML=xml1.recordset("CITY_ID");
td_name.innerHTML=xml1.recordset("CITY_NAME");
}
-->
</script>
</head>
<body>
<?
function getmicrotime(){
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}
$time_start = getmicrotime();
?>
<xml id="xml1" src="xml_2.php"></xml>
<table border="1" width=100>
<tr align="left">
<td id="td_id"> </td>
</tr>
<tr align="left">
<td id="td_name"> </td>
</tr>
</table>
<table border="1" width=100% datasrc="#xml1">
<tr onclick="frm_click(this);">
<td><div datafld="CITY_ID"></div></td>
<td><input type=text name=city_name datafld="CITY_NAME"><div ></div></td>
<td><div datafld="CITY_TIME"></div></td>
</tr>
</table>
<?
$time_end = getmicrotime();
$time = $time_end - $time_start;
echo $time_start;
echo "<BR>";
echo $time_end;
echo "<BR>";
echo $time;
?>
</body>
</html>
/*从MYSQL数据库调用数据动态生成XML*/
xml_2.php
<?
header('Content-Type: text/xml; charset=GB2312');
echo "<?xml version='1.0' encoding='GB2312'?>";
include("DB/DB.inc.php");
include("DB/DB.config.php");
include("DB/DB.soft.php");
?>
<CATALOG>
<?
$i = 1;
for($j=0;$j<=10;$j++){
$sql = "SELECT * FROM city ORDER BY id asc";
$rst = $db->query($sql);
while($row = $db->fetch_array($rst)){
$id = $row[id];
$name = $row[name];
?>
<CD>
<CITY_ID><?=$i?></CITY_ID>
<CITY_NAME><?=$name?></CITY_NAME>
<CITY_TIME><?=$time?></CITY_TIME>
</CD>
<?
$i++;
}
}
?>
</CATALOG>
|
|
