File Manager

✏️ Edit File: /home/coemyoza/results.coeminna.edu.ng/rms/insert_csv_data_1.php

<?php include('../data/db.php');
// loadcsv.php
//if ($_FILES['csvfile']['error'] === UPLOAD_ERR_OK) {
$tempFile = $_FILES['csvfile']['tmp_name'];
// Process the uploaded file (e.g., insert into database)
// ...
$code = $_POST["code"];
$title = $_POST["title"];  /*
$unit = $_POST["unit"];
$programme = $_POST['programme'];
$level = $_POST['level'];
$courselevel = $_POST['courselevel'];*/

$session = $conf_session;
$semester = $conf_semester;
//$tempFile = $_FILES['csvfile']['tmp_name'];
$fname = $_FILES['csvfile']['name'];
echo 'Uploaded file name: ' . $fname . ' ';

$chk_ext = explode(".", $fname);
if (strtolower(end($chk_ext)) == "csv") {
    $snr = 0;
    $filename = $_FILES['csvfile']['tmp_name'];
    $handle = fopen($filename, "r");
    $handle2 = fopen($filename, "r");

echo '
    <table class="table">
        <tr>
        <td>#</td>
        <td>Matno</td>
        <td>CA</td>
        <td>Exam</td>
        <td>Score</td>
        <td>Grade</td>
        </tr>';
    $allScoresValid = true;

while (($row = fgetcsv($handle, 10000, ",")) !== false) {
        //echo "<script>alert('y')</script>";
        $studentId = $row[0];
        $caScore = floatval($row[1]);
        $examScore = floatval($row[2]);

$totalScore = $caScore + $examScore;
        if ($totalScore > 100) {
            $allScoresValid = false;
            echo "Scores for Student ID $studentId cannot be added. Total score exceeds 100.<br>";
        }
    }

if ($allScoresValid) {
        //  echo "<script>alert('y')</script>";
        while (($data = fgetcsv($handle2, 10000, ",")) !== false) {
            $snr++;
            $ca = trim($data[1]);
            $exam = trim($data[2]);
            $score_sum = $ca + $exam;
            $score = $score_sum;
            $matno = trim($data[0]);

// get students names from table
            $stdqry = $pdo->prepare("SELECT `courseunit`, `level`, `courselevel`, `programme`, `coursetitle` FROM `stu_course_reg` WHERE `matno` LIKE ? AND `coursecode` LIKE ? AND `session` LIKE ?");
            $stdqry->execute([$matno, $code, $session]);
            $stdrows = $stdqry->fetch();

$unit = $stdrows["courseunit"];
            $level = $stdrows["level"];
            $courselevel = $stdrows["courselevel"];
            $programme = $stdrows["programme"];
            $title = $stdrows["coursetitle"];
            // if($stdqry->rowCount() == 0)
            // {}
            //$score = $scores[$sn];
            include("scoregrade.php");
            $point = $n[$grade1];
            $gp = $point * $unit;
            $cunit = ($score == 'AE') ? 0 : $unit;

//chck if course has been registered in the current session
            $ifexst = $pdo->prepare("SELECT * FROM `stu_course_reg` WHERE `matno` = ? AND `coursecode` = ? AND `session` = ?");
            $ifexst->execute([$matno, $code, $conf_session]);

//chck if course has been registered in previous session
            $ifexstp = $pdo->prepare("SELECT * FROM `stu_course_reg` WHERE `matno` = ? AND `coursecode` = ? AND `session` <> ?");
            $ifexstp->execute([$matno, $code, $conf_session]);

$fsp = $ifexstp->fetch();
            if ($score >= 40) {
                $passed = 1;
            } else {
                $passed = 0;
            }
            if ($ifexst->rowCount() > 0) {

$qry = $pdo->prepare("UPDATE `stu_course_reg` SET  `courseunit` = ?, `cunit` = ?, `ca` = ?, `exam` = ?, `score` = ?, `grade` = ?, `points` = ?, `gp` = ?, `passed` = ? WHERE `matno` = ? AND `coursecode` = ? AND `session` = ?");
                $qry->execute([$unit, $cunit, $ca, $exam, $score, $grade1, $point, $gp, $passed, $matno, $code, $session]);
                $msg = "Records Updated";
            }

if ($ifexstp->rowCount() > 0) {

$scoretype = 1; // add a condition that check if the score is pass mark before updating to 1
                $qryU = $pdo->prepare("UPDATE `stu_course_reg` SET `scoretype` = ?, `co_session` = ?, `passed` = ? WHERE `matno` = ? AND `coursecode` = ? AND `session` != ?");
                $qryU->execute([$scoretype, $conf_session, $passed, $matno, $code, $conf_session]);
                $msg =  "Records Updated";
            }

echo '<tr>
                <td>' . $snr . '</td>
                <td>' . $matno . '</td>
                <td>' . $ca . '</td>
                <td>' . $exam . '</td>
                <td>' . $score . '</td>
                <td>' . $grade1 . '</td>';
    }
    }
    echo '
</tr>
</table>';
    echo "<span style='color:red; font-size:10pt;'>" . $snr . " Students Scores uploaded successfully!</span>";

} else {
    echo "
        <div class='alert alert-danger'>Invalid file, only .csv file is valid....</div>";
}

Batal

⬅ Naik ke results.coeminna.edu.ng 100 item

Nama	Tipe	Ukuran	Diubah	Aksi
📄.DS_Store	ds_store	12 KB	2024-11-24 15:35	✏️ Edit 👁️ View
📄.htaccess	htaccess	308 B	2024-04-20 12:46	✏️ Edit 👁️ View
🐘Untitled-1.php	php	13.5 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘add-staff.php	php	12.7 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘add_course.php	php	7.7 KB	2025-03-20 15:44	✏️ Edit 👁️ View
🐘add_scores.php	php	7.7 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘add_user.php	php	7.2 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🖼️addimage.jpeg	jpeg	5.8 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘allocat_page.php	php	11.3 KB	2025-10-20 07:27	✏️ Edit 👁️ View
🐘allocate_c.php	php	4.8 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘analyzer.php	php	5.1 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘broadsheet.php	php	616 B	2024-11-24 15:35	✏️ Edit 👁️ View
🐘broadsheet_content2.php	php	2.7 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘broadsheet_content3.php	php	3.7 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘broadsheet_contents.php	php	2.6 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘broadsheet_final.php	php	12 KB	2024-11-24 15:35	✏️ Edit 👁️ View
📊course_sample.csv	csv	89 B	2025-03-20 12:48	✏️ Edit 👁️ View
🐘cpgpas.php	php	15.1 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘cpgpas1.php	php	1.6 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘cpgpas_latest.php	php	10.6 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘dash.php	php	89.5 KB	2025-03-09 13:36	✏️ Edit 👁️ View
🐘dashboard.php	php	84.1 KB	2025-09-19 08:22	✏️ Edit 👁️ View
🐘download_csv.php	php	1.6 KB	2025-06-15 21:31	✏️ Edit 👁️ View
🐘download_csv_mis.php	php	2 KB	2025-06-15 21:31	✏️ Edit 👁️ View
🐘download_scores.php	php	1.6 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘download_scores_ext.php	php	7.3 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘download_scores_pdf.php	php	6.3 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘download_scores_pdf_mis.php	php	6.3 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘editcourse.php	php	5.3 KB	2025-02-11 08:15	✏️ Edit 👁️ View
🖼️editimage.jpeg	jpeg	18.2 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘editrecord.php	php	2.5 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘editscore.php	php	11.1 KB	2025-09-11 17:01	✏️ Edit 👁️ View
🐘entered_scores.php	php	6.6 KB	2024-11-24 15:35	✏️ Edit 👁️ View
📄error_log	file	847.5 KB	2026-04-16 16:59	✏️ Edit 👁️ View
🐘footer.php	php	1.4 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘form_a.php	php	3.9 KB	2025-07-28 21:21	✏️ Edit 👁️ View
🐘form_a1.php	php	7.8 KB	2025-12-05 22:24	✏️ Edit 👁️ View
🐘form_b.php	php	23.3 KB	2025-12-06 07:10	✏️ Edit 👁️ View
🐘form_b_in.php	php	11.9 KB	2025-06-29 17:57	✏️ Edit 👁️ View
🐘forma1_sample.php	php	6.6 KB	2025-12-06 07:10	✏️ Edit 👁️ View
🐘header.php	php	3.3 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘header2.php	php	5.1 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘import_results.php	php	11.4 KB	2025-05-18 07:05	✏️ Edit 👁️ View
🐘index.php	php	3.1 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘inputscore.php	php	23.3 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘insert_csv_data.php	php	10.9 KB	2025-06-14 15:42	✏️ Edit 👁️ View
🐘insert_csv_data_1.php	php	4.7 KB	2025-06-14 06:39	✏️ Edit 👁️ View
📜jquery-3.5.1.min.js	js	87.4 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘lecturers.php	php	3.6 KB	2025-05-27 22:49	✏️ Edit 👁️ View
🐘lfooter.php	php	1.3 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘lheader.php	php	4.8 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘listofcourses.php	php	1.6 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘loadcsv.php	php	3.1 KB	2024-11-26 20:28	✏️ Edit 👁️ View
🐘logdt.php	php	1.7 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🖼️logos.png	png	225.2 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘menus copy.php	php	6.1 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘menus.php	php	2.3 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘my_course.php	php	5.3 KB	2025-05-27 23:22	✏️ Edit 👁️ View
🐘old_transcript.php	php	9.2 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🌐profile.html	html	46.8 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘profile.php	php	14.8 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘registered_stnd_list.php	php	6 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘required_info.php	php	2 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘rest_student.php	php	7.5 KB	2025-01-28 21:45	✏️ Edit 👁️ View
🐘result.php	php	13.3 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘result_footer.php	php	4.6 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘result_header.php	php	15.3 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘result_page.php	php	20.6 KB	2026-02-26 17:04	✏️ Edit 👁️ View
🐘result_summary.php	php	12.5 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘result_top.php	php	1.3 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘resultpropt.php	php	15.6 KB	2025-12-06 07:00	✏️ Edit 👁️ View
🐘results_content.php	php	2 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘rmks.php	php	3.2 KB	2024-11-24 15:35	✏️ Edit 👁️ View
📊sample_results.csv	csv	88 B	2025-05-18 09:54	✏️ Edit 👁️ View
🌐samplecsv.html	html	1.7 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🖼️schoologo.png	png	225.2 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘score_add.php	php	2.2 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘score_child.php	php	7.3 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘score_consid.php	php	10.4 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘score_updt_s.php	php	2.9 KB	2025-09-11 16:42	✏️ Edit 👁️ View
🐘scoregrade.php	php	3.9 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘scoreopt.php	php	2.3 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘settings_up.php	php	1.9 KB	2025-09-11 17:51	✏️ Edit 👁️ View
🐘sheader.php	php	4.9 KB	2024-12-04 19:58	✏️ Edit 👁️ View
🐘signing.php	php	3.6 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘staffupload.php	php	6.4 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘stu_course_reg.php	php	18 KB	2025-04-15 14:43	✏️ Edit 👁️ View
🐘stu_course_reg1.php	php	18 KB	2025-09-19 07:23	✏️ Edit 👁️ View
🐘stu_transcripts.php	php	5.5 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘students.php	php	2.2 KB	2024-12-04 20:12	✏️ Edit 👁️ View
🐘studentsinfo.php	php	2.2 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘summary.php	php	3.8 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘tobeconsidered.php	php	862 B	2024-11-24 15:35	✏️ Edit 👁️ View
🐘top_cgpa.php	php	7.6 KB	2025-09-19 17:38	✏️ Edit 👁️ View
🐘update_config.php	php	1.1 KB	2024-11-26 15:40	✏️ Edit 👁️ View
🐘upload_scores.php	php	12.5 KB	2025-05-27 23:18	✏️ Edit 👁️ View
🐘uploadcourses.php	php	2.4 KB	2025-02-10 20:44	✏️ Edit 👁️ View
🐘uploadscore.php	php	2.5 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🖼️viewimage.jpeg	jpeg	15.7 KB	2024-11-24 15:35	✏️ Edit 👁️ View
🐘viewscore.php	php	10.3 KB	2024-04-20 12:46	✏️ Edit 👁️ View