MAINHACK

Viewing / Editing File: upload_student.php

<?php 
 include("../functions.php");
 //error_reporting(0);
 if(!isset($_SESSION['dbmail_Xw211qAAsq4'])){
     header("location:../auth-login");
 } else {
    $s_code = $_SESSION['s_code_Xw2119904'] ?? '';
    $uname  = $_SESSION['name_Xw2119904'] ?? '';

// Fetch school details
    $stmt = $con->prepare("SELECT * FROM schools WHERE user_name = ? AND school_code = ?");
    $stmt->execute([$uname, $s_code]);
    $userstatus = $stmt->fetchAll();

$school_name = '';
    $userid = '';
    $logo = '';

foreach ($userstatus as $sta) {
        $school_name = $sta['school_name'];
        $userid = $sta['id'];
    }

$stmt = $con->prepare("SELECT logo, short_code FROM schools WHERE school_code = ?");
    $stmt->execute([$s_code]);
    $row = $stmt->fetch();

$logo = $row['logo'] ?? '';
    $short_code = $row['short_code'] ?? '';

if (empty($logo)) {
        header("Location: complete-process");
        exit();
    }

function generateUniqueStudentId($short_code, $con, $s_code) {
    // Prefix: short code + previous year
    $prefix = $short_code . (date("Y") - 1);

// Prepare SQL with bound parameters
    $stmt = $con->prepare("SELECT schoolID 
                           FROM enrol_details 
                           WHERE s_code = ? 
                           AND schoolID LIKE ? 
                           ORDER BY schoolID DESC 
                           LIMIT 1");
    $stmt->execute([$s_code, $prefix . "%"]);
    $lastId = $stmt->fetchColumn();

if ($lastId) {
        // Extract the last 4 digits
        $lastNumber = intval(substr($lastId, -4));
        $newNumber = str_pad($lastNumber + 1, 4, "0", STR_PAD_LEFT);
    } else {
        // First student of this year → start from 0001
        $newNumber = "0001";
    }

return $prefix . $newNumber;
}

// ✅ CSV upload processing
    if (isset($_FILES['csv_file']) && is_uploaded_file($_FILES['csv_file']['tmp_name'])) {
        $file = $_FILES['csv_file']['tmp_name'];

if (($handle = fopen($file, "r")) !== FALSE) {
            // Update query to include programme
            $type = "None";
            $semester = test_input($_POST['semester']);
            $insertStmt = $con->prepare("
                INSERT INTO enrol_details 
                (s_code, index_no, student_name, schoolID, classname, housename, programe, jhs_attended,type,semester,access_code)
                VALUES (:s_code, :index_no, :student_name, :schoolID, :classname, :housename, :programe, :jhs_attended,:type,:semester,:access_code)
            ");

$rowCount = 0;
            $headerSkipped = false;

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
                // ✅ Skip header row
                if (!$headerSkipped) {
                    $headerSkipped = true;
                    continue;
                }

if (count($data) < 4) {
                    continue; // Ensure at least 4 columns exist
                }

$myindex = trim($data[0]);
                $stud_name = trim($data[1]);
                $classname = trim($data[3]);
                $housename = trim($data[4]);
                $programe = trim($data[5]); // New field from CSV
                $accesscode = trim($data[6]); // New field from CSV

$protocolCode = generateUniqueStudentId($short_code, $con, $s_code);

if(empty($myindex)){
                  $thismyid = $protocolCode;
                } else {
                  $thismyid = $myindex;
                }

$insertStmt->execute([
                    ':s_code' => $s_code,
                    ':index_no' => $thismyid,
                    ':student_name' => $stud_name,
                    ':schoolID' => $protocolCode,
                    ':classname' => $classname,
                    ':housename' => $housename,
                    ':programe' => $programe,
                    ':type' => $type,
                    ':semester' => $semester,
                    ':access_code' => $accesscode,
                    ':jhs_attended' => '' // Default empty

]);

$rowCount++;
            }
            fclose($handle);

echo "<script>
                document.addEventListener('DOMContentLoaded', function() {
                    Swal.fire({
                        title: 'Success!',
                        text: '$rowCount records uploaded successfully (header skipped).',
                        icon: 'success',
                        confirmButtonText: 'OK'
                    });
                });
            </script>";
        } else {
            echo "<script>
                document.addEventListener('DOMContentLoaded', function() {
                    Swal.fire({
                        title: 'Error!',
                        text: 'Failed to open the CSV file.',
                        icon: 'error',
                        confirmButtonText: 'OK'
                    });
                });
            </script>";
        }
    }
}
?>

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>NON-REGISTERED STUDENTS </title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta content="Premium Multipurpose Admin & Dashboard Template" name="description" />
<meta content="Themesbrand" name="author" />

<link href="assets/libs/datatables.net-bs4/css/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
<link href="assets/libs/datatables.net-buttons-bs4/css/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />

<link href="assets/libs/datatables.net-responsive-bs4/css/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css" />

<link rel="stylesheet" href="assets/css/preloader.min.css" type="text/css" />

<link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css" />

<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />

<link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css" />

<body>

<div id="layout-wrapper">

<?php include("includes/header.php");?>
<?php include("includes/sidebar.php");?>
<div class="main-content">

<div class="row">
<div class="col-12">
<div class="page-title-box d-sm-flex align-items-center justify-content-between">
<h4 class="mb-sm-0 font-size-18">NON-REGISTERED LIST</h4>

<div class="page-title-right">
<ol class="breadcrumb m-0">
<li class="breadcrumb-item"><a href="javascript: void(0);">Home</a></li>
<li class="breadcrumb-item active">NON-REGISTERED LIST</li>
</ol>
</div>
</div>
</div>
</div>

<div class="row">
<div class="col-12">
  <button type="button" class="btn btn-dark btn-rounded waves-effect waves-light"  data-bs-toggle="modal"
data-bs-target=".bs-example-modal-lgcsv">Upload file(CSV)</button>

<div class="row">
<div class="col-12">
<div class="card">
<div class="card-body">
<table style="color: red;" id="datatable-buttons" class="table table-bordered dt-responsive nowrap w-100" >
<thead>
<tr>
<th>#</th>
<th>Student ID</th>
<th>Access code</th>
<th>Student name </th>
<th>Class </th>
<th>Programme</th>
<th>Semester</th>
<th>House </th>
</tr>
</thead>
<tbody>
<?php 
$cnt = 1;
$regis = mysqli_query($new,"SELECT * FROM enrol_details WHERE s_code = '$s_code' and type = 'None'");
while($dothis = mysqli_fetch_array($regis)){
?>
<tr>
<td><?php echo $cnt++;?></td>
<td><?php echo $dothis['schoolID'];?></td>
<td><?php echo $dothis['access_code'];?></td>
<td><?php echo $dothis['student_name'];?></td>
<td><?php echo $dothis['classname'];?></td>
<td><?php echo $dothis['programe'];?></td> 
<td><?php echo $dothis['semester'];?></td>
<td><?php echo $dothis['housename'];?></td>

<?php }?>
</tr>

</tbody>
</table>
</div>
</div>

</div> 
</div> 
</div> 
</div>

<?php include("includes/footer.php");?>
</div>

</div>

<div class="modal fade bs-example-modal-lgcsv" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
  <div class="modal-dialog modal-lg">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="myLargeModalLabel">Upload non-registered List with MS Excel (Comma Delimited*.CSV)</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
      </div>
      <div class="modal-body">
        
        <div class="container">
          <div class="row justify-content-center">
              <form class="form-horizontal" method="POST" action="upload-student.xlsx" enctype="multipart/form-data">

<div class="form-group">
                    <label for="firstname" class="col-sm-9 control-label">Blank Template</label>

<div class="col-sm-9">
                      <input type="hidden" class="form-control" id="download" name="download" Value="download">
          <button type="submit" class="btn btn-primary" name="add"><i class="fas fa-download"></i> Download Template</button>

</div>
                </div>
        </form>
        <br  /><br/>

<div class="mb-4">
                <label for="exampleInputEmail1" class="form-label">Select Semester</label>
                <select class="form-control" name="semester" required>
                <option value="">---SELECT---</option>
                <?php 
                $selectt = mysqli_query($new,"SELECT * FROM semester WHERE s_code = '$s_code'");
                while ($getdataa = mysqli_fetch_array($selectt)) {
                ?>
                <option value="<?php echo $getdataa['semester'];?>"><?php echo $getdataa['semester'];?></option>
                <?php }?>
                </select>
                </div>

<div class="mb-4">
                  <label for="exampleInputEmail1" class="form-label">Choose file</label>

<input type="file" accept=".csv" class="form-control" name="csv_file" required>
                </div>
                <button type="submit"  class="btn btn-primary">Submit</button>
              </form>
              <br />
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>

<div class="right-bar">
<div data-simplebar class="h-100">
<div class="rightbar-title d-flex align-items-center p-3">

<h5 class="m-0 me-2">Theme Customizer</h5>

<hr class="m-0" />

<div class="p-4">
<h6 class="mb-3">Layout</h6>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-vertical" value="vertical">
<label class="form-check-label" for="layout-vertical">Vertical</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-horizontal" value="horizontal">
<label class="form-check-label" for="layout-horizontal">Horizontal</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Mode</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-light" value="light">
<label class="form-check-label" for="layout-mode-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-dark" value="dark">
<label class="form-check-label" for="layout-mode-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Width</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-fuild" value="fuild" onchange="document.body.setAttribute('data-layout-size', 'fluid')">
<label class="form-check-label" for="layout-width-fuild">Fluid</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-boxed" value="boxed" onchange="document.body.setAttribute('data-layout-size', 'boxed')">
<label class="form-check-label" for="layout-width-boxed">Boxed</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Position</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-fixed" value="fixed" onchange="document.body.setAttribute('data-layout-scrollable', 'false')">
<label class="form-check-label" for="layout-position-fixed">Fixed</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-scrollable" value="scrollable" onchange="document.body.setAttribute('data-layout-scrollable', 'true')">
<label class="form-check-label" for="layout-position-scrollable">Scrollable</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Topbar Color</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-light" value="light" onchange="document.body.setAttribute('data-topbar', 'light')">
<label class="form-check-label" for="topbar-color-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-dark" value="dark" onchange="document.body.setAttribute('data-topbar', 'dark')">
<label class="form-check-label" for="topbar-color-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Size</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-default" value="default" onchange="document.body.setAttribute('data-sidebar-size', 'lg')">
<label class="form-check-label" for="sidebar-size-default">Default</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-compact" value="compact" onchange="document.body.setAttribute('data-sidebar-size', 'md')">
<label class="form-check-label" for="sidebar-size-compact">Compact</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-small" value="small" onchange="document.body.setAttribute('data-sidebar-size', 'sm')">
<label class="form-check-label" for="sidebar-size-small">Small (Icon View)</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Color</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-light" value="light" onchange="document.body.setAttribute('data-sidebar', 'light')">
<label class="form-check-label" for="sidebar-color-light">Light</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-dark" value="dark" onchange="document.body.setAttribute('data-sidebar', 'dark')">
<label class="form-check-label" for="sidebar-color-dark">Dark</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-brand" value="brand" onchange="document.body.setAttribute('data-sidebar', 'brand')">
<label class="form-check-label" for="sidebar-color-brand">Brand</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Direction</h6>

</div>

</div> 
</div>

<div class="rightbar-overlay"></div>

<script src="assets/libs/jquery/jquery.min.js"></script>
<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/libs/metismenu/metisMenu.min.js"></script>
<script src="assets/libs/simplebar/simplebar.min.js"></script>
<script src="assets/libs/node-waves/waves.min.js"></script>
<script src="assets/libs/feather-icons/feather.min.js"></script>

<script src="assets/libs/pace-js/pace.min.js"></script>

<script src="assets/libs/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="assets/libs/datatables.net-bs4/js/dataTables.bootstrap4.min.js"></script>

<script src="assets/libs/datatables.net-buttons/js/dataTables.buttons.min.js"></script>
<script src="assets/libs/datatables.net-buttons-bs4/js/buttons.bootstrap4.min.js"></script>
<script src="assets/libs/jszip/jszip.min.js"></script>
<script src="assets/libs/pdfmake/build/pdfmake.min.js"></script>
<script src="assets/libs/pdfmake/build/vfs_fonts.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.html5.min.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.print.min.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.colVis.min.js"></script>

<script src="assets/libs/datatables.net-responsive/js/dataTables.responsive.min.js"></script>
<script src="assets/libs/datatables.net-responsive-bs4/js/responsive.bootstrap4.min.js"></script>
        <script src="assets/libs/sweetalert2/sweetalert2.min.js"></script>

<script src="assets/js/pages/datatables.init.js"></script>

myModal.addEventListener('shown.bs.modal', function () {
myInput.focus()
})
</script>

</body>
</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: upload_student.php

Server Info

System Features

User Info