網站程式設計-PHP
########################################
# 列表
########################################
function op_list()
{
global $mysqli,$smarty,$TBL;
#取得所有記錄
$sql = "select *
from `{$TBL['name']}`
order by `sort` desc";//die($sql);
$result = $mysqli->query($sql) or die(printf("Error: %s <br>".$sql, $mysqli->sqlstate));
$rows=array();
$col_name = "prod";//圖片資料表的關鍵字
while($row = $result->fetch_assoc())
{
#過濾撈出資料
$row['sn'] = intval($row['sn']);
//http://www.w3school.com.cn/php/func_string_htmlspecialchars.asp
$row['title'] = htmlspecialchars($row['title'], ENT_QUOTES); // 轉換雙引號和單引號
$row['sort'] = intval($row['sort']);
$row['enable'] = $row['enable'] ? "是":"<span style='color:red;'>否</span>";
$row['price'] = intval($row['price']);
$row['counter'] = intval($row['counter']);
$row['date'] = intval($row['date']);//日期是以時間戳記儲存
$row['date'] = date("Y-m-d",$row['date']);//http://www.w3school.com.cn/php/php_date.asp
#取得圖片src
$row['file_name'] = get_file_name_src($row['sn'],$col_name);
$rows[]= $row;
}
$smarty->assign("rows", $rows);
return;
}