MAINHACK

Viewing / Editing File: myreport.php

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

$indexx = mysqli_query($new,"SELECT * FROM enrol_generic WHERE indexNo  = '$s_code'");
$fetchsch = mysqli_fetch_array($indexx);
$school_code = $fetchsch['s_code'];

$select_pay = mysqli_query($new,"SELECT * FROM stud_payment WHERE indexNumber = '$s_code' and s_code = '$school_code'");
  $getpay = mysqli_fetch_array($select_pay);
  $pstatus = $getpay['pstatus'];

if(mysqli_num_rows($select_pay) < 1){
     header("location:makepayment");

} elseif (mysqli_num_rows($select_pay) > 0 and $pstatus == 'pending' ) {
  header("location:payment-pending");
  } else {

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Dashboard | My Report</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" />

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

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

<div class="container mt-4">
    
    <div class="d-flex align-items-center">
        
        <button type="button" style="width:200px" class="btn btn-dark btn-rounded waves-effect waves-light me-3" 
            data-bs-toggle="modal" data-bs-target=".bs-example-modal-lgcsv">Upload student result</button>

<form method="POST" class="d-flex">

<select class="form-control me-2" name="academic" style="width: 400px;">
        <option value="">---ACADEMIC YEAR---</option>
        <option value="2024/2025">2024/2025</option>
        <option value="2025/2026">2025/2026</option>
        <option value="2026/2027">2026/2027</option>
        <option value="2027/2028">2027/2028</option>
        </select>

<select class="form-control me-2" name="myindexno" style="width: 400px;">
        <option value="">--STUDENT INDEX--</option>
        <?php 
        $homee = mysqli_query($new, "SELECT * FROM enrol_details WHERE s_code = '$s_code'");
        if ($homee) {
            while ($gethousee = mysqli_fetch_array($homee)) {
                echo "<option value='" . $gethousee['index_no'] . "'>" . $gethousee['index_no'] . "</option>";
            }
        } else {
            echo "Error: " . mysqli_error($new); // Debug SQL error
        }
        ?>
    </select>

<select class="form-control me-2" 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>

<button type="submit" name="submit20" class="btn btn-primary">Search</button>
</form>
</div>
</div>

<div class="col-12">
    <h5>Index number : <?php echo $myindexno;?> </h5>
    <h5>Semester : <?php echo $semester;?></h5>
    <h5>Academic Year : <?php echo $academic;?></h5>
 <table>
    <thead>
        <tr>
            <th>SUBJECTS</th>
            <th>CLASS SCORE<br>30%</th>
            <th>EXAM SCORE<br>70%</th>
            <th>TOTAL SCORE<br>100%</th>
            <th>POSITION IN SUBJECT</th>
            <th>GRADING</th>
            <th>REMARKS</th>
        </tr>
    </thead>
    <tbody>
        <tr>
 <?php 
            $cnt = 1;
            $select = mysqli_query($new,"SELECT * FROM  student_result WHERE index_number = '$myindexno' and term  = '$semester'");
            while($get = mysqli_fetch_array($select)){
            ?>
            <td><?php echo $get['subject'];?></td>
            <td><?php echo $get['class_score'];?></td>
            <td><?php echo $get['exams_score'];?></td>
            <td><?php echo $get['total_score'];?></td>
            <td><?php echo $get['position'];?></td>
            <td><?php echo $get['grading'];?></td>
            <td><?php echo $get['remarks'];?></td>
        </tr>
    <?php }?>
    
    </tbody>
</table>

</div>

<div class="right-bar">

<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>
<?php } }?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: myreport.php

Server Info

System Features

User Info