Tad 教材網 - 線上書籍

:::

\[1011\]XOOPS 2.5 模組開發
======================

```
<pre class="brush: php;" title="code">
<?php
include 'header.php';
include_once XOOPS_ROOT_PATH."/modules/" . $xoopsModule->getVar("dirname") . "/class/admin.php" ;
$index_admin = new ModuleAdmin() ;
echo $index_admin->addNavigation('cate.php') ;

/*** 引入檔案 ***/

/*** 函數檔 ***/
function cate_form($cate_sn=null){

include_once(XOOPS_ROOT_PATH."/class/xoopsformloader.php");
  
  
  if(!empty($cate_sn)){
    $cate=get_cate($cate_sn);
  }else{
    $cate=array();
  }
  
  //建立表單物件 post , get
  $form = new XoopsThemeForm('分類設定', 'cate', 'cate.php', 'post');

//建立文字輸入框物件
  $XoopsFormText =new XoopsFormText('分類標題', 'cate_title', 40 , 255 , $cate['cate_title']);
  $XoopsFormText->setDescription ("請設定一個分類名稱");
  $form->addElement($XoopsFormText , true);

$form->addElement(new XoopsFormText('分類排序', 'cate_sort', 4 , 4  , $cate['cate_sort']) , true);

//建立單選物件
  $XoopsFormRadio =new XoopsFormRadio('是否使用', 'cate_enable' , $cate['cate_enable']);
  //$XoopsFormRadio->addOption('1', '是');
  //$XoopsFormRadio->addOption('0', '否');
  $options['1']='是';
  $options['0']='否';
  $XoopsFormRadio->addOptionArray($options);

$form->addElement($XoopsFormRadio);

if(!empty($cate_sn)){
    $form->addElement(new XoopsFormHidden('op', 'update'));
    $form->addElement(new XoopsFormHidden('cate_sn', $cate_sn));
  }else{
    $form->addElement(new XoopsFormHidden('op', 'insert'));
  }
  
  
  $Tray1=new XoopsFormElementTray('', ' ', 'name');
  $Tray1->addElement(new XoopsFormButton('', '', '送出', 'submit'));
  $Tray1->addElement(new XoopsFormButton('', '', '清除', 'reset'));
  $form->addElement($Tray1);

$form->addElement(new XoopsFormHiddenToken());

$f=$form->render();
  
  return $f;
}

//取得某筆分類資料陣列
function get_cate($cate_sn=null){
  global $xoopsDB;
  $sql="select * from ".$xoopsDB->prefix("tad_note_cate")." where `cate_sn` = '{$cate_sn}'";
  $result = $xoopsDB->query($sql) or redirect_header('cate.php', 3, mysql_error());
  $cate=$xoopsDB->fetchArray($result);
  return $cate;
}

//寫入函數
function insert_cate(){
  global $xoopsDB;

if(!$GLOBALS['xoopsSecurity']->check()){
    $error=implode("<br />" , $GLOBALS['xoopsSecurity']->getErrors());
    redirect_header($_SERVER['PHP_SELF'],3, $error);
    exit;
  }

$sql="insert into ".$xoopsDB->prefix("tad_note_cate")." (`cate_title` , `cate_sort` , `cate_enable`) values('{$_POST['cate_title']}' , '{$_POST['cate_sort']}' , '{$_POST['cate_enable']}')";
  $xoopsDB->queryF($sql) or redirect_header('cate.php', 3, mysql_error());
}

//列出所有分類資料
function list_cate(){
  global $xoopsDB;

$sql="select * from ".$xoopsDB->prefix("tad_note_cate")." order by `cate_sort`";
  $result = $xoopsDB->query($sql) or redirect_header('cate.php', 3, mysql_error());
  
  $main="
  <table cellspacing=1 class='outer'>
    <tr>
      <th>分類編號</th>
      <th>分類標題</th>
      <th>排序</th>
      <th>是否使用</th>
      <th>人氣</th>
      <th>功能</th>
    </tr>
    ";
  while($cate=$xoopsDB->fetchArray($result)){
  
    $class=($i%2)?'odd':'even';
    $i++;
    
    $enable=($cate['cate_enable']=='1')?_YES:_NO;
  
    $main .= "
    <tr class='$class'>
      <td class='txtcenter'>{$cate['cate_sn']}</td>
      <td>{$cate['cate_title']}</td>
      <td class='txtcenter'>{$cate['cate_sort']}</td>
      <td class='txtcenter'>{$enable}</td>
      <td class='txtcenter'>{$cate['cate_count']}</td>
      <td class='txtcenter'><a href='cate.php?op=delete&cate_sn={$cate['cate_sn']}'>刪除</a> | <a href='cate.php?op=modify&cate_sn={$cate['cate_sn']}'>修改</a></td>
    </tr>";
  }
  $main.="</table>";
  
  return $main;
}

//刪除函數
function delete_cate($cate_sn=null){
  global $xoopsDB;

$sql="delete from ".$xoopsDB->prefix("tad_note_cate")." where cate_sn='$cate_sn'";
  $xoopsDB->queryF($sql) or redirect_header('cate.php', 3, mysql_error());
}

//更新函數
function update_cate($cate_sn=null){
  global $xoopsDB;

if(!$GLOBALS['xoopsSecurity']->check()){
    $error=implode("<br />" , $GLOBALS['xoopsSecurity']->getErrors());
    redirect_header($_SERVER['PHP_SELF'],3, $error);
    exit;
  }

$sql="update ".$xoopsDB->prefix("tad_note_cate")." set `cate_title` ='{$_POST['cate_title']}' , `cate_sort` = '{$_POST['cate_sort']}' , `cate_enable` = '{$_POST['cate_enable']}' where `cate_sn` = '{$cate_sn}'";
  $xoopsDB->queryF($sql) or redirect_header('cate.php', 3, mysql_error());
}

/*** 流程判斷 ***/
$op = isset($_REQUEST['op'])? $_REQUEST['op'] : "";
$cate_sn = isset($_REQUEST['cate_sn'])? intval($_REQUEST['cate_sn']) : "";

switch($op){

case "insert":
  insert_cate();
  header('location:cate.php'); //轉向
  break;

case "delete":
  delete_cate($cate_sn);
  header('location:cate.php'); //轉向
  break;
  
  case "modify":
  $main = cate_form($cate_sn);
  break;

case "update":
  update_cate($cate_sn);
  header('location:cate.php'); //轉向
  break;
  
  default:
  $main = cate_form();
  $main.= list_cate();
}

/*** 輸出 ***/
echo $main;

include "footer.php";
?>
```

:::