最新xoops模組開發
一、流程
- switch
#---- 編輯商品資料
case "opUpdate":
$sn = opUpdate($sn);
XoopsCache::clear();
redirect_header($_SESSION['return_url'], 3, _BP_SUCCESS);
exit;
二、函數
- opUpdate($sn = "")
########################################
# 編輯資料
########################################
function opUpdate($sn = "") {
global $xoopsDB, $xoopsUser,$module_name,$xoopsModuleConfig;
//---- 過濾資料 -----------------------------------------*/
$myts = &MyTextSanitizer::getInstance();
#標題
$_POST['title'] = $myts->addSlashes($_POST['title']);
#youtube id
$_POST['youtube'] = $myts->addSlashes($_POST['youtube']);
#日期
$_POST['date'] = userTimeToServerTime(strtotime($myts->addSlashes($_POST['date'])));//把時間改為主機時間搓記
#精選
$_POST['choice'] = intval($_POST['choice']);
#狀態
$_POST['enable'] = intval($_POST['enable']);
#商品類別
$_POST['kind'] = intval($_POST['kind']);
#排序
$_POST['sort'] = intval($_POST['sort']);
#單位
$_POST['unit'] = $myts->addSlashes($_POST['unit']);
#規格
$_POST['standard'] = $myts->addSlashes($_POST['standard']);
#尺寸
$_POST['size'] = $myts->addSlashes($_POST['size']);
#價格
//$_POST['price'] = intval($_POST['price']);
#數量
//$_POST['amount'] = intval($_POST['amount']);
#內容
$_POST['content'] = $myts->addSlashes($_POST['content']);
#摘要
$_POST['summary'] = $myts->addSlashes($_POST['summary']);
#sn
$_POST['sn'] = intval($_POST['sn']);
//print_r($_POST);die();
//-------------------------------------------------------*/
$sql = "update " . $xoopsDB->prefix("cnu_show_prod") . "
set
`title`='{$_POST['title']}',
`date`='{$_POST['date']}',
`choice`='{$_POST['choice']}',
`enable`='{$_POST['enable']}',
`kind`='{$_POST['kind']}',
`content`='{$_POST['content']}',
`summary`='{$_POST['summary']}',
`sort`='{$_POST['sort']}',
`unit`='{$_POST['unit']}',
`standard`='{$_POST['standard']}',
`size`='{$_POST['size']}',
`youtube`='{$_POST['youtube']}'
where `sn`='{$_POST['sn']}'"; //die($sql);
$xoopsDB->queryF($sql) or redirect_header($_SERVER['PHP_SELF'], 3, web_error());
#處理圖片
#----單圖上傳
$subdir = "prod"; //子目錄(前後不要有 / )
$ugmUpFiles = new ugmUpFiles($module_name, $subdir); //實體化
$name = "prod"; //表單欄位名稱
$col_name = "prod"; //資料表關鍵字
$col_sn = $_POST['sn']; //關鍵字流水號
$multiple = false; //單檔 or 多檔上傳
$main_width = 840; //大圖壓縮尺吋，-1則不壓縮
$thumb_width = 120; //小圖壓縮尺吋
$ugmUpFiles->upload_file($name,$col_name,$col_sn,$multiple,$main_width,$thumb_width);
#------------------------------------------------
#上傳pdf型錄
#----
$subdir = "prod"; //子目錄(前後不要有 / )
$ugmUpFiles = new ugmUpFiles($module_name, $subdir); //實體化
$name = "prodPdf"; //表單欄位名稱
$col_name = "prodPdf"; //資料表關鍵字
$col_sn = $_POST['sn']; //關鍵字流水號
$multiple = false; //單檔 or 多檔上傳
$main_width = ""; //大圖壓縮尺吋，-1則不壓縮
$thumb_width = ""; //小圖壓縮尺吋
$ugmUpFiles->upload_file($name,$col_name,$col_sn,$multiple,$main_width,$thumb_width);
return $_POST['sn'];
}