name: " . $_POST['name'];
echo "
info: " . $_POST['test_description'];
echo "
passmark: " . $_POST['passmark'];
echo "
Sections total: " . $_POST['question_total'];
echo "
";
echo "
test_id: " . $_POST['test_id'];
var_dump($_POST);
echo "
";
if ($_POST['passmark'] == "") {
$test_id = $_POST['test_id'];
echo "
test_id: " . $_POST['test_id'] . "
";
$update_test = $db->query("tests", " UPDATE tests SET name = '{$_POST['name']}', test_description = '{$_POST['test_description']}' WHERE record_id = {$_POST['test_id']}");
echo "UPDATE tests SET name = '{$_POST['name']}', test_description = '{$_POST['test_description']}' WHERE record_id = {$_POST['test_id']}";
} else {
$test_id = $_POST['test_id'];
echo "
test_id: " . $_POST['test_id'] . "
";
$update_test = $db->query("tests", " UPDATE tests SET name = '{$_POST['name']}', test_description = '{$_POST['test_description']}', passmark = '{$_POST['passmark']}' WHERE record_id = {$_POST['test_id']}");
echo "UPDATE tests SET name = '{$_POST['name']}', test_description = '{$_POST['test_description']}', passmark = '{$_POST['passmark']}' WHERE record_id = {$_POST['test_id']}";
}
echo "
update_test: " . $update_test . "
";
$delete_questions = $db->query("test_questions", "DELETE FROM test_questions WHERE test_id = {$test_id}");
echo "
delete_questions: " . $delete_questions . "
";
$index = 0;
while ($index <= $_POST['question_total']) {
echo "
I: " . $index;
echo "
question_name: " . $_POST["question_" . $index . "_name"];
echo "
question_id: " . $_POST["question_" . $index . "_id"];
$question_name = $_POST["question_" . $index . "_name"];
$question_record_id = $_POST["question_" . $index . "_id"];
if (strlen($question_name) != 0) {
echo "
I: " . $index;
// echo "
question_name: " . $question_name;
$db->query("test_questions", "UPDATE test_questions SET `question_name` = '{$question_name}' WHERE `record_id` = '{$question_record_id}'");
echo "
UPDATE test_questions SET `question_name` = '{$question_name}' WHERE `record_id` = '{$question_record_id}'
";
$question_id = $db->query("test_questions", "INSERT INTO `test_questions` (`test_id`, `question_name`) VALUES ('{$test_id}', '{$question_name}')");
echo "
INSERT INTO `test_questions` (`test_id`, `question_name`) VALUES ('{$test_id}', '{$question_name}')
";
echo "
test_question_id: " . $question_id . "
";
$db->query("", "DELETE FROM `test_answers` WHERE `test_question_id` = '{$_POST["question_" . $index . "_id"]}'");
echo "
DELETE FROM `test_answers` WHERE `test_question_id` = '{$_POST["question_" . $index . "_id"]}'
";
$a_index = 0;
while ($a_index <= $_POST['row_count_' . $index]) {
echo "
A: " . $a_index;
echo "
answer: " . $_POST[$index . "_answer_$a_index"];
echo "
option: " . $_POST[$index . "_answer_option_$a_index"];
$answer = $_POST[$index . "_answer_$a_index"];
$option = $_POST[$index . "_answer_option_$a_index"];
if (strlen($answer) != 0) {
echo "
A: " . $a_index;
$db->insert("INSERT INTO `test_answers` (`test_question_id`,`answer`,`options`) VALUES ($question_id,'$answer','$option')");
echo "
INSERT INTO `test_answers` (`test_question_id`,`answer`,`options`) VALUES ($question_id,'$answer','$option')" . "
";
echo "
answer: " . $answer . "
";
echo "
option: " . $option . "
";
} else {
echo "
SKIPPED answer : " . $answer;
echo "
SKIPPED ". $index . "_answer_option_$a_index";
echo "
SKIPPED option: " . $option . "
";
}
$a_index++;
}
} else {
echo "
question_name: " . $question_name . "
";
}
$index++;
}
// echo "";