Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/rutzotech.com/public_html/bill

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: export_users.php

<?php
// export_users.php
require_once 'db_connection.php';
session_start();

$current_user_id = $_SESSION['user_id'] ?? 1;

// Fetch all users
$users_result = $conn->query("SELECT * FROM users ORDER BY id DESC");
$all_users = $users_result ? $users_result->fetch_all(MYSQLI_ASSOC) : [];

// Get export type
$export_type = $_GET['type'] ?? 'excel';

// Function to sanitize filename
function sanitizeFilename($filename) {
    $filename = preg_replace('/[^a-zA-Z0-9_-]/', '_', $filename);
    return $filename . '_' . date('Y-m-d');
}

// Export to Excel
if ($export_type === 'excel') {
    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment; filename="' . sanitizeFilename('users_list') . '.xlsx"');
    
    echo '<!DOCTYPE html>
    <html>
    <head>
        <meta charset="UTF-8">
        <title>Users List</title>
        <style>
            table { border-collapse: collapse; width: 100%; }
            th { background-color: #4CAF50; color: white; font-weight: bold; }
            th, td { border: 1px solid #ddd; padding: 8px; text-align: left; }
            tr:nth-child(even) { background-color: #f2f2f2; }
            .header { text-align: center; margin-bottom: 20px; }
            .logo { font-size: 24px; font-weight: bold; color: #4CAF50; }
            .date { color: #666; font-size: 12px; }
            .summary { margin: 20px 0; padding: 10px; background-color: #e8f5e8; border-left: 4px solid #4CAF50; }
        </style>
    </head>
    <body>';
    
    echo '<div class="header">
        <div class="logo">Users Management System</div>
        <h2>Users List Report</h2>
        <div class="date">Generated on: ' . date('d F Y, h:i A') . '</div>
    </div>';
    
    // Summary stats
    $total_users = count($all_users);
    $active_users = count(array_filter($all_users, fn($u) => $u['status'] == 1));
    $admins = count(array_filter($all_users, fn($u) => $u['role'] == 'admin'));
    $employees = count(array_filter($all_users, fn($u) => $u['role'] == 'employee'));
    
    echo '<div class="summary">
        <strong>Summary:</strong> Total Users: ' . $total_users . ' | 
        Active: ' . $active_users . ' | 
        Inactive: ' . ($total_users - $active_users) . ' | 
        Admins: ' . $admins . ' | 
        Employees: ' . $employees . '
    </div>';
    
    echo '<table>
        <thead>
            <tr>
                <th>ID</th>
                <th>Name</th>
                <th>Email</th>
                <th>Role</th>
                <th>Phone</th>
                <th>Status</th>
                <th>Address</th>
                <th>Created Date</th>
            </tr>
        </thead>
        <tbody>';
    
    foreach ($all_users as $user) {
        echo '<tr>';
        echo '<td>' . $user['id'] . '</td>';
        echo '<td>' . htmlspecialchars($user['name']) . '</td>';
        echo '<td>' . htmlspecialchars($user['email']) . '</td>';
        echo '<td>' . ucfirst($user['role']) . '</td>';
        echo '<td>' . ($user['phone'] ?: '-') . '</td>';
        echo '<td>' . ($user['status'] == 1 ? 'Active' : 'Inactive') . '</td>';
        echo '<td>' . htmlspecialchars($user['address'] ?? '') . '</td>';
        echo '<td>' . date('d M Y', strtotime($user['created_at'])) . '</td>';
        echo '</tr>';
    }
    
    echo '</tbody>
    </table>
    
    <div style="margin-top: 30px; font-size: 11px; color: #666; text-align: center;">
        <hr>
        <p>Generated by: User Management System | ' . date('Y') . ' | Confidential</p>
    </div>
    
    </body>
    </html>';
    
    exit;
}

// Export to CSV
elseif ($export_type === 'csv') {
    header('Content-Type: text/csv');
    header('Content-Disposition: attachment; filename="' . sanitizeFilename('users_list') . '.csv"');
    
    $output = fopen('php://output', 'w');
    
    // Add UTF-8 BOM for Excel compatibility
    fputs($output, $bom = (chr(0xEF) . chr(0xBB) . chr(0xBF)));
    
    // Header row
    fputcsv($output, ['ID', 'Name', 'Email', 'Role', 'Phone', 'Status', 'Address', 'Created Date']);
    
    // Data rows
    foreach ($all_users as $user) {
        fputcsv($output, [
            $user['id'],
            $user['name'],
            $user['email'],
            ucfirst($user['role']),
            $user['phone'] ?: '',
            $user['status'] == 1 ? 'Active' : 'Inactive',
            $user['address'] ?? '',
            date('d M Y', strtotime($user['created_at']))
        ]);
    }
    
    fclose($output);
    exit;
}

// Export to PDF (Requires TCPDF library)
elseif ($export_type === 'pdf') {
    // Check if TCPDF is available
    if (!class_exists('TCPDF')) {
        // If TCPDF is not installed, redirect to install page or show error
        header('Location: export_users.php?type=excel&error=PDF export requires TCPDF library');
        exit;
    }
    
    require_once('tcpdf/tcpdf.php');
    
    // Create new PDF document
    $pdf = new TCPDF('P', 'mm', 'A4', true, 'UTF-8', false);
    
    // Set document information
    $pdf->SetCreator('User Management System');
    $pdf->SetAuthor('System Admin');
    $pdf->SetTitle('Users List Report');
    $pdf->SetSubject('Users Export');
    $pdf->SetKeywords('Users, Report, PDF');
    
    // Remove default header/footer
    $pdf->setPrintHeader(false);
    $pdf->setPrintFooter(false);
    
    // Set margins
    $pdf->SetMargins(15, 15, 15);
    $pdf->SetAutoPageBreak(TRUE, 15);
    
    // Add a page
    $pdf->AddPage();
    
    // Set font
    $pdf->SetFont('helvetica', '', 10);
    
    // Title
    $pdf->SetFont('helvetica', 'B', 16);
    $pdf->Cell(0, 10, 'USERS LIST REPORT', 0, 1, 'C');
    $pdf->SetFont('helvetica', '', 10);
    $pdf->Cell(0, 5, 'Generated on: ' . date('d F Y, h:i A'), 0, 1, 'C');
    $pdf->Ln(10);
    
    // Summary stats
    $total_users = count($all_users);
    $active_users = count(array_filter($all_users, fn($u) => $u['status'] == 1));
    $admins = count(array_filter($all_users, fn($u) => $u['role'] == 'admin'));
    $employees = count(array_filter($all_users, fn($u) => $u['role'] == 'employee'));
    
    $summary = "Total Users: $total_users | Active: $active_users | Inactive: " . ($total_users - $active_users) . 
               " | Admins: $admins | Employees: $employees";
    
    $pdf->SetFont('helvetica', 'B', 11);
    $pdf->Cell(0, 8, 'Summary:', 0, 1);
    $pdf->SetFont('helvetica', '', 10);
    $pdf->MultiCell(0, 6, $summary, 0, 'L');
    $pdf->Ln(5);
    
    // Create table header
    $pdf->SetFillColor(76, 175, 80);
    $pdf->SetTextColor(255);
    $pdf->SetDrawColor(0, 0, 0);
    $pdf->SetLineWidth(0.3);
    $pdf->SetFont('helvetica', 'B', 9);
    
    $header = array('ID', 'Name', 'Email', 'Role', 'Phone', 'Status', 'Created');
    $w = array(10, 40, 50, 20, 25, 20, 25);
    
    for($i = 0; $i < count($header); $i++) {
        $pdf->Cell($w[$i], 7, $header[$i], 1, 0, 'C', true);
    }
    $pdf->Ln();
    
    // Reset font and color for data
    $pdf->SetFillColor(255, 255, 255);
    $pdf->SetTextColor(0);
    $pdf->SetFont('helvetica', '', 8);
    
    // Add data
    $fill = false;
    foreach ($all_users as $user) {
        // Check if we need a new page
        if ($pdf->GetY() > 250) {
            $pdf->AddPage();
            // Reprint header
            $pdf->SetFillColor(76, 175, 80);
            $pdf->SetTextColor(255);
            $pdf->SetFont('helvetica', 'B', 9);
            for($i = 0; $i < count($header); $i++) {
                $pdf->Cell($w[$i], 7, $header[$i], 1, 0, 'C', true);
            }
            $pdf->Ln();
            $pdf->SetFillColor(255, 255, 255);
            $pdf->SetTextColor(0);
            $pdf->SetFont('helvetica', '', 8);
        }
        
        $pdf->Cell($w[0], 6, $user['id'], 'LR', 0, 'C', $fill);
        $pdf->Cell($w[1], 6, substr($user['name'], 0, 25), 'LR', 0, 'L', $fill);
        $pdf->Cell($w[2], 6, substr($user['email'], 0, 30), 'LR', 0, 'L', $fill);
        $pdf->Cell($w[3], 6, ucfirst($user['role']), 'LR', 0, 'C', $fill);
        $pdf->Cell($w[4], 6, $user['phone'] ?: '-', 'LR', 0, 'C', $fill);
        $pdf->Cell($w[5], 6, $user['status'] == 1 ? 'Active' : 'Inactive', 'LR', 0, 'C', $fill);
        $pdf->Cell($w[6], 6, date('d M Y', strtotime($user['created_at'])), 'LR', 0, 'C', $fill);
        $pdf->Ln();
        $fill = !$fill;
    }
    
    // Closing line
    $pdf->Cell(array_sum($w), 0, '', 'T');
    
    // Footer
    $pdf->Ln(10);
    $pdf->SetFont('helvetica', 'I', 8);
    $pdf->Cell(0, 5, 'Generated by User Management System - ' . date('Y'), 0, 1, 'C');
    $pdf->Cell(0, 5, 'Page ' . $pdf->PageNo() . '/{nb}', 0, 0, 'C');
    
    // Output PDF
    $pdf->Output(sanitizeFilename('users_list') . '.pdf', 'D');
    exit;
}

// Print Preview
elseif ($export_type === 'print') {
    ?>
    <!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Print Users List</title>
        <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
        <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.0/font/bootstrap-icons.css">
        <style>
            @media print {
                .no-print { display: none !important; }
                body { background: white !important; }
                .container { max-width: 100% !important; margin: 0 !important; padding: 0 !important; }
                .card { border: none !important; box-shadow: none !important; }
                .table { font-size: 11px; }
                .print-header { margin-bottom: 20px; }
            }
            body { background-color: #f8f9fa; }
            .container { max-width: 1200px; margin: 30px auto; }
            .print-header { text-align: center; margin-bottom: 30px; }
            .logo { font-size: 24px; font-weight: bold; color: #198754; }
            .summary-box { background: #e8f5e8; padding: 15px; border-radius: 8px; margin-bottom: 20px; }
            .table th { background-color: #198754 !important; color: white !important; }
            .footer-note { margin-top: 30px; padding-top: 15px; border-top: 1px solid #dee2e6; font-size: 12px; color: #6c757d; text-align: center; }
        </style>
    </head>
    <body>
        <div class="container">
            
            <div class="no-print mb-4">
                <div class="card">
                    <div class="card-body">
                        <div class="d-flex justify-content-between align-items-center">
                            <div>
                                <h5 class="mb-0"><i class="bi bi-printer me-2"></i>Print Preview</h5>
                                <p class="text-muted mb-0">Preview and print users list</p>
                            </div>
                            <div class="btn-group">
                                <a href="view_users.php" class="btn btn-outline-secondary">
                                    <i class="bi bi-arrow-left me-2"></i> Back
                                </a>
                                <button onclick="window.print()" class="btn btn-primary">
                                    <i class="bi bi-printer me-2"></i> Print
                                </button>
                                <div class="btn-group">
                                    <button type="button" class="btn btn-success dropdown-toggle" data-bs-toggle="dropdown">
                                        <i class="bi bi-download me-2"></i> Export
                                    </button>
                                    <ul class="dropdown-menu">
                                        <li><a class="dropdown-item" href="export_users.php?type=excel"><i class="bi bi-file-earmark-excel me-2"></i> Excel</a></li>
                                        <li><a class="dropdown-item" href="export_users.php?type=csv"><i class="bi bi-file-earmark-text me-2"></i> CSV</a></li>
                                        <li><a class="dropdown-item" href="export_users.php?type=pdf"><i class="bi bi-file-earmark-pdf me-2"></i> PDF</a></li>
                                    </ul>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            
            
            <div class="card">
                <div class="card-body">
                    
                    <div class="print-header">
                        <div class="logo">User Management System</div>
                        <h2>Users List Report</h2>
                        <p class="text-muted">Generated on: <?php echo date('d F Y, h:i A'); ?></p>
                    </div>
                    
                    
                    <?php
                    $total_users = count($all_users);
                    $active_users = count(array_filter($all_users, fn($u) => $u['status'] == 1));
                    $admins = count(array_filter($all_users, fn($u) => $u['role'] == 'admin'));
                    $employees = count(array_filter($all_users, fn($u) => $u['role'] == 'employee'));
                    ?>
                    <div class="summary-box">
                        <div class="row">
                            <div class="col-md-3 text-center">
                                <h4 class="text-success"><?php echo $total_users; ?></h4>
                                <p class="mb-0">Total Users</p>
                            </div>
                            <div class="col-md-3 text-center">
                                <h4 class="text-success"><?php echo $active_users; ?></h4>
                                <p class="mb-0">Active Users</p>
                            </div>
                            <div class="col-md-3 text-center">
                                <h4 class="text-primary"><?php echo $admins; ?></h4>
                                <p class="mb-0">Admins</p>
                            </div>
                            <div class="col-md-3 text-center">
                                <h4 class="text-secondary"><?php echo $employees; ?></h4>
                                <p class="mb-0">Employees</p>
                            </div>
                        </div>
                    </div>
                    
                    
                    <div class="table-responsive">
                        <table class="table table-bordered table-hover">
                            <thead>
                                <tr>
                                    <th>ID</th>
                                    <th>Name</th>
                                    <th>Email</th>
                                    <th>Role</th>
                                    <th>Phone</th>
                                    <th>Status</th>
                                    <th>Address</th>
                                    <th>Created Date</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php if (empty($all_users)): ?>
                                <tr>
                                    <td colspan="8" class="text-center py-4">No users found</td>
                                </tr>
                                <?php else: ?>
                                    <?php foreach ($all_users as $user): ?>
                                    <tr>
                                        <td><?php echo $user['id']; ?></td>
                                        <td><?php echo htmlspecialchars($user['name']); ?></td>
                                        <td><?php echo htmlspecialchars($user['email']); ?></td>
                                        <td>
                                            <span class="badge bg-<?php echo $user['role'] == 'admin' ? 'primary' : 'secondary'; ?>">
                                                <?php echo ucfirst($user['role']); ?>
                                            </span>
                                        </td>
                                        <td><?php echo $user['phone'] ?: '-'; ?></td>
                                        <td>
                                            <span class="badge bg-<?php echo $user['status'] == 1 ? 'success' : 'danger'; ?>">
                                                <?php echo $user['status'] == 1 ? 'Active' : 'Inactive'; ?>
                                            </span>
                                        </td>
                                        <td><?php echo htmlspecialchars($user['address'] ?? ''); ?></td>
                                        <td><?php echo date('d M Y', strtotime($user['created_at'])); ?></td>
                                    </tr>
                                    <?php endforeach; ?>
                                <?php endif; ?>
                            </tbody>
                        </table>
                    </div>
                    
                    
                    <div class="footer-note">
                        <p>Generated by User Management System | <?php echo date('Y'); ?> | Page 1 of 1</p>
                        <p class="mb-0">This document is confidential and intended for authorized personnel only.</p>
                    </div>
                </div>
            </div>
            
            
            <div class="no-print mt-4">
                <div class="card">
                    <div class="card-body text-center">
                        <button onclick="window.print()" class="btn btn-primary me-2">
                            <i class="bi bi-printer me-2"></i> Print Now
                        </button>
                        <a href="view_users.php" class="btn btn-outline-secondary">
                            <i class="bi bi-x-circle me-2"></i> Close
                        </a>
                    </div>
                </div>
            </div>
        </div>
        
        <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
        <script>
        // Auto-print if parameter is set
        const urlParams = new URLSearchParams(window.location.search);
        if (urlParams.get('auto') === 'true') {
            window.print();
        }
        
        // Print event listeners
        window.addEventListener('afterprint', function() {
            console.log('Print completed');
        });
        </script>
    </body>
    </html>
    <?php
    exit;
}

// If no valid export type, redirect to view users
header('Location: view_users.php');
exit;
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: export_users.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation