一、流程
20171122
default: $op = "opList"; $_SESSION['returnUrl'] = getCurrentUrl(); opList(); break;
二、函數
############################### # 商品列表 ############################### function opList(){ global $smarty,$db; #撈商品資料 $sql = "select * from `ugm_p_prod` order by `sort` desc ";//die($sql); $result = $db->query($sql) or redirect_header("", 3000, $db->error."\n".$sql,true); #查詢筆數 $count = $result->num_rows; $rows=[]; while($row = $result->fetch_assoc()){ #過濾資料 $row['sn'] = intval($row['sn']); $row['kind'] = intval($row['kind']); $row['title'] = htmlspecialchars($row['title'], ENT_QUOTES); $row['summary'] = htmlspecialchars($row['summary'], ENT_QUOTES); //$row['content'] = htmlspecialchars($row['content'], ENT_QUOTES); $row['price'] = intval($row['price']); $row['amount'] = intval($row['amount']); $row['enable'] = intval($row['enable']); $row['choice'] = intval($row['choice']); $row['date'] = intval($row['date']); $row['date'] = date("Y-m-d",$row['date']);//格式化 $row['sort'] = intval($row['sort']); $row['counter'] = intval($row['counter']); $row['icon'] = htmlspecialchars($row['icon'], ENT_QUOTES); $row['img'] = getProdImgPath("prod",$row['sn']); $rows[] = $row; } //print_r($rows);die(); $smarty->assign("rows", $rows);//送至樣板 } function getProdImgPath($col_name,$col_sn){ global $db; #撈資料 $sql = "select `file_name`,`sub_dir` from `ugm_p_files_center` where `col_name`='{$col_name}' and `col_sn`='{$col_sn}' "; $result = $db->query($sql) or redirect_header("", 3000, $db->error."\n".$sql,true); $row = $result->fetch_assoc(); if($row){ $row['file_name'] = htmlspecialchars($row['file_name'], ENT_QUOTES); $row['sub_dir'] = htmlspecialchars($row['sub_dir'], ENT_QUOTES); $ImgPath = WEB_URL."/uploads/".$row['sub_dir']."/".$row['file_name']; }else{ $ImgPath=""; } return $ImgPath; }
三、樣板
<{if $op == "opList"}> <div class="panel panel-primary"> <div class="panel-heading">商品管理 - 列表</div> <div class="panel-body"> <table class="table table-condensed"> <thead> <tr> <th>縮圖</th> <th>日期</th> <th>標題</th> <th>排序</th> <th>精選</th> <th>啟用</th> <th class="text-center"> <a href="admin_prod.php?op=opForm" class="btn btn-primary btn-xs">新增</a> </th> </tr> </thead> <tbody> <{foreach from=$rows item=row key=k}> <tr id="tr_<{$row.sn}>" sn="<{$row.sn}>"> <td><img src="<{$row.img}>" style="width:80px;" class='img-responsive'></td> <td><{$row.date}></td> <td><{$row.title}></td> <td><{$row.sort}></td> <td><{$row.choice}></td> <td><{$row.enable}></td> <td class="text-center"> </td> </tr> <{/foreach}> </tbody> </table> </div> </div> <{/if}>
四、圖解