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.30

User:

u530111037

Directory:

/home/u530111037/domains/goodcharacteropc.com/public_html/admin

Free Space:

3.34 TB

🔧 Quick Actions

✏️ Editing: consume.php

<?php
require_once __DIR__ . "/../db.php";
require_once './../header.php';
require_admin();

$view = $_GET['view'] ?? 'list';
$message = '';

// Delete contact
if (isset($_GET['delete'])) {
    $id = (int)$_GET['id'];
    $stmt = $mysqli->prepare("DELETE FROM contact_submissions WHERE id=?");
    $stmt->bind_param('i', $id);
    $stmt->execute();
    echo "<script>alert('Contact deleted successfully!');</script>";
    echo "<script>location.href = '${base_url}admin/consume.php';</script>";
    exit;
}

// Update status
if (isset($_POST['update_status'])) {
    $id = (int)$_POST['contact_id'];
    $status = $_POST['status'];
    $stmt = $mysqli->prepare("UPDATE contact_submissions SET status=? WHERE id=?");
    $stmt->bind_param('si', $status, $id);
    $stmt->execute();
    echo "<script>alert('Status updated successfully!');</script>";
    echo "<script>location.href = '${base_url}admin/consume.php';</script>";
    exit;
}
?>

<?php if ($message): ?>
        <div class="alert alert-danger"><?= htmlspecialchars($message) ?></div>
    <?php endif; ?>

<?php if ($view == 'list'): ?>
        <div class="d-flex justify-content-between align-items-center mb-3">
            <h4 class="mb-0 fw-bold">Contact Submissions</h4>
            <span class="badge bg-primary" style="font-size: 14px; padding: 6px 12px;"><?php 
                $total = $mysqli->query("SELECT COUNT(*) as cnt FROM contact_submissions")->fetch_assoc()['cnt'];
                echo $total . ' Total';
            ?></span>
        </div>

<div class="card">
          <div class="card-body p-0">
            
            <div class="d-flex gap-2 mb-3 p-3 pb-0">
                <input type="text" id="searchBox" class="form-control" placeholder="Search by name, email, or subject..." style="max-width: 400px;">
                <select id="statusFilter" class="form-select" style="max-width: 200px;">
                    <option value="">All Status</option>
                    <option value="new">New</option>
                    <option value="read">Read</option>
                    <option value="replied">Replied</option>
                </select>
            </div>

<table class="table table-hover align-middle mb-0" id="contactsTable">
                <thead class="table-dark">
                    <tr>
                        <th style="width: 5%;">#</th>
                        <th style="width: 15%;">Name</th>
                        <th style="width: 15%;">Email</th>
                        <th style="width: 20%;">Subject</th>
                        <th style="width: 10%;">Status</th>
                        <th style="width: 15%;">Submitted</th>
                        <th style="width: 20%;">Action</th>
                    </tr>
                </thead>
                <tbody>
                <?php
                $result = $mysqli->query("
                    SELECT * FROM contact_submissions 
                    ORDER BY submitted_at DESC
                ");
                
                if ($result->num_rows == 0) {
                    echo '<tr><td colspan="7" class="text-center text-muted py-4">No contact submissions yet.</td></tr>';
                }
                
                while ($row = $result->fetch_assoc()):
                    // Status badge color
                    $statusClass = [
                        'new' => 'bg-success',
                        'read' => 'bg-info',
                        'replied' => 'bg-secondary'
                    ][$row['status']] ?? 'bg-secondary';
                ?>
                    <tr data-status="<?= $row['status'] ?>">
                        <td><?= $row['id'] ?></td>
                        <td><?= htmlspecialchars($row['name']) ?></td>
                        <td><a href="mailto:<?= htmlspecialchars($row['email']) ?>"><?= htmlspecialchars($row['email']) ?></a></td>
                        <td><?= htmlspecialchars(substr($row['subject'], 0, 40)) . (strlen($row['subject']) > 40 ? '...' : '') ?></td>
                        <td>
                            <span class="badge <?= $statusClass ?>"><?= ucfirst($row['status']) ?></span>
                        </td>
                        <td><?= date('M d, Y H:i', strtotime($row['submitted_at'])) ?></td>
                        <td>
                            <a href="?view=detail&id=<?= $row['id'] ?>" class="btn btn-sm btn-primary">View</a>
                            <a href="?delete=1&id=<?= $row['id'] ?>" class="btn btn-sm btn-danger" onclick="return confirm('Delete this contact?')">Delete</a>
                        </td>
                    </tr>
                <?php endwhile; ?>
                </tbody>
            </table>
          </div>
        </div>

function filterTable() {
                const searchValue = document.getElementById('searchBox').value.toLowerCase();
                const statusValue = document.getElementById('statusFilter').value.toLowerCase();
                const rows = document.querySelectorAll('#contactsTable tbody tr');

rows.forEach(row => {
                    if (row.cells.length < 2) return; // Skip empty row
                    
                    const name = row.cells[1].textContent.toLowerCase();
                    const email = row.cells[2].textContent.toLowerCase();
                    const subject = row.cells[3].textContent.toLowerCase();
                    const status = row.dataset.status;

const matchesSearch = name.includes(searchValue) || 
                                        email.includes(searchValue) || 
                                        subject.includes(searchValue);
                    const matchesStatus = !statusValue || status === statusValue;

if (matchesSearch && matchesStatus) {
                        row.style.display = '';
                    } else {
                        row.style.display = 'none';
                    }
                });
            }
        </script>

<?php elseif ($view == 'detail'):
        $id = (int)$_GET['id'];
        $stmt = $mysqli->prepare("SELECT * FROM contact_submissions WHERE id=?");
        $stmt->bind_param('i', $id);
        $stmt->execute();
        $contact = $stmt->get_result()->fetch_assoc();

if (!$contact) {
            echo '<div class="alert alert-danger">Contact not found!</div>';
            echo '<a href="consume.php" class="btn btn-secondary">Go Back</a>';
        } else {
            // Auto-mark as read if status is new
            if ($contact['status'] == 'new') {
                $mysqli->query("UPDATE contact_submissions SET status='read' WHERE id=$id");
            }
    ?>
      <div class="mb-2">
          <a href="consume.php" class="btn btn-outline-secondary" style="padding: 2px 6px !important; border-radius: 50%; background: gray; color: white">←</a>
          <span style="padding-left: 5px"><b>Contact Details #<?= $id ?></b></span>
      </div>

<div class="row">
          <div class="col-lg-8">
              <div class="card">
                  <div class="card-header bg-primary text-white">
                      <h5 class="mb-0">Message Details</h5>
                  </div>
                  <div class="card-body">
                      <div class="mb-3">
                          <strong>Subject:</strong>
                          <p class="mb-0"><?= htmlspecialchars($contact['subject']) ?></p>
                      </div>
                      
                      <hr>
                      
                      <div class="mb-3">
                          <strong>Message:</strong>
                          <div class="border rounded p-3 mt-2" style="background: #f8f9fa; white-space: pre-wrap;"><?= htmlspecialchars($contact['message']) ?></div>
                      </div>

<hr>

<div class="d-flex gap-3 justify-content-end">
                          <a href="mailto:<?= htmlspecialchars($contact['email']) ?>?subject=Re: <?= urlencode($contact['subject']) ?>" class="btn btn-success">
                              <i class="fas fa-reply"></i> Reply via Email
                          </a>
                          <a href="?delete=1&id=<?= $id ?>" class="btn btn-danger" onclick="return confirm('Delete this contact?')">
                              <i class="fas fa-trash"></i> Delete
                          </a>
                      </div>
                  </div>
              </div>
          </div>

<div class="col-lg-4">
              <div class="card">
                  <div class="card-header bg-secondary text-white">
                      <h6 class="mb-0">Contact Information</h6>
                  </div>
                  <div class="card-body">
                      <div class="mb-3">
                          <small class="text-muted">Name</small>
                          <p class="mb-0 fw-bold"><?= htmlspecialchars($contact['name']) ?></p>
                      </div>

<div class="mb-3">
                          <small class="text-muted">Email</small>
                          <p class="mb-0"><a href="mailto:<?= htmlspecialchars($contact['email']) ?>"><?= htmlspecialchars($contact['email']) ?></a></p>
                      </div>

<div class="mb-3">
                          <small class="text-muted">Submitted At</small>
                          <p class="mb-0"><?= date('F d, Y \a\t H:i', strtotime($contact['submitted_at'])) ?></p>
                      </div>

<hr>

<form method="post">
                          <input type="hidden" name="contact_id" value="<?= $id ?>">
                          <div class="mb-3">
                              <label class="form-label"><strong>Status</strong></label>
                              <select name="status" class="form-select" required>
                                  <option value="new" <?= $contact['status'] == 'new' ? 'selected' : '' ?>>New</option>
                                  <option value="read" <?= $contact['status'] == 'read' ? 'selected' : '' ?>>Read</option>
                                  <option value="replied" <?= $contact['status'] == 'replied' ? 'selected' : '' ?>>Replied</option>
                              </select>
                          </div>
                          <button type="submit" name="update_status" class="btn btn-primary w-100">Update Status</button>
                      </form>
                  </div>
              </div>
          </div>
      </div>
    <?php } endif; ?>
</div>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: consume.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation