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: save-customer.php

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

if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    echo json_encode(['success' => false, 'message' => 'Invalid method']);
    exit;
}

function json($s, $m, $d = []) {
    ob_clean();
    echo json_encode(['success' => $s, 'message' => $m, 'data' => $d]);
    exit;
}

$customer_id = $_POST['customer_id'] ?? null;
$name = trim($_POST['customer_name'] ?? '');
$mobile = trim($_POST['mobile_number'] ?? '');
$business = trim($_POST['business_name'] ?? '');
$status = $_POST['status'] ?? '';

if (!$name || !$mobile || !$business || !$status) {
    json(false, 'Required fields missing');
}

$fields = [
    'customer_name'     => $name,
    'mobile_number'     => $mobile,
    'email'             => $_POST['email'] ?? null,
    'customer_location' => $_POST['customer_location'] ?? null,
    'business_name'     => $business,
    'business_category' => $_POST['business_category'] ?? null,
    'gstin'             => $_POST['gstin'] ?? null,
    'status'            => $status,
    'notes'             => $_POST['notes'] ?? null
];

if (!empty($_POST['created_on'])) $fields['created_at'] = $_POST['created_on'];
if (!empty($_POST['last_activity'])) $fields['updated_at'] = $_POST['last_activity'];

if ($customer_id && is_numeric($customer_id)) {
    // UPDATE
    $sets = [];
    $values = [];
    $types = '';
    foreach ($fields as $k => $v) {
        $sets[] = "$k = ?";
        $values[] = $v;
        $types .= $v === null ? 's' : 's';
    }
    $values[] = $customer_id;
    $types .= 'i';
    $sql = "UPDATE customers SET " . implode(', ', $sets) . " WHERE id = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param($types, ...$values);
    $success = $stmt->execute();
    json($success, $success ? 'Customer updated' : 'Update failed');
} else {
    // INSERT
    $cols = array_keys($fields);
    $placeholders = array_fill(0, count($cols), '?');
    $sql = "INSERT INTO customers (" . implode(',', $cols) . ") VALUES (" . implode(',', $placeholders) . ")";
    $stmt = $conn->prepare($sql);
    $types = str_repeat('s', count($cols));
    $values = array_values($fields);
    $stmt->bind_param($types, ...$values);
    if ($stmt->execute()) {
        json(true, 'Customer added', ['id' => $stmt->insert_id]);
    } else {
        json(false, 'Insert failed');
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: save-customer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation