大門進來！"; exit; } require("style1.txt"); include 'poll_setup.php'; ?> server, $objDB->user, $objDB->pass) or $objDB->DBDie("無法連接資料庫,請檢查連線資訊!
"); mysql_select_db($objDB->db); mysql_query("SET NAMES big5") ; //新增或刪除topic switch ($fcn){ case "更動" : $query="update topics set topic_name='$topicname' ,topic_owner='".$mem_info["name"]."' where topic_no=$topicno"; $result = mysql_query($query); // if ($result) // $action="original"; // $action="upd"; break; case "刪除" : //必須同時刪除其他表格資料 $query="delete from topics where topic_no='$topicno'"; $result = mysql_query($query); // if ($result) // $action="original"; break; case "新增" : $query = "insert into topics(topic_name,topic_owner) values ('$topicname','".$mem_info["name"]."')"; $result = mysql_query($query); // if ($result) // $action="original"; // $action="upd"; break; } echo "

問卷調查表管理系統

".$mem_info["name"]."

"; if ($mem_info["id"]=='admin') $query ="select topic_no,topic_name,topic_owner from topics order by topic_no"; else $query ="select topic_no,topic_name,topic_owner from topics where topic_owner='".$mem_info["name"]."' order by topic_no"; $result = mysql_query($query); $num_results = mysql_num_rows($result); echo "新增 "; for ($i=0; $i <$num_results; $i++){ $row = mysql_fetch_array($result); echo ""; // echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "\n"; } switch ($action){ case "upd" : if ($topicno) { $query ="select topic_name,topic_owner from topics where topic_no=$topicno"; $result = mysql_query($query); $row = mysql_fetch_array($result); $topicname=$row["topic_name"]; $topicowner=$row["topic_owner"]; } if ( !$topicowner) $topicowner=$mem_info["name"]; echo ""; echo "\n"; echo ""; echo ""; echo ""; echo ""; echo ""; break; // case "original" : } echo "

編號	名稱	所有人	編輯	網頁預覽	調查結果	檔案輸出	刪除調查表
".($i+1)."	".$row["topic_no"]."	".$row["topic_name"]."	".$row["topic_owner"]."	"; echo "	"; echo "
$topicno		$topicowner	"; if ($topicno){ echo " "; } else { echo " "; } echo "

"; ?>

用戶管理 "; ?> 修改密碼登出系統