18-10 get_block_prod()函數

########################################
# 取得商品列表
########################################
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;
}