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.26 TB

🔧 Quick Actions

✏️ Editing: view_leads.php

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

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

// Security: Ensure this QR belongs to the user
$check = $conn->query("SELECT name FROM qrcodes WHERE id = $qr_id AND user_id = $user_id")->fetch_assoc();
if (!$check) { die("Access Denied"); }

// Fetch Leads
$leads = $conn->query("SELECT * FROM leads WHERE qr_id = $qr_id ORDER BY captured_at DESC");
?>

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

<div class="container mt-4">
    <div class="d-flex justify-content-between align-items-center mb-3">
        <h3>Leads for: <?php echo htmlspecialchars($check['name']); ?></h3>
        <a href="edit_qr.php?id=<?php echo $qr_id; ?>" class="btn btn-secondary">Back</a>
    </div>

<div class="card shadow-sm">
        <div class="card-body p-0">
            <table class="table table-hover mb-0">
                <thead class="table-dark">
                    <tr>
                        <th>Date</th>
                        <th>Name</th>
                        <th>Email</th>
                        <th>Phone</th>
                    </tr>
                </thead>
                <tbody>
                    <?php if($leads->num_rows > 0): ?>
                        <?php while($row = $leads->fetch_assoc()): ?>
                        <tr>
                            <td><?php echo date('M d, H:i', strtotime($row['captured_at'])); ?></td>
                            <td><?php echo htmlspecialchars($row['name']); ?></td>
                            <td><?php echo htmlspecialchars($row['email']); ?></td>
                            <td><?php echo htmlspecialchars($row['phone']); ?></td>
                        </tr>
                        <?php endwhile; ?>
                    <?php else: ?>
                        <tr><td colspan="4" class="text-center py-4">No leads collected yet.</td></tr>
                    <?php endif; ?>
                </tbody>
            </table>
        </div>
    </div>
    
    <div class="mt-3">
        <button onclick="window.print()" class="btn btn-outline-dark"><i class="bi bi-printer"></i> Print List</button>
    </div>
</div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view_leads.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation