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/ecommer.in/public_html/crm

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: ajax-accounts.php

<?php
// ajax-accounts.php
ob_start();
require_once 'includes/db.php';
header('Content-Type: application/json');

if (!isset($_POST['action']) || $_POST['action'] !== 'fetch') {
    echo json_encode(['error' => 'Invalid action']);
    exit;
}

$draw     = (int)($_POST['draw'] ?? 1);
$start    = (int)($_POST['start'] ?? 0);
$length   = (int)($_POST['length'] ?? 10);
$search   = $_POST['search']['value'] ?? '';
$type     = $_POST['type'] ?? '';
$industry = $_POST['industry'] ?? '';
$status   = $_POST['status'] ?? '';

$sql = "SELECT id, account_name, type, industry, owner, phone, email, city, 
               status, created_at as created_on, updated_at as last_activity, 
               billing_address, shipping_address, website, gstin, pan, notes 
        FROM accounts";

$countSql = "SELECT COUNT(*) FROM accounts";

$params = [];
$types  = '';

if ($search !== '') {
    $like = "%$search%";
    $sql      .= " AND (account_name LIKE ? OR phone LIKE ? OR email LIKE ? OR owner LIKE ? OR city LIKE ? OR notes LIKE ?)";
    $countSql .= " AND (account_name LIKE ? OR phone LIKE ? OR email LIKE ? OR owner LIKE ? OR city LIKE ? OR notes LIKE ?)";
    $params = array_merge($params, [$like, $like, $like, $like, $like, $like]);
    $types .= 'ssssss';
}

if ($type !== '') {
    $sql      .= " AND type = ?";
    $countSql .= " AND type = ?";
    $params[] = $type;
    $types   .= 's';
}

if ($industry !== '') {
    $sql      .= " AND industry = ?";
    $countSql .= " AND industry = ?";
    $params[] = $industry;
    $types   .= 's';
}

if ($status !== '') {
    $sql      .= " AND status = ?";
    $countSql .= " AND status = ?";
    $params[] = $status;
    $types   .= 's';
}

// Total filtered
$stmt = $conn->prepare($countSql);
if ($params) $stmt->bind_param($types, ...$params);
$stmt->execute();
$totalFiltered = $stmt->get_result()->fetch_array()[0] ?? 0;

// Data + pagination
$sql .= " ORDER BY id DESC LIMIT ?, ?";
$params[] = $start;
$params[] = $length;
$types   .= 'ii';

$stmt = $conn->prepare($sql);
$stmt->bind_param($types, ...$params);
$stmt->execute();
$res = $stmt->get_result();

$data = [];
while ($row = $res->fetch_assoc()) {
    $row['created_on'] = $row['created_on'] ? date('M j, Y g:i A', strtotime($row['created_on'])) : '-';
    $row['last_activity'] = $row['last_activity'] ? date('M j, Y g:i A', strtotime($row['last_activity'])) : '-';
    $data[] = $row;
}

$totalAll = $conn->query("SELECT COUNT(*) FROM accounts")->fetch_array()[0];

ob_end_clean();
echo json_encode([
    "draw"            => $draw,
    "recordsTotal"    => (int)$totalAll,
    "recordsFiltered" => (int)$totalFiltered,
    "data"            => $data
]);
exit;

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: ajax-accounts.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation