<?php require("database.php"); $query = "select id,title,content,createtime from content order by createtime asc limit 5000"; $result = mysql_query($query,$link); $queryb = "select unix_timestamp(now()) as starttime"; $querye = "select unix_timestamp(now()) as endtime"; $resultb = mysql_query($queryb,$link); $rowb = mysql_fetch_assoc($resultb); echo $rowb["starttime"]; while($array = mysql_fetch_array($result)){ ?> <dl> <dt><?php echo $array["title"]."--".$array["id"]."发表时间：".$array["createtime"];?></dt> <dd><?php echo $array["content"]; ?></dd> </dl> <?php } $resulte = mysql_query($querye,$link); $rowe = mysql_fetch_assoc($resulte); echo $rowe["endtime"]; $t = ($rowe["endtime"] - $rowb["starttime"])/1000; echo "<br/>执行时间为:".$t."s"; mysql_close($link); ?>
原文地址：http://purplegourd.com/2010/10/26/php-mysql%e7%b2%be%e7%a1%ae%e6%b5%8b%e8%af%95sql%e8%af%ad%e5%8f%a5%e6%89%a7%e8%a1%8c%e6%97%b6%e9%97%b4/
