实例代码:
db=mysqlconnect(“qvnxelmkchho.rds.sae.sina.com.cn”.′:′.′10338′,′root′,′admin888′);mysqlselectdb(‘demo′);mysqlquery(‘SETNAMESUTF8′);sql=”SELECT title,description,picUrl,url FROM img ORDER BY ids LIMIT 0,10”;
res=mysqlquery(sql)
//循环取出数据
itemCount=0;//统计有几条数据while(row=mysql_fetch_assoc($res)){
$contentStr.= sprintf($newsTplItem,$row['title'],$row['description'],$row['picUrl'],$row['url']);
++$itemCount;//统计有几条数据
}
$newsTplHeader=sprintf($newsTplHeader,$fromUsername,$toUsername,$time,$itemCount);
$resultStr=$newsTplHeader.$contentStr.$newsTplFooter;
echo $resultStr;
核心代码:分离模板
$newsTplHeader=”