MAINHACK

Viewing / Editing File: veiwmyreport.php

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

$myschoolcode = $_SESSION['myschoolcode'];
$schoolIDD = $_SESSION['student_id0023894'];

$selectme = mysqli_query($new,"
    SELECT access_code, codeexpired, student_name, classname, schoolID
    FROM enrol_details 
    WHERE schoolID = '$schoolIDD' 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">

<?php 
$code = $_SESSION['index_no78897498'];
$studentID = mysqli_query($new,"SELECT * FROM enrol_generic WHERE indexNo  = '$code'");
$stud = mysqli_fetch_array($studentID);
$getschol = $stud['s_code'];
$name  = $stud['stud_name'];
$programme = $stud['programme'];

$studentDD = mysqli_query($new,"SELECT * FROM enrol_details WHERE index_no = '$code' and s_code = '$myschoolcode'");
$getname  = mysqli_fetch_array($studentDD);
$myname = $getname['student_name'];

$stmt = $con->prepare("Select * from schools where school_code = ?");
$stmt->execute(array($myschoolcode));
$row = $stmt->fetch();
$logo = $row['logo'];
$school_name = $row['school_name'];

$studentD = mysqli_query($new,"SELECT * FROM enrol_details,class WHERE enrol_details.index_no = '$code' and enrol_details.class_id = class.cid");
$getinfo = mysqli_fetch_array($studentD);
$c_name = $getinfo['class_name'];
$classID   = $getinfo['cid'];
$pic = $getinfo['photo'];
$schoolID = $getinfo['schoolID'];

$classprog = mysqli_query($new,"SELECT * FROM programme,class WHERE class.program_id = programme.progid and  class.cid = '$classID'");
$getclassprogg = mysqli_fetch_array($classprog);
$programme = $getclassprogg['program_name'];

$file_download = mysqli_query($new,"SELECT * FROM school_file WHERE s_code = '$getschol' and file_name = 'PROSPECTUS'");
$PROS = mysqli_fetch_array($file_download);
$pros = $PROS['file'];

$file_download = mysqli_query($new,"SELECT * FROM school_file WHERE s_code = '$getschol' and file_name = 'UNDERTAKEN'");
$PROS = mysqli_fetch_array($file_download);
$undertaken = $PROS['file'];

$file_download = mysqli_query($new,"SELECT * FROM school_file WHERE s_code = '$getschol' and file_name = 'PROGRAMME'");
$PROS = mysqli_fetch_array($file_download);
$proGram = $PROS['file'];

$getHow = mysqli_query($new,"SELECT * FROM enrol_details,house WHERE enrol_details.house_id = house.hid and  enrol_details.index_no = '$s_code'");
$hname = mysqli_fetch_array($getHow);
$house_name = $hname['house_name'];
$mobile_num = $hname['mobile_num'];

?>
<center><h4><?php echo $school_name;?></h4></center>

<div class="container py-5">
  <h3 class="text-center fw-bold mb-4"><?php echo !empty($myname) ? $myname : $name; ?></h3>
    <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">
      <select id="semesterSelect" name="semesterSelect" required class="form-select dropdown-select">
    <option value="">Select</option>
    <?php 
    $getrecords = mysqli_query($new, "SELECT DISTINCT term, form, academicyear FROM student_result WHERE s_code = '$myschoolcode' AND index_number = '$schoolIDD'");
    while ($getresult = mysqli_fetch_array($getrecords)) {
        $form = $getresult['form'];
        $semester = $getresult['academicyear'];
        $term = $getresult['term'];
        $display = "$form/$term ($semester) ";
        $value = "$form-$semester-$term";
    ?>
        <option value="<?php echo htmlspecialchars($value);?>"> <?php echo htmlspecialchars($display); ?></option>
    <?php } ?>
</select>
    </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