$predata = NULL;
$predata['subjectID'] = $row['subjectID'];
$predata['name'] = $row['name'];
$data['subject'][] = $predata;
// $data['subject'][$row['subjectID']] = $row['name'];
}
}
$strSQL = sprintf("\n SELECT\n stu.studentID,\n stu.firstName,\n stu.lastName,\n stu.gradeYear\n FROM\n `student` stu\n WHERE\n gradeYear = '%s'\n ", mysql_real_escape_string($gradeYear));
$objQuery = mysql_query($strSQL);
if ($objQuery && mysql_num_rows($objQuery) > 0) {
while ($row = mysql_fetch_array($objQuery)) {
$predata = NULL;
$predata['studentID'] = $row['studentID'];
$predata['firstName'] = $row['firstName'];
$predata['lastName'] = $row['lastName'];
$predata['gradeYear'] = getGradeYearName($row['gradeYear']);
$data['data'][] = $predata;
foreach ($data['subject'] as $mval) {
foreach ($mval as $key => $val) {
if ($key == 'subjectID') {
$predata = NULL;
$data['isStuReg'][$row['studentID']][$val] = isStuReg($row['studentID'], $val, $term, $year);
}
}
}
}
} else {
$data['data'] = '';
$data['srtSQL'] = $strSQL;
}
echo json_encode($data);
<?php
$term = $_REQUEST['term'];
$year = $_REQUEST['year'];
$studentID = json_decode($_REQUEST['studentID']);
$data = $_REQUEST['data'];
if ($term && $year && $studentID && $data) {
$error = false;
foreach ($data as $key => $val) {
$objSubject = json_decode($val);
$subjectID = $objSubject->subjectID;
$objData = $objSubject->data;
foreach ($objData as $dkey => $dval) {
if ($dval) {
if (!isStuReg($studentID[$dkey], $subjectID, $term, $year)) {
$res = regStudent($studentID[$dkey], $subjectID, $term, $year);
if ($res === true) {
$success[$subjectID][] = $studentID[$dkey];
} else {
$error = true;
$fail[$subjectID][] = $studentID[$dkey];
$fail[$subjectID][$studentID[$dkey]][] = $res;
}
}
}
}
}
$result['success'] = $success;
$result['fail'] = $fail;
if ($error == false) {
$result['status'] = 'SUCCESS';
