MAINHACK

Viewing / Editing File: myclassmate.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 {

$myindex = $_SESSION['index_no78897498'];
$myschoolcode = $_SESSION['myschoolcode'];
$schoID = isset($_SESSION['schoolID_no3478897498']) ? mysqli_real_escape_string($new, $_SESSION['schoolID_no3478897498']) : null;

$sql = "SELECT c.cid AS class_id, c.class_name, 
               GROUP_CONCAT(CONCAT(e.index_no, ':', h.house_name) SEPARATOR ',') AS students
        FROM enrol_details e
        JOIN class c ON e.class_id = c.cid
        JOIN house h ON e.house_id = h.hid
        WHERE e.s_code = ?
        GROUP BY c.cid, c.class_name";

$stmt = mysqli_prepare($new, $sql);
mysqli_stmt_bind_param($stmt, "s", $myschoolcode); // 's' for string
mysqli_stmt_execute($stmt);
$studentD = mysqli_stmt_get_result($stmt);

if (!$studentD) {
    die("Query failed: " . mysqli_error($new));
}

// $sql = "SELECT c.cid AS class_id, c.class_name, GROUP_CONCAT(e.index_no) AS students,e.photo as photo
// FROM enrol_details e
// JOIN class c ON e.class_id = c.cid
// WHERE e.s_code = ?
// GROUP BY c.cid, c.class_name";

// $stmt = mysqli_prepare($new, $sql);
// mysqli_stmt_bind_param($stmt, "s", $myschoolcode); // 's' for string
// mysqli_stmt_execute($stmt);
// $studentD = mysqli_stmt_get_result($stmt);

// if (!$studentD) {
// die("Query failed: " . mysqli_error($new));
// }

}

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>My Classmate | Online Admission Portal</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">

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

.card-title {
    font-weight: 300;
}

.card {
    transition: transform 0.2s ease;
}
.card:hover {
    transform: scale(1.02);
}

</style>

</head>

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

<?php include("includes/sidebar.php");?>
                <br   /><br  /><br  /> <br   /><br  /><br  />
<div class="main-content p-4 bg-light min-vh-100">
    <div class="container">
        <div class="row row-cols-1 row-cols-sm-2 row-cols-md-3 g-4">
            <?php
            while ($getinfo = mysqli_fetch_array($studentD)) {
                $class_name = htmlspecialchars($getinfo['class_name']);
                $students = htmlspecialchars($getinfo['students']);
                $student_array = explode(',', $students);

foreach ($student_array as $student) {
                    list($index_no, $house_name) = explode(':', $student, 2);
            ?>
                    <div class="col">
                        <div class="card shadow-sm h-100 border-0 rounded-4">
                            
                            
                            <div class="card-body">
                                <h6 class="text-muted mb-1">Name</h6>
                                <h5 class="card-title mb-2"><?php echo htmlspecialchars($index_no); ?></h5>
                                <h6 class="text-muted mb-1">House Name</h6>
                                <p class="card-text"><?php echo htmlspecialchars($house_name); ?></p>
                            </div>
                            <div class="card-footer bg-white border-0 text-end">
                                <span class="badge bg-primary"><?php echo $class_name; ?></span>
                            </div>
                        </div>
                    </div>
            <?php
                }
            }
            ?>
        </div>
    </div>
    <?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: myclassmate.php

Server Info

System Features

User Info