name: " . $_POST['assesments_name'];
echo "
info: " . $_POST['assesment_info'];
echo "
ngl: " . $_POST['nql_level'];
echo "
credits: " . $_POST['credits'];
echo "
Sections total: " . $_POST['sections_total'];
var_dump($_POST);
$record = $db->Update('assesments', ['assesments_name', 'assesment_info', 'nqf_level', 'credits', 'passmark'], [$_POST['assesments_name'], $_POST['assesment_info'], $_POST['nqf_level'], $_POST['credits'], $_POST['passmark']], "record_id = {$_POST['assesment_id']}");
echo "DELETE FROM `assesment_sections` WHERE `assesment_id` = {$_POST['assesment_id']}";
$db->delete_query("DELETE FROM `assesment_sections` WHERE `assesment_id` = {$_POST['assesment_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 `assesment_sections` (`assesment_id`,`section_name`) VALUES ({$_POST['assesment_id']},'{$_POST["section_" .$index . "_name"]}')");
$db->delete_query("DELETE FROM `assesment_questions` WHERE `assesment_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 `assesment_questions` (`assesment_section_id`,`question`) VALUES ($section_id,'{$_POST[$index . "_question_$q_index"]}')");
}
$q_index++;
}
}
$index++;
}
echo "";