";
if (isset($_FILES['fileUpload'])) {
$file = strtolower($_FILES["fileUpload"]["name"]);
$type = strrchr($file, ".");
if (($type == ".csv")) {
$objFopen = fopen($_FILES["fileUpload"]["tmp_name"], 'r');
if ($objFopen) {
while (!feof($objFopen)) {
$tmp[] = fgetcsv($objFopen);
}
fclose($objFopen);
$sql = "SELECT * FROM rg_Curriculum WHERE curId = '" . $_REQUEST["curSelect"] . "'";
$link->query($sql);
$rsCur = $link->getnext();
echo "
***** นำเข้าข้อมูลรายวิชา " . $rsCur->curName . " ******
";
for ($i = 1; $i < count($tmp); $i++) {
$sql = "SELECT * FROM rg_CurriculumStructure WHERE csCurId = '" . $_REQUEST["curSelect"] . "' AND csSeq = '" . $tmp[$i][11] . "'";
$link->query($sql);
$rsCs = $link->getnext();
$sql = "INSERT INTO rg_Course VALUES ('','" . $tmp[$i][1] . "','" . $tmp[$i][2] . "','" . $tmp[$i][3] . "','" . $tmp[$i][4] . "','','','','','" . $tmp[$i][7] . "','" . $tmp[$i][8] . "','" . $tmp[$i][9] . "','" . $tmp[$i][8] . "','" . $tmp[$i][9] . "','" . $tmp[$i][10] . "','" . $tmp[$i][5] . "','Y','','" . $rsCs->csCdId1 . "','1',now(),'reg-tools',now(),'reg-tools')";
$link->query($sql);
$sql = "INSERT INTO rg_ProgramCourses VALUES ('" . $rsCs->csCurId . "','" . $rsCs->csCdId1 . "','" . $rsCs->csCdId2 . "','" . $link->last_insert_id() . "','C','C','Y')";
$link->query($sql);
echo " " . $i . ".บันทึกข้อมูลสำเร็จ -> " . $tmp[$i][1] . " " . $tmp[$i][3] . "
";
}
}
} else {
echo '
การอัพโหลดไม่สำเร็จ !!!
กรุณาอัพโหลดไฟล์ CSV เท่านั้น
';
}
}
} else {
?>