";
echo "induction_date: " . $_POST['induction_date'] . "
";
echo "medical_date: " . $_POST['medical_date'] . "
";
echo "industry: " . $_POST['industry'];
echo "
";
echo "index: " . $_POST['index'] . "
";
echo "
";
$assessment_ids = '';
$assessments_list = [];
$index = 1;
$total = intval($_POST['index']); // total number of assessment fields
if (isset($_POST['assessments_' . $index])) {
while ($index <= $total) { // FIXED: run for all assessments
// check if assessment field exists
if (!isset($_POST['assessments_' . $index])) {
break; // exit if no more
}
// read assessment
$assessment = $_POST['assessments_' . $index];
echo "assessment: " . $assessment . "
";
$assessment_ids = $assessment_ids . $assessment . ',';
// add to array
// $assessments_list[] = $assessment; // FIXED: correct array push
// query
$assessments_res = $db->exec_query(
"assesses",
['*'],
'',
'',
'',
'',
"client_employees_id = {$_POST['client_employees_id']} AND results = 'C' AND assessments_id = '{$assessment}'",
'',
false
);
if ($assessments_res && $assessments_res->num_rows > 0) {
$ass = $assessments_res->fetch_assoc();
$db->Update(
'client_employees',
['induction_date', 'medical_date', 'industry'],
[$_POST['induction_date'], $_POST['medical_date'], $_POST['industry']],
"record_id = {$_POST['client_employees_id']}",
false
);
$client_id = $ass['client_employees_id']; // save for redirect later
}
$index++; // ALWAYS increase index
}
} else {
echo "No assessments found";
}
// $encoded = urlencode(json_encode($assessments_list));
echo "";