Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.84.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u176134211

Directory:

/home/u176134211/domains/digitalraj.in/public_html/dashboard

Free Space:

8.29 TB

🔧 Quick Actions

✏️ Editing: my_qrs.php

<?php
// /public_html/dashboard/my_qrs.php
session_start();
require '../config/db_connect.php';

// 1. AUTH CHECK
if (!isset($_SESSION['user_id'])) { header("Location: ../login.php"); exit(); }
$user_id = $_SESSION['user_id'];

// 2. HANDLE DELETE
if (isset($_GET['delete'])) {
    $del_id = intval($_GET['delete']);
    // Verify ownership before deleting
    $stmt = $conn->prepare("DELETE FROM qrcodes WHERE id = ? AND user_id = ?");
    $stmt->bind_param("ii", $del_id, $user_id);
    if ($stmt->execute()) {
        $msg = "QR Code deleted successfully.";
    }
}

// 3. FETCH USER QRS
$qrs = $conn->query("SELECT * FROM qrcodes WHERE user_id = $user_id ORDER BY created_at DESC");
?>

<?php include '../includes/header.php'; ?>

<div class="container mt-4">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <div>
            <h2 class="fw-bold mb-0">My QR Codes</h2>
            <p class="text-muted mb-0">Manage and track your dynamic links.</p>
        </div>
        <a href="create_qr.php" class="btn btn-primary btn-lg shadow-sm">
            <i class="bi bi-plus-lg"></i> Create New
        </a>
    </div>

<?php if(isset($msg)) echo "<div class='alert alert-success alert-dismissible fade show'>$msg <button type='button' class='btn-close' data-bs-dismiss='alert'></button></div>"; ?>

<div class="row">
        <?php if ($qrs->num_rows > 0): ?>
            <?php while($qr = $qrs->fetch_assoc()): 
                // Construct URLs
                $protocol = isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? "https://" : "http://";
                $short_url = $protocol . $_SERVER['HTTP_HOST'] . "/" . $qr['short_code'];
                $qr_image_url = "https://api.qrserver.com/v1/create-qr-code/?size=300x300&data=" . urlencode($short_url);
            ?>
            <div class="col-md-6 col-lg-4 mb-4">
                <div class="card shadow-sm h-100 border-0">
                    <div class="card-body">
                        <div class="d-flex align-items-start">
                            <div class="me-3 bg-light p-2 rounded border" style="width: 100px; height: 100px;">
                                <img src="<?php echo $qr_image_url; ?>" class="img-fluid" alt="QR Preview">
                            </div>
                            
                            <div class="flex-grow-1 overflow-hidden">
                                <h5 class="card-title fw-bold text-truncate mb-1">
                                    <?php echo htmlspecialchars($qr['name']); ?>
                                </h5>
                                <div class="mb-2">
                                    <a href="<?php echo $short_url; ?>" target="_blank" class="text-decoration-none small text-primary text-truncate d-block">
                                        <i class="bi bi-link-45deg"></i> <?php echo $short_url; ?>
                                    </a>
                                </div>
                                
                                <div>
                                    <?php if($qr['status'] == 'active'): ?>
                                        <span class="badge bg-success bg-opacity-10 text-success border border-success">Active</span>
                                    <?php else: ?>
                                        <span class="badge bg-danger bg-opacity-10 text-danger border border-danger">Paused</span>
                                    <?php endif; ?>

<?php if($qr['lead_gen_active']): ?>
                                        <span class="badge bg-warning bg-opacity-10 text-dark border border-warning" title="Lead Gate Active">
                                            <i class="bi bi-key-fill"></i> Locked
                                        </span>
                                    <?php endif; ?>
                                </div>
                            </div>
                        </div>

<div class="d-flex justify-content-between align-items-center mt-3 bg-light p-2 rounded">
                            <div class="text-center w-50 border-end">
                                <h5 class="mb-0 fw-bold"><?php echo $qr['total_scans']; ?></h5>
                                <small class="text-muted" style="font-size: 0.75rem;">TOTAL SCANS</small>
                            </div>
                            <div class="text-center w-50">
                                <h5 class="mb-0 fw-bold"><?php echo date('M d', strtotime($qr['created_at'])); ?></h5>
                                <small class="text-muted" style="font-size: 0.75rem;">CREATED</small>
                            </div>
                        </div>

<div class="mt-3 d-grid gap-2">
                            <div class="btn-group" role="group">
                                <a href="edit_qr.php?id=<?php echo $qr['id']; ?>" class="btn btn-outline-primary">
                                    <i class="bi bi-pencil-square"></i> Edit
                                </a>
                                <button onclick="copyToClipboard('<?php echo $short_url; ?>')" class="btn btn-outline-secondary">
                                    <i class="bi bi-clipboard"></i> Copy
                                </button>
                                <a href="<?php echo $qr_image_url; ?>" download="qr_<?php echo $qr['short_code']; ?>.png" class="btn btn-outline-dark">
                                    <i class="bi bi-download"></i> PNG
                                </a>
                            </div>
                            <a href="?delete=<?php echo $qr['id']; ?>" class="btn btn-sm btn-outline-danger border-0" onclick="return confirm('Are you sure? This cannot be undone.');">
                                <i class="bi bi-trash"></i> Delete QR Code
                            </a>
                        </div>

</div>
                </div>
            </div>
            <?php endwhile; ?>
        <?php else: ?>
            <div class="col-12 text-center py-5">
                <div class="mb-3">
                    <i class="bi bi-qr-code-scan display-1 text-muted opacity-25"></i>
                </div>
                <h3>No QR Codes Found</h3>
                <p class="text-muted">You haven't generated any codes yet. Create one to get started!</p>
                <a href="create_qr.php" class="btn btn-primary">Create First QR</a>
            </div>
        <?php endif; ?>
    </div>
</div>

<?php include '../includes/footer.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: my_qrs.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation