php代码程序如下:
<?php
require_once("conn_inc.php");
require_once("smarty_inc.php");
$query=mysql_query("select * from news_list order by id desc");
while ($row=mysql_fetch_array($query))
{
$array[]=array("id"=>"$row[id]","name"=>"$row[name]","pass"=>"$row[pass]","mail"=>"$row[mail]","content"=>"$row[content]");
}
$smarty->assign("title_name",$array);
$smarty->display("list.tpl.html");
?>
模板代码程序如下:
<html>
<table border="1" width="70%">
<tr>
<td>ID</td>
<td>用户名:</td>
<td>密码:</td>
<td>电子邮件</td>
<td>内容介绍</td>
</tr>
{section name=list loop=$title_name}
<tr>
<td>{$title_name[list].id}</td>
<td>{$title_name[list].name}</td>
<td>{$title_name[list].pass}</td>
<td>{$title_name[list].mail}</td>
<td>{$title_name[list].content}</td>
</tr>
{/section}
</table>
</html>