MAINHACK

Viewing / Editing File: veiwmyreport.php

<?php 
 include("functions.php");
 if(!isset($_SESSION['index_no78897498'])){
     header("location:index");
 } else {

$s_code = $_SESSION['index_no78897498'];
$schoolID =  $_SESSION['student_id0023894'];
$myschoolid =  $_SESSION['student_id0023894565'];
 $myschoolcode = $_SESSION['myschoolcode'];

$selectme = mysqli_query($new,"
    SELECT access_code, codeexpired, student_name, classname, schoolID,unique_student_code
    FROM enrol_details 
    WHERE (schoolID = '$schoolID' OR unique_student_code = '$myschoolid')  AND s_code = '$myschoolcode'
");

$getpay = mysqli_fetch_array($selectme);

$myname      = $getpay['student_name'];
$classname   = $getpay['classname'];
$access_code = $getpay['access_code'];
$codeexpired = $getpay['codeexpired'];

$today = date("Y-m-d");

// If expired → go to buy page
if (strtotime($codeexpired) < strtotime($today)) {
     header("Location: buyreportcode");
        exit();
}

}

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Dashboard | Online Admission Portal</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/admin-resources/jquery.vectormap/jquery-jvectormap-1.2.2.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" />

</style>
      <style>
    .report-card {
      border: 2px solid #555;
      border-radius: 12px;
      padding: 2rem;
      box-shadow: 0 0 10px rgba(0,0,0,0.05);
    }
    .record-badge {
      background-color: #dc3545;
      color: white;
      font-weight: bold;
    }
    .btn-generate {
      font-size: 1.2rem;
      padding: 0.75rem 1.5rem;
    }
    .dropdown-select {
      font-size: 1.1rem;
      padding: 0.75rem;
    }
  </style>
</head>

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

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

<div class="container py-5">
    <h3 class="text-center fw-bold mb-4">My Semester Report(s)</h3>

<div class="report-card bg-white mx-auto" style="max-width: 700px;">
    <div class="mb-3 text-center">
      <label for="semesterSelect" class="form-label fw-bold fs-5">
        Available Semester Report(s) <span class="text-danger">*</span>
      </label>
    </div>
<form method="POST" action="main"> 
    <div class="mb-4">
<?php

$stmt = $new->prepare("
    SELECT DISTINCT term, form, academicyear
    FROM student_result
    WHERE s_code = ? AND index_number = ?
    ORDER BY academicyear DESC, form ASC, term ASC
");

if (!$stmt) {
    // Fatal - prepare failed
    echo '<select class="form-select dropdown-select"><option value="">DB prepare error</option></select>';
    error_log('Prepare failed: ' . $new->error);
    exit;
}

$stmt->bind_param('ss', $myschoolcode, $schoolID);
$stmt->execute();

$result = $stmt->get_result();
echo '<select id="semesterSelect" name="semesterSelect" required class="form-select dropdown-select">';
echo '<option value="">Select</option>';

if ($result && $result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $form = $row['form'];
        $term = $row['term'];
        $academicyear = $row['academicyear'];
        $display = "{$form}/{$term} ({$academicyear})";
        $value = "{$form}-{$academicyear}-{$term}";
        echo '<option value="' . htmlspecialchars($value, ENT_QUOTES) . '">' . htmlspecialchars($display, ENT_QUOTES) . '</option>';
    }
} else {
    echo '<option value="">No records found</option>';
}

echo '</select>';
$stmt->close();
?>

</div>

<div class="text-center">
      <button type="submit" class="btn btn-success btn-generate">
        <i class="bi bi-file-earmark-text-fill me-2"></i>
        Generate Report
      </button>
    </div>
  </div>
  </form>
</div>
         
  </div>
</section>

<?php include("../admin/includes/footer.php");?>
</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/apexcharts/apexcharts.min.js"></script>

<script src="assets/libs/admin-resources/jquery.vectormap/jquery-jvectormap-1.2.2.min.js"></script>
<script src="assets/libs/admin-resources/jquery.vectormap/maps/jquery-jvectormap-world-mill-en.js"></script>

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

</body>

</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: veiwmyreport.php

Server Info

System Features

User Info