Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/demo.sigmacomputers.in/public_html/avatar_coupon/admin

Free Space:

4.08 TB

🔧 Quick Actions

✏️ Editing: studentslist.php

<?php include('header.php'); ?>

<?php if (!empty($user_permissions['view'])): ?>
<div class="main-content">

<div class="row">
                <div class="col-12">
                    <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                        <h4 class="mb-sm-0">Students</h4>
                        <div class="page-title-right">
                            <ol class="breadcrumb m-0">
                                <li class="breadcrumb-item"><a href="javascript: void(0);">Home</a></li>
                                <li class="breadcrumb-item active">Students</li>
                            </ol>
                        </div>
                    </div>

</div>
            </div>

<div class="row">
                <div class="col-lg-12">
                    <div class="card">
                        <div class="card-header">
                            <div class="row">
                                <h5 class="card-title mb-0 col-lg-10">Add Students</h5>
                                <div class="col-lg-2 text-end">
                                    <?php if (!empty($user_permissions['add'])): ?>
                                        <a href="addstudent.php" class="btn btn-success">Add New</a>
                                    <?php endif; ?>
                                </div><br>
                            </div>
                        </div>

<div class="card-body">
                            <div class="row">
                                <table id="scroll-horizontal" class="example table nowrap align-middle"
                                    style="width:100%">
                                    <thead>
                                        <tr>
                                            <th align="left">Sl. No</th>
                                            <th align="left">Reg No</th>
                                            <th align="left">Name</th>
                                            <th align="left">Class/Section</th>
                                            <th align="left">Contact No</th>
                                            <th align="left">Available Coupons</th>
                                            <th align="left">Available Snack Amt</th>
                                            
                                            <th align="left">Status</th>
                                            <th align="left">Action</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        $sql = "SELECT * FROM student WHERE delete_status = 0 && member_type = 1 ORDER BY student_id DESC";
                                        // $sql = "SELECT * FROM student AS s1 WHERE s1.delete_status = 0 AND s1.member_type = 1 AND NOT EXISTS ( SELECT 1 FROM student AS s2 WHERE s2.mobile_no = s1.mobile_no AND s2.member_type = 2
                                        //       AND s2.delete_status = 0 AND s2.ref_status_id = 1 ) ORDER BY s1.student_id DESC";
                                        $query = mysqli_query($con, $sql);
                                        $i = 1;

while ($row = mysqli_fetch_assoc($query)) {
                                        ?>
                                            <tr>
                                                <td><?php echo $i++; ?></td>
                                                <td><?php echo $row['student_regno']; ?></td>
                                                <td><?php echo $row['student_name']; ?></td>
                                                <td>
                                                    <?php
                                                    $class_id = $row['ref_class_id'];
                                                    $section_id = $row['ref_section_id'];

$class_query = mysqli_query($con, "SELECT class_name FROM class WHERE class_id = $class_id");
                                                    $class = mysqli_fetch_assoc($class_query);
                                                    $class_name = $class['class_name'] ?? '';

$section_query = mysqli_query($con, "SELECT section_name FROM section WHERE section_id = $section_id");
                                                    $section = mysqli_fetch_assoc($section_query);
                                                    $section_name = $section['section_name'] ?? '';

echo $class_name . '-' . $section_name;
                                                    ?>
                                                </td>
                                                <td><?php echo $row['mobile_no']; ?></td>
                                                <td class="text-center"><?php echo $row['coupon_balance'] ?? '0'; ?></td>
                                                <td class="text-center"><?php echo $row['snack_balance'] ?? '0'; ?></td>

<td>
                                                    <?php
                                                    $status_id = $row['ref_status_id'];
                                                    $status_query = mysqli_query($con, "SELECT status_name FROM status WHERE status_id = $status_id");
                                                    $status = mysqli_fetch_assoc($status_query);
                                                    $status_name = $status['status_name'] ?? 'N/A';

$btn_class = (strtolower($status_name) === 'disable') ? 'btn-danger' : 'btn-success';

echo '<button type="button" class="btn ' . $btn_class . '" disabled>'
                                                        . htmlspecialchars($status_name) . '</button>';
                                                    ?>

</td>

</tr>
                                        <?php
                                        }
                                        ?>

</tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
</div>

<?php else: 
    echo "<script>
            alert('You don\\'t have permission to access this page.');
            window.history.back();
          </script>";
    exit();
endif; ?>

<?php include "footer.php" ?>;

</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: studentslist.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation