MAINHACK

Viewing / Editing File: submitbyteacher.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'];

$stmt = $con->prepare("Select * from schools where school_code = ?");
$stmt->execute(array($s_code));
$row = $stmt->fetch();
$logo = $row['logo'];
    if(empty($logo)){
      header("Location:complete-process");
    } else {

if (isset($_POST['submit20'])) {
    $teachername = $_POST['teachername'] ?? '';
    $program_name = $_POST['program_name'] ?? '';
    $semester = $_POST['semester'] ?? '';

if ($program_name === 'All') {
        // Show all programmes for that teacher
        $sql = "SELECT * FROM student_result 
                WHERE s_code = ? 
                  AND teacher = ? 
                  AND term = ?
                ORDER BY rid DESC";
        $stmt = $new->prepare($sql);
        $stmt->bind_param("sss", $s_code, $teachername, $semester);
    } else {
        // Filter by specific programme
        $sql = "SELECT * FROM student_result 
                WHERE s_code = ? 
                  AND teacher = ? 
                  AND programme = ? 
                  AND term = ?
                ORDER BY rid DESC";
        $stmt = $new->prepare($sql);
        $stmt->bind_param("ssss", $s_code, $teachername, $program_name, $semester);
    }

$stmt->execute();
    $result = $stmt->get_result();
} else {
    // Default view (show all records for current teacher)
    // $sql = "SELECT * FROM student_result 
    //         WHERE s_code = ? 
    //         ORDER BY rid DESC";
    // $stmt = $new->prepare($sql);
    // $stmt->bind_param("s", $s_code);
    // $stmt->execute();
    // $result = $stmt->get_result();
}
}
}
?>

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Manage result </title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">

<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" />

.container {
    max-width: 950px;
    margin: auto;
    background: white;
    padding: 20px;
    border-radius: 8px;
    box-shadow: 0 2px 10px rgba(0, 0, 0, 0.1);
}

h1 {
    text-align: center;
    color: #333;
}

h2 {
    margin-top: 20px;
    color: #4CAF50;
}

.exam-form {
    margin-bottom: 20px;
    background-color: #f9f9f9;
    padding: 20px;
    border-radius: 8px;
    box-shadow: 0 2px 5px rgba(0, 0, 0, 0.1);
}

.exam-form label {
    display: block;
    margin: 10px 0 5px;
}

.exam-form input {
    width: calc(100% - 20px);
    padding: 10px;
    margin-bottom: 10px;
    border: 1px solid #ddd;
    border-radius: 4px;
}

.exam-form button {
    background-color: #4CAF50;
    color: white;
    border: none;
    padding: 10px;
    border-radius: 4px;
    cursor: pointer;
    transition: background-color 0.3s;
}

.exam-form button:hover {
    background-color: #45a049;
}

table {
    width: 100%;
    border-collapse: collapse;
    margin-top: 20px;
}

thead {
    background-color: #4CAF50;
    color: white;
}

th, td {
    border: 1px solid #ddd;
    padding: 12px;
    text-align: center;
    font-size: 16px;
}

th {
    position: sticky;
    top: 0; /* Keeps the header fixed when scrolling */
}

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

tbody tr:hover {
    background-color: #e8f5e9; /* Light green on hover */
}

tbody td {
    border: 1px solid #ddd;
    vertical-align: middle; /* Aligns text vertically center */
}

@media (max-width: 768px) {
    .search-form select, 
    .search-form button {
      width: 100% !important;
      margin-bottom: 10px;
    }
  }

.search-card {
    background: #fff;
    border-radius: 10px;
    box-shadow: 0 0 10px rgba(0,0,0,0.05);
    padding: 20px;
  }

</style>

</head>

<body>

<div id="layout-wrapper">

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

<div class="row">
<div class="col-12">
   
        <h1>Examination result teachers entry</h1>

<div class="container my-4">
  <div class="search-card">
    <form method="POST" class="search-form row g-2 justify-content-center align-items-center">
      
      
      <div class="col-md-3 col-sm-6">
        <select class="form-control" name="teachername" required>
          <option value="">--- SELECT TEACHER ---</option>
          <?php 
          $selectedTeacher = $_POST['teachername'] ?? '';
          $selectt = mysqli_query($new,"SELECT user_name FROM schools WHERE school_code = '$s_code' AND user_name != 'Admin'");
          while ($getdataa = mysqli_fetch_array($selectt)) {
              $teacher = $getdataa['user_name'];
              $isSelected = ($selectedTeacher == $teacher) ? 'selected' : '';
              echo "<option value='$teacher' $isSelected>$teacher</option>";
          }
          ?>
        </select>
      </div>

<div class="col-md-3 col-sm-6">
        <select class="form-control" name="program_name" required>
          <option value="">--- SELECT PROGRAMME ---</option>
          <option value="All" <?= (isset($_POST['program_name']) && $_POST['program_name'] == 'All') ? 'selected' : '' ?>>All</option>
          <?php 
          $selectedProgram = $_POST['program_name'] ?? '';
          $selectt = mysqli_query($new,"SELECT program_name FROM programme WHERE s_code = '$s_code'");
          while ($getdataa = mysqli_fetch_array($selectt)) {
              $program = $getdataa['program_name'];
              $isSelected = ($selectedProgram == $program) ? 'selected' : '';
              echo "<option value='$program' $isSelected>$program</option>";
          }
          ?>
        </select>
      </div>

<div class="col-md-3 col-sm-6">
        <select class="form-control" name="semester" required>
          <option value="">--- SELECT SEMESTER ---</option>
          <?php 
          $selectedSemester = $_POST['semester'] ?? '';
          $selectt = mysqli_query($new,"SELECT semester FROM semester WHERE s_code = '$s_code'");
          while ($getdataa = mysqli_fetch_array($selectt)) {
              $sem = $getdataa['semester'];
              $isSelected = ($selectedSemester == $sem) ? 'selected' : '';
              echo "<option value='$sem' $isSelected>$sem</option>";
          }
          ?>
        </select>
      </div>

<div class="col-md-2 col-sm-6 text-center">
        <button type="submit" name="submit20" class="btn btn-primary w-100">Search</button>
      </div>

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

<div class="col-12">
<div class="table-responsive">
  <table id="datatable-buttons" class="table table-bordered table-striped table-hover nowrap w-100">
    <thead class="table-dark text-center">
      <tr>
        <th>Student</th>
        <th>ID</th>
        <th>Programme</th>
        <th>Form</th>
        <th>Subject</th>
        <th>Class</th>
        <th>Exams</th>
        <th>Total</th>
        <th>Grading</th>
        <th>Remarks</th>
        <th>Academic</th>
        <th>Semester</th>
      </tr>
    </thead>
    <tbody>
      <?php
      if ($result->num_rows > 0) {
          while ($get = $result->fetch_assoc()) { ?>
              <tr>
                  <td><?= htmlspecialchars($get['student_name']); ?></td>
                  <td><?= htmlspecialchars($get['index_number']); ?></td>
                  <td><?= htmlspecialchars($get['programme']); ?></td>
                  <td><?= htmlspecialchars($get['form']); ?></td>
                  <td><?= htmlspecialchars($get['subject']); ?></td>
                  <td><?= htmlspecialchars($get['class_score']); ?></td>
                  <td><?= htmlspecialchars($get['exams_score']); ?></td>
                  <td><?= htmlspecialchars($get['total_score']); ?></td>
                  <td><?= htmlspecialchars($get['grading']); ?></td>
                  <td><?= htmlspecialchars($get['remarks']); ?></td>
                  <td><?= htmlspecialchars($get['academicyear']); ?></td>
                  <td><?= htmlspecialchars($get['term']); ?></td>
              </tr>
          <?php }
      } else { ?>
          <tr><td colspan="12" class="text-center text-danger">No records found.</td></tr>
      <?php } ?>
    </tbody>
  </table>
</div>
</div>

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

<?php include("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/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: submitbyteacher.php

Server Info

System Features

User Info