網站程式設計-PHP
########################################
# 取得商品列表
########################################
function get_block_prod()
{
global $mysqli,$smarty;
$TBL['name'] = "show_prod";
#取得所有記錄
$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("block_prod", $rows);
return;
}