線上書籍

一、整理樣板：

1. 輪播圖：https://www.ugm.com.tw/modules/tad_book3/page.php?tbdsn=843
2. 處理圖片：https://www.ugm.com.tw/modules/tad_book3/page.php?tbdsn=707

二、撈資料

1. 資料表：
   ugm_show_kind  =>  kind='sliderHome'
   ugm_show_files_center => col_name = 'sliderHome' and col_sn = sn (ugm_show_kind)
2. 圖解
   
3. /foot.php #取得輪播圖 get_slider();
   ########################################################### # 撈輪播圖資料 ########################################################### function get_slider() { global $db, $smarty; #撈商品資料 $sql = "select b.`file_name`,b.`sub_dir` from `ugm_show_kind` as a left join `ugm_show_files_center` as b on a.sn=b.`col_sn` and a.`kind` = b.`col_name` where a.`enable`='1' and a.`kind`='sliderHome' order by a.`sort` ";//die($sql); $result = $db->query($sql) or redirect_header("", 3000, $db->error."\n".$sql,true); $rows=[]; while($row = $result->fetch_assoc()){ #過濾資料 $row['file_name'] = htmlspecialchars($row['file_name'], ENT_QUOTES); $row['sub_dir'] = htmlspecialchars($row['sub_dir'], ENT_QUOTES); $row['pic'] = ""; if($row['file_name']){ $row['pic'] = WEB_URL."/uploads/{$row['sub_dir']}/" . $row['file_name']; $rows[] = "'".$row['pic']."'"; } } #將陣列拆解成字串 $sliders = implode(",",$rows); $smarty->assign("sliders", $sliders);//送至樣板 } 樣板 <script type="text/javascript"> $(document).ready(function(){ $('header').backstretch([ <{$sliders}> ], {duration: 5000, fade: 750}); }); </script>