MAINHACK

Viewing / Editing File: myreport.php

<?php 
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_log('error_reporting', E_ALL);

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

// $indexx = mysqli_query($new,"SELECT * FROM enrol_details WHERE indexNo  = '$s_code'");
// $fetchsch = mysqli_fetch_array($indexx);
// $school_code = $fetchsch['s_code'];
// $student_name = $fetchsch['stud_name'];
// $access_code = $fetchsch['access_code'];
// $codeexpired = $fetchsch['codeexpired'];

// $today = date("Y-m-d");
// if(empty($access_code)){
//     header("location: buyreportcode");
// } elseif(!empty($access_code) AND $codeexpired < $today) {
//      header("location: buyreportcode");
//  }

$indexx = mysqli_query($new, "SELECT * FROM enrol_details WHERE index_no = '$s_code' and schoolID = '$schoolID'");
$fetchsch = mysqli_fetch_array($indexx);

$school_code   = $fetchsch['s_code'];
$student_name  = $fetchsch['stud_name'];
$access_code   = $fetchsch['access_code'];
$codeexpired   = $fetchsch['codeexpired'];

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

// Redirect if access code is missing or expired
if (empty($access_code) || $codeexpired < $today) {
    header("Location: buyreportcode");
    exit(); // Always exit after header redirect
}

//  $select_pay = mysqli_query($new,"SELECT * FROM resultpayment WHERE index_num = '$s_code' and s_code = '$school_code'");
//   $getpay = mysqli_fetch_array($select_pay);
//   $pstatus = $getpay['status'];

//   if(mysqli_num_rows($select_pay) < 1){
//      header("location:result-check-payment");

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

// if(isset($_POST['submit20'])){

//     $academic = test_input($_POST['academic']);
//     $semester = test_input($_POST['semester']);
// }

}

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Student Results</title>
    <style>
        /* General Styling */
        body {
            font-family: Arial, sans-serif;
            background-color: #f8f9fa;
            margin: 20px;
        }

h5 {
            margin-top: 10px;
            color: #555;
        }

/* Form Styling */
        .d-flex {
            display: flex;
            justify-content: space-between;
            align-items: center;
            margin-bottom: 20px;
            gap: 15px;
        }

.form-control {
            border: 1px solid #ced4da;
            border-radius: 5px;
            padding: 8px;
        }

/* Table Styling */
        table {
            width: 100%;
            border-collapse: collapse;
            background-color: white;
            box-shadow: 0px 0px 10px rgba(0, 0, 0, 0.1);
            margin-top: 20px;
        }

thead tr {
            background-color: #343a40;
            color: white;
        }

th, td {
            padding: 12px;
            text-align: center;
            border: 1px solid #dee2e6;
        }

th {
            font-weight: bold;
            font-size: 14px;
        }

tbody tr:nth-child(even) {
            background-color: #f2f2f2;
        }

tbody tr:hover {
            background-color: #e9ecef;
        }

/* Button Styling */
        .btn-primary {
            background-color: #007bff;
            border: none;
            color: white;
            padding: 10px 20px;
            border-radius: 5px;
            cursor: pointer;
        }

.btn-primary:hover {
            background-color: #0056b3;
        }
    </style>
</head>
<body>

<form method="POST" class="d-flex">
    <select class="form-control" name="academic" style="width: 30%;">
        <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" name="semester" required style="width: 20%;">
        <option value="">---SELECT---</option>
        <?php 
        $selectt = mysqli_query($new, "SELECT * FROM semester WHERE s_code = '$school_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 class="col-12">
    <h5>Index Number: <?php echo $my_index; ?></h5>
    <h5>Semester: <?php echo $semester; ?></h5>
    <h5>Academic Year: <?php echo $academic; ?></h5>

<table>
        <center><h3>RESULT TABLE</h3></center>
        <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</th>
                <th>GRADING</th>
                <th>REMARKS</th>
            </tr>
        </thead>
        <tbody>
            <?php

$query = "SELECT * FROM student_result WHERE index_number = '$my_index' AND term = '$semester' AND  TRIM(academicyear) = '$academic'";
//echo $query; 
$select = mysqli_query($new, $query) or die("SQL Error: " . mysqli_error($new));

while ($get = mysqli_fetch_array($select)) {
            ?>
            <tr>
                <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>

</body>
</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: myreport.php

Server Info

System Features

User Info