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/narumalaracademy.net/public_html/admin

Free Space:

10.2 TB

🔧 Quick Actions

✏️ Editing: customers-data.php

<?php
// customers-data.php
session_start();
require_once __DIR__ . '/includes/db.php';

// Use global mysqli connection
$conn = $mysqli;

// Get request parameters
$start       = $_POST['start'] ?? 0;
$length      = $_POST['length'] ?? 10;
$search      = $_POST['search']['value'] ?? '';
$orderColumn = $_POST['order'][0]['column'] ?? 0;
$orderDir    = $_POST['order'][0]['dir'] ?? 'desc';

// Column mapping (must match table headers in customers.php)
$columns = [
    0 => 'id',
    1 => 'full_name',
    2 => 'email',
    3 => 'phone',
    4 => 'created_at',
    5 => 'order_count'
];

$orderBy = isset($columns[$orderColumn]) 
    ? $columns[$orderColumn] . ' ' . ($orderDir === 'asc' ? 'ASC' : 'DESC') 
    : 'id DESC';

// Base query
$baseQuery = "FROM users u 
LEFT JOIN (
    SELECT user_id, COUNT(*) as order_count 
    FROM orders 
    GROUP BY user_id
) o ON u.id = o.user_id";

// Get total records
$totalResult   = $conn->query("SELECT COUNT(*) as total FROM users");
$totalRecords  = $totalResult->fetch_assoc()['total'] ?? 0;

// Build filtered query
$whereConditions = [];
$params = [];
$paramTypes = '';

if (!empty($search)) {
    $whereConditions[] = "(u.full_name LIKE ? OR u.email LIKE ? OR u.phone LIKE ?)";
    $searchParam = "%$search%";
    $params = [$searchParam, $searchParam, $searchParam];
    $paramTypes = 'sss';
}

$whereClause = empty($whereConditions) ? '' : 'WHERE ' . implode(' AND ', $whereConditions);

// Get filtered count
$countQuery = "SELECT COUNT(*) as total $baseQuery $whereClause";
if (!empty($params)) {
    $stmt = $conn->prepare($countQuery);
    $stmt->bind_param($paramTypes, ...$params);
    $stmt->execute();
    $filteredResult = $stmt->get_result();
    $filteredRecords = $filteredResult->fetch_assoc()['total'] ?? 0;
    $stmt->close();
} else {
    $filteredResult = $conn->query($countQuery);
    $filteredRecords = $filteredResult->fetch_assoc()['total'] ?? 0;
}

// Get paginated data
$dataQuery = "SELECT 
    u.id, 
    u.full_name, 
    u.email,
    u.phone,
    u.created_at,
    COALESCE(o.order_count, 0) as order_count
$baseQuery
$whereClause
ORDER BY $orderBy
LIMIT ?, ?";

if (!empty($params)) {
    $paramTypes .= 'ii';
    $params[] = (int)$start;
    $params[] = (int)$length;

$stmt = $conn->prepare($dataQuery);
    $stmt->bind_param($paramTypes, ...$params);
    $stmt->execute();
    $result = $stmt->get_result();
} else {
    $stmt = $conn->prepare($dataQuery);
    $stmt->bind_param('ii', $start, $length);
    $stmt->execute();
    $result = $stmt->get_result();
}

$data = [];
while ($row = $result->fetch_assoc()) {
    $data[] = [
        'id'         => $row['id'],
        'full_name'  => $row['full_name'],
        'email'      => $row['email'],
        'phone'      => $row['phone'] ?: 'N/A',
        'created_at' => date('M j, Y', strtotime($row['created_at'])),
        'order_count'=> $row['order_count'],
    ];
}
$stmt->close();

// Return JSON response
header('Content-Type: application/json; charset=utf-8');
echo json_encode([
    'draw'            => intval($_POST['draw'] ?? 1),
    'recordsTotal'    => intval($totalRecords),
    'recordsFiltered' => intval($filteredRecords),
    'data'            => $data
]);

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: customers-data.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation