include_once "include/db.php";
include_once "include/func_category.php";
$conn_ategory = new Category();
$submit_name = "類別";
//print_r($_POST);exit;
$addData = $_POST["addData"];
if ($_POST["submitType"] == "addQuestion") {
if (!empty($_POST["postItem"])) {
$jitem = $_POST["postItem"];
$year = $_POST["postYear"];
$keyword = $_POST["postKeyword"];
$resolution = $_POST["postResolution"];
$answer = $_POST["postAnswer"];
$question = $_POST["postQuestion"];
$exam_id = $_POST["postExam"];
$item_result = $conn_ategory->getItemList($jitem);
$subject_id = $item_result[0]["subject_id"] . "-" . $item_result[0]["sub_id"];
if ($_POST["postPart"] != $item_result[0]["part_id"]) {
$returnMesg = "小節錯誤!請選擇正確小節!";
} else {
if ($_POST["postSection"] != $item_result[0]["section_id"]) {
$returnMesg = "節錯誤!請選擇正確節!";
} else {
if ($_POST["postChapter"] != $item_result[0]["chapter_id"]) {
$returnMesg = "章錯誤!請選擇正確章!";
} else {
if ($_POST["postSubject"] != $subject_id) {
$returnMesg = "學科錯誤!請選擇正確學科!";
} else {
$conn_ategory->addQuestion($question, $answer, $resolution, $keyword, $exam_id, $year, $jitem);
$returnMesg = "題目輸入成功";
<?php
include_once "include/db.php";
include_once "include/func_category.php";
$conn_ategory = new Category();
//print_r($_POST);exit;
if ($_POST["submitType"] == "editQuestion") {
$page_title = "修改題目";
$question_id = $_POST["postQ"];
$question_result = $conn_ategory->getQuestionList($question_id, '', '', '', '', '', '', '');
$exam_id = $question_result[0]["exam_id"];
$q_item_id = $question_result[0]["item_id"];
//print_r($question_result);exit;
$question_item_result = $conn_ategory->getItemList($q_item_id);
$question_subject_result = $conn_ategory->getSubjectList($question_item_result[0]["subject_id"], $question_item_result[0]["sub_id"]);
$q_category_id = $question_subject_result[0]["category_id"];
$q_subject_id = $question_item_result[0]["subject_id"] . "-" . $question_item_result[0]["sub_id"];
$q_chapter_id = $question_item_result[0]["chapter_id"];
$q_section_id = $question_item_result[0]["section_id"];
$q_part_id = $question_item_result[0]["part_id"];
//$exam_result = $conn_ategory->getExamList($exam_id);
//$question_exam_result = $conn_ategory->getExamList('');
}
$result = $conn_ategory->getCategoryList('');
$subject_result = $conn_ategory->getSubjectList('', '');
$chapter_result = $conn_ategory->getChapterList('');
$section_result = $conn_ategory->getSectionList('');
$part_result = $conn_ategory->getPartList('');
$item_result = $conn_ategory->getItemList('');
$exam_result = $conn_ategory->getExamList('');
//print_r($part_result);
<?php
include_once "include/db.php";
include_once "include/func_category.php";
$conn_ategory = new Category();
$result = $conn_ategory->getCategoryList('');
$subject_result = $conn_ategory->getSubjectList('', '');
$chapter_result = $conn_ategory->getChapterList('');
$section_result = $conn_ategory->getSectionList('');
$part_result = $conn_ategory->getPartList('');
$item_result = $conn_ategory->getItemList('');
//print_r($part_result);
//exit;
$arr_subject = array();
foreach ($subject_result as $key => $val) {
$id = $val["subject_id"] . "-" . $val["sub_id"];
$arr_subject[$val["category_id"]][$id] = $val["subject_name"];
}
$arr_chapter = array();
foreach ($chapter_result as $key => $val) {
$subject_id = $val["subject_id"] . "-" . $val["sub_id"];
$arr_chapter[$subject_id][$val["chapter_id"]] = $val["chapter_name"];
}
$arr_section = array();
foreach ($section_result as $key => $val) {
$arr_section[$val["chapter_id"]][$val["section_id"]] = $val["section_name"];
}
$arr_part = array();
foreach ($part_result as $key => $val) {
$arr_part[$val["section_id"]][$val["part_id"]] = $val["part_name"];
}
include_once "include/func_category.php";
$conn_ategory = new Category();
/*
if($_POST["submitType"] == "addExam"){
header('Location: '.$ROOTURL.'question_add.php?item_id='.$_POST["jitem"]);
exit;
}
*/
//print_r($_POST);exit;
$page_title = "題目內容";
if (!empty($_GET["q"])) {
$question_id = $_GET["q"];
$question_result = $conn_ategory->getQuestionList($question_id, '', '', '', '', '', '', '');
$exam_id = $question_result[0]["exam_id"];
$item_id = $question_result[0]["item_id"];
$item_result = $conn_ategory->getItemList($item_id);
$exam_result = $conn_ategory->getExamList($exam_id);
} else {
$return_mesg = "資料不齊全!";
}
include_once "include/header.php";
?>
<form name="myForm" action="question_add.php?page=search" method="post">
<div class="container">
<div class="widget customer">
<div class="hd">
<h2><?php
print $page_title;
?>
</h2>
</div>
