}
}
echo 'Updating `teacher` table ... ';
$q = $db->selectAll('htmldata');
$db->begin();
while ($row = $q->fetch_assoc()) {
$teacher = trim($row['teacher']);
if ($teacher) {
$teachers = preg_split('/ |，| (?![A-Z])/', $teacher);
foreach ($teachers as $i => $teacher) {
$teacher = trim(kana($teacher));
if ($teacher && $teacher !== '他') {
$db->insert('staff', array('name' => $teacher));
insertTeacher($db, $row['id'], $teacher, !$i);
}
}
}
$sub = $row['sub_teacher'];
$sub = kana($sub);
foreach (explode('・', $sub) as $teacher) {
$teacher = trim($teacher);
if ($teacher) {
$db->insert('staff', array('name' => $teacher));
insertTeacher($db, $row['id'], $teacher, FALSE);
}
}
echo "[30G[K{$row['id']}";
}
$db->commit();
$db->close();
echo " " . PRINT_OK . PHP_EOL;
$tmp1 = imagecreatetruecolor($newwidth1, $newheight1);
imagecopyresampled($tmp1, $src, 0, 0, 0, 0, $newwidth1, $newheight1, $width, $height);
if (!move_uploaded_file($fileTmpLoc, $file_path)) {
echo '<script language="javascript">
alert("ERROR: File not uploaded. Try again !!");
window.location="' . SERVER . '/profile";
</script>';
/** Remove the uploaded file from the PHP temp folder */
unlink($fileTmpLoc);
return;
}
$newIco = uniqid('') . md5($filename) . '_s.' . $fileext;
$icoImage = $target_dir . "ico/" . $newIco;
imagejpeg($tmp1, $icoImage, 100);
imagedestroy($tmp1);
insertTeacher($ID, $name, $phone, $email, $image, $gender, $date, $designation, $fileContents, $newIco);
}
} elseif (isset($_POST['addStudent'])) {
$name = $_POST['fullname'];
$dept = $_POST['editDept'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$gender = '';
if (isset($_POST['sex'])) {
$gender = $_POST['sex'];
}
$dob = $_POST['dob'];
$date = str_replace('/', '-', $dob);
$date = date('Y-m-d', strtotime($date));
$ID = $_POST['aiubID'];
$cgpa = 0.0;
