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->insert("INSERT INTO `assessments` (`assessments_name`,`expiry`,`assessment_info`,`nqf_level`,`credits`,`passmark`) VALUES ('{$_POST['assessments_name']}','36','{$_POST['assessment_info']}','{$_POST['nqf_level']}','{$_POST['credits']}','{$_POST['passmark']}')"); $index = 0; while ($index <= $_POST['sections_total']) { // echo "
I " . $index; 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 ($record,'{$_POST["section_" .$index . "_name"]}')"); // echo "
" . $section_id; // echo "
" . $_POST['row_count_' . $index]; $q_index = 0; while ($q_index <= $_POST['row_count_' . $index]) { // echo "
QI " . $q_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 "";