name: " . $_POST['assessments_name'];
echo "
info: " . $_POST['assessment_info'];
echo "
ngl: " . $_POST['nql_level'];
echo "
credits: " . $_POST['credits'];
echo "
Sections total: " . $_POST['sections_total'];
var_dump($_POST);
$record = $db->Update('assessments', ['assessments_name', 'assessment_info', 'nqf_level', 'credits', 'passmark'], [$_POST['assessments_name'], $_POST['assessment_info'], $_POST['nqf_level'], $_POST['credits'], $_POST['passmark']], "record_id = {$_POST['assessment_id']}");
echo "DELETE FROM `assessment_sections` WHERE `assessment_id` = {$_POST['assessment_id']}";
$db->delete_query("DELETE FROM `assessment_sections` WHERE `assessment_id` = {$_POST['assessment_id']}");
$index = 0;
while ($index <= $_POST['sections_total']) {
echo "
" . $_POST["section_" . $index . "_name"];
if (strlen($_POST["section_" . $index . "_name"]) != 0) {
$section_id = $db->insert("INSERT INTO `assessment_sections` (`assessment_id`,`section_name`) VALUES ({$_POST['assessment_id']},'{$_POST["section_" .$index . "_name"]}')");
$db->delete_query("DELETE FROM `assessment_questions` WHERE `assessment_section_id` = {$_POST["section_$index" . "_id"]}");
$q_index = 0;
while ($q_index <= $_POST['row_count_' . $index]) {
if (strlen($_POST[$index . "_question_$q_index"]) != 0) {
echo "
" . $_POST[$index . "_question_$q_index"];
$db->insert("INSERT INTO `assessment_questions` (`assessment_section_id`,`question`) VALUES ($section_id,'{$_POST[$index . "_question_$q_index"]}')");
}
$q_index++;
}
}
$index++;
}
echo "";