$conn = mysql_connect(HOST,USER,PWD);
mysql_select_db(DB);
$result['rs'] = mysql_query($sqltext);
$result['num'] = mysql_num_rows($result['rs']);
$result['affected'] = mysql_affected_rows();
$result['insertId'] = mysql_insert_id();
$result['error'] = mysql_error();
if($result['error'] != "")
{
$this -> errorMsg($result['error'],$sqltext);
}
while ($row = mysql_fetch_array($result['rs']))
{
$result['record'][] = $row;
}
mysql_free_result($result['rs']);
mysql_close($conn);
unset($sqltext);
mysql_select_db(DB);
$result['rs'] = mysql_query($sqltext);
$result['num'] = mysql_num_rows($result['rs']);
$result['affected'] = mysql_affected_rows();
$result['insertId'] = mysql_insert_id();
$result['error'] = mysql_error();
if($result['error'] != "")
{
$this -> errorMsg($result['error'],$sqltext);
}
while ($row = mysql_fetch_array($result['rs']))
{
$result['record'][] = $row;
}
mysql_free_result($result['rs']);
mysql_close($conn);
unset($sqltext);
$result['record']为最后得到的数据结果.
在php程序页面绑定:$smarty = new Smarty();
$smarty -> assign("record",$result['record']);
在静态页面循环显示:
<{section name="name" loop=$record}>
<{$record[name].表字段}>
<{/section}>
这是最简单的section循环.