Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/jkma.co.in/public_html

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: viewstudents.php

<?php
ob_start();
session_start();
include("includes/inall.php");

$heading = 'Student';
$limit = 100;
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$start = ($page - 1) * $limit;

$filters = [];
$where = "WHERE 1";

// Date filters
if (!empty($_GET['from_date'])) {
    $from = mysqli_real_escape_string($con, $_GET['from_date']);
    $where .= " AND DATE(s.created_at) >= '$from'";
    $filters[] = "from_date=$from";
}
if (!empty($_GET['to_date'])) {
    $to = mysqli_real_escape_string($con, $_GET['to_date']);
    $where .= " AND DATE(s.created_at) <= '$to'";
    $filters[] = "to_date=$to";
}

// Name filter
if (!empty($_REQUEST['name'])) {
    $pn = mysqli_real_escape_string($con, $_REQUEST['name']);
    $where .= " AND s.name LIKE '%$pn%'";
    $filters[] = "name=" . urlencode($pn);
}

// RFID filter
if (!empty($_REQUEST['idnoa'])) {
    $idno = mysqli_real_escape_string($con, $_REQUEST['idnoa']);
    $where .= " AND s.idno LIKE '%$idno%'";
    $filters[] = "idno=" . urlencode($idno);
}

// Mobile filter
if (!empty($_REQUEST['mobile'])) {
    $mobile = mysqli_real_escape_string($con, $_REQUEST['mobile']);
    $where .= " AND s.mobile LIKE '%$mobile%'";
    $filters[] = "mobile=" . urlencode($mobile);
}

// Class filter
if (!empty($_REQUEST['class'])) {
    $class = mysqli_real_escape_string($con, $_REQUEST['class']);
    $where .= " AND s.class='$class'";
    $filters[] = "class=" . urlencode($class);
}

// Session class restriction
if (!empty($_SESSION['tclass'])) {
    $tclass = $_SESSION['tclass'];
    $classesa = explode(",", $tclass);
    $classes = array_map(function($v){
        return "'" . trim($v) . "'";
    }, $classesa);
    
    $where .= " AND s.class IN (" . implode(",", $classes) . ")";
    $filters[] = "class=" . urlencode($tclass);
}

$filterQuery = implode("&", $filters);

// Activate / Deactivate
if (isset($_GET['activate'])) {
    $id = (int)$_GET['activate'];
    mysqli_query($con, "UPDATE students SET status = 1 WHERE id = $id");
    $_SESSION['success'] = "Record activated successfully.";
    header("Location: viewstudents.php");
    exit;
}

if (isset($_GET['deactivate'])) {
    $id = (int)$_GET['deactivate'];
    mysqli_query($con, "UPDATE students SET status = 0 WHERE id = $id");
    $_SESSION['success'] = "Record deactivated successfully.";
    header("Location: viewstudents.php");
    exit;
}

// Delete
if (isset($_GET['delete']) && is_numeric($_GET['delete'])) {
    $id = (int)$_GET['delete'];
    mysqli_query($con, "DELETE FROM students WHERE id = $id");
    $_SESSION['success'] = "Record deleted successfully.";
    header("Location: viewstudents.php");
    exit;
}

// ✅ Bulk Loyalty Point Update
if (isset($_POST['update_points']) && isset($_POST['idno']) && isset($_POST['points'])) {
    foreach ($_POST['idno'] as $index => $idno) {
        $idno = $idno;
        $points = $_POST['points'][$index];
        $dt = date("Y-m-d");
        // Overwrite existing points with new total
        //mysqli_query($con, "DELETE FROM points WHERE idno = '$idno'");
        if($points>0) {
            mysqli_query($con, "INSERT INTO points (idno, points, date, status) VALUES ('$idno', '$points', '$dt', '1')");
        }
       
    }
    $_SESSION['success'] = "Loyalty points updated successfully.";
    header("Location: viewstudents.php");
    exit;
}

// ✅ Fetch students + points in one query
$res = mysqli_query($con, "
    SELECT s.*, COALESCE(SUM(p.points), 0) AS total_points
    FROM students s
    LEFT JOIN points p ON s.idno = p.idno
    $where
    GROUP BY s.id
    ORDER BY s.id DESC
    LIMIT $start, $limit
");

// Count total records
$totalRes = mysqli_query($con, "SELECT COUNT(*) as total FROM students s $where");
$total = mysqli_fetch_assoc($totalRes)['total'];
$totalPages = ceil($total / $limit);

include("includes/headermain.php");
?>
<body>
    <div id="main-wrapper">
        <?php include("includes/header.php"); ?>
        <?php include("includes/leftmenu.php"); ?>
        <div class="page-wrapper">
            <div class="page-breadcrumb">
                <div class="row">
                    <div class="col-12 d-flex no-block align-items-center">
                        <h4 class="page-title">List of <?php echo $heading; ?>(s)</h4>
                    </div>
                </div>
            </div>
            <div class="container-fluid">
                <div class="row">
                    <div class="col-md-12">
                        <div class="card pd-20">
                            <form action="#" method="post">
                                <div class="form-group col-md-3 floatleft">
                                    <label class="col-form-label">By RFID</label>
                                    <input class="form-control" type="text" name="idnoa" value="<?php echo $_REQUEST['idnoa']; ?>" placeholder="By RFID">
                                </div>
                                <div class="form-group col-md-3 floatleft">
                                    <label class="col-form-label">By Name</label>
                                    <input class="form-control" type="text" name="name" value="<?php echo $_REQUEST['name']; ?>" placeholder="By Name">
                                </div>
                                <div class="form-group col-md-3 floatleft">
                                    <label class="col-form-label">By Mobile</label>
                                    <input class="form-control" type="text" name="mobile" value="<?php echo $_REQUEST['mobile']; ?>" placeholder="By Mobile">
                                </div>
                                <?php if($_SESSION['logtype']=="Superadmin") { ?>
                                    <div class="form-group col-md-3 floatleft">
                                        <label class="col-form-label">Class</label>
                                        <select class="form-control" name="class">
                                            <option value="">Select Class</option>
                                            <?php
                                            $resc=mysqli_query($con,"SELECT id,class FROM classes WHERE status='1' ORDER BY class");
                                            while($rowc=mysqli_fetch_object($resc)) {
                                            ?>
                                                <option value="<?php echo $rowc->class; ?>" <?php if($rowc->class==$_REQUEST['class']) echo 'selected'; ?>><?php echo $rowc->class; ?></option>
                                            <?php } ?>
                                        </select>
                                    </div>
                                <?php } if($_SESSION['logtype']!="Superadmin") { ?>
                                    <div class="form-group col-md-3 floatleft">
                                        <label class="col-form-label">Class</label>
                                        <select class="form-control" name="class">
                                            <option value="">Select Class</option>
                                            <?php
                                            foreach($classesa as $class) {
                                            ?>
                                                <option value="<?php echo $class; ?>" <?php if($class==$_REQUEST['class']) echo 'selected'; ?>><?php echo $class; ?></option>
                                            <?php } ?>
                                        </select>
                                    </div>
                                <?php } ?>    
                                <div class="cleaner"></div>
                                <div class="form-group col-md-12 mb-5">
                                    <button type="submit" class="btn btn-primary floatleft">Search</button>
                                    <button type="button" class="btn btn-primary ml-2 floatleft" onClick="showall('<?php echo basename(__FILE__); ?>');">Show All</button>
                                    <?php if($_SESSION['logtype']=="Superadmin") { ?>
                                        <button type="button" class="btn btn-primary ml-2 floatleft" onClick="location.href='exportstudents.php?idno=<?php echo $_REQUEST['idno']; ?>&name=<?php echo $_REQUEST['name']; ?>&mobile=<?php echo $_REQUEST['mobile']; ?>&class=<?php echo $_REQUEST['class']; ?>'">Export</button>
                                    <?php } ?>  
                                </div>
                            </form>	
                            
                            <?php if (isset($_SESSION['success'])): ?>
                                <div class="alert alert-success"><?php echo htmlspecialchars($_SESSION['success']); ?></div>
                                <?php unset($_SESSION['success']); ?>
                            <?php elseif (isset($_SESSION['error'])): ?>
                                <div class="alert alert-danger"><?php echo htmlspecialchars($_SESSION['error']); ?></div>
                                <?php unset($_SESSION['error']); ?>
                            <?php endif; ?>

<form method="post" action="#">
                                <div class="table-responsive">
                                    <table class="table">
                                        <thead class="text-uppercase bg-primary">
                                            <tr class="text-white">
                                                <th>Sl.</th>
                                                <th>Date</th>
                                                <th>Name</th>
                                                <th>Mobile</th>
                                                <th>Email</th>
                                                <th>Adm.No</th>
                                                <th>RollNo</th>
                                                <th>RFID</th>
                                                <th>Loyalty</th>
                                                <th>Options</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            $sl = $start + 1;
                                            while ($row = mysqli_fetch_assoc($res)) {
                                                $rowClass = $row['status'] == 0 ? 'table-danger' : '';
                                            ?>
                                                <tr class="<?php echo $rowClass; ?>">
                                                    <td><?php echo $sl++; ?></td>
                                                    <td><?php echo dtconvert($row['created_at']); ?></td>
                                                    <td><strong><?php echo htmlspecialchars($row['name']); ?></strong><br>(<?php echo htmlspecialchars($row['class']); ?>)</td>
                                                    <td><?php echo htmlspecialchars($row['mobile']); ?></td>
                                                    <td><?php echo htmlspecialchars($row['email']); ?></td>
                                                    <td><?php echo htmlspecialchars($row['admno']); ?></td>
                                                    <td><?php echo htmlspecialchars($row['rollno']); ?></td>
                                                    <td><strong><?php echo htmlspecialchars($row['idno']); ?></strong></td>
                                                    <td>
                                                        <strong><?php echo $row['total_points']; ?></strong>
                                                    </td>
                                                    <td>
                                                        <input type="hidden" name="idno[]" value="<?php echo $row['idno']; ?>">
                                                        <input type="number" name="points[]" class="form-control" <?php if($_SESSION['logtype']=="Teacher") { ?>max=<?php print $_SESSION['maxpoint']; } ?> style="width:90px;margin-bottom:10px;">
                                                        <?php if($_SESSION['logtype']=="Superadmin") { ?>
                                                            <a href="addstudent.php?edit=<?php echo $row['id']; ?>" class="btn btn-sm btn-info">Edit</a>&nbsp;
                                                            <a href="?delete=<?php echo $row['id']; ?>" class="btn btn-sm btn-danger" onclick="return confirm('Delete this?')">Delete</a>&nbsp;
                                                            <?php if ($row['status'] == 1): ?>
                                                                <a href="?deactivate=<?php echo $row['id']; ?>" class="btn btn-sm btn-warning">Deactivate</a>
                                                            <?php else: ?>
                                                                <a href="?activate=<?php echo $row['id']; ?>" class="btn btn-sm btn-success">Activate</a>
                                                            <?php endif; ?>
                                                        <?php } ?>    
                                                        
                                                    </td>
                                                </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>

<?php //if($_SESSION['logtype']=="Superadmin") { ?>
                                        <button type="submit" name="update_points" class="btn btn-success mt-2">Update Points</button>
                                    <?php //} ?>
                                </div>
                            </form>

<?php if ($totalPages > 1): ?>
                                <nav>
                                    <ul class="pagination">
                                        <?php for ($i = 1; $i <= $totalPages; $i++): ?>
                                            <li class="page-item <?php echo $i == $page ? 'active' : '' ?>">
                                                <a class="page-link" href="?<?php echo $filterQuery ?>&page=<?php echo $i ?>"><?php echo $i ?></a>
                                            </li>
                                        <?php endfor; ?>
                                    </ul>
                                </nav>
                            <?php endif; ?>
                        </div>
                    </div>
                </div>
            </div>
            <?php include("includes/footer.php"); ?>
        </div>
    </div>

<script src="assets/libs/jquery/dist/jquery.min.js"></script>
    <script src="assets/libs/popper.js/dist/umd/popper.min.js"></script>
    <script src="assets/libs/bootstrap/dist/js/bootstrap.min.js"></script>
    <script src="assets/libs/perfect-scrollbar/dist/perfect-scrollbar.jquery.min.js"></script>
    <script src="assets/extra-libs/sparkline/sparkline.js"></script>
    <script src="dist/js/waves.js"></script>
    <script src="dist/js/sidebarmenu.js"></script>
    <script src="dist/js/custom.min.js"></script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewstudents.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation