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: getusers.php

<?php
// saveuser.php
header('Content-Type: application/json');
require_once 'db_connection.php';

// Enable error reporting for debugging
error_reporting(E_ALL);
ini_set('display_errors', 1);

$response = ['success' => false, 'message' => 'Unknown error', 'data' => null];

try {
    // Log the received data for debugging
    error_log("POST Data: " . print_r($_POST, true));
    
    if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
        throw new Exception('Invalid request method');
    }
    
    // Get and validate data
    $user_id = isset($_POST['user_id']) ? intval($_POST['user_id']) : 0;
    $name = trim($_POST['name'] ?? '');
    $email = trim($_POST['email'] ?? '');
    $password = $_POST['password'] ?? '';
    $role = trim($_POST['role'] ?? 'employee');
    $address = trim($_POST['address'] ?? '');
    
    // Validate required fields
    if (empty($name)) {
        throw new Exception('Name is required');
    }
    
    if (empty($email)) {
        throw new Exception('Email is required');
    }
    
    if ($user_id === 0 && empty($password)) {
        throw new Exception('Password is required for new users');
    }
    
    // Validate role
    if (!in_array($role, ['admin', 'employee'])) {
        $role = 'employee';
    }
    
    // Prepare SQL based on whether it's update or insert
    if ($user_id > 0) {
        // Update existing user
        if (!empty($password)) {
            // Update with password
            $hashed_password = password_hash($password, PASSWORD_DEFAULT);
            $sql = "UPDATE users SET 
                    name = ?, 
                    email = ?, 
                    password = ?, 
                    role = ?, 
                    address = ? 
                    WHERE id = ?";
            
            $stmt = $conn->prepare($sql);
            if (!$stmt) {
                throw new Exception("Prepare failed: " . $conn->error);
            }
            
            $stmt->bind_param("sssssi", $name, $email, $hashed_password, $role, $address, $user_id);
        } else {
            // Update without password
            $sql = "UPDATE users SET 
                    name = ?, 
                    email = ?, 
                    role = ?, 
                    address = ? 
                    WHERE id = ?";
            
            $stmt = $conn->prepare($sql);
            if (!$stmt) {
                throw new Exception("Prepare failed: " . $conn->error);
            }
            
            $stmt->bind_param("ssssi", $name, $email, $role, $address, $user_id);
        }
    } else {
        // Insert new user
        $hashed_password = password_hash($password, PASSWORD_DEFAULT);
        $sql = "INSERT INTO users (name, email, password, role, address, status) 
                VALUES (?, ?, ?, ?, ?, 1)";
        
        $stmt = $conn->prepare($sql);
        if (!$stmt) {
            throw new Exception("Prepare failed: " . $conn->error);
        }
        
        $stmt->bind_param("sssss", $name, $email, $hashed_password, $role, $address);
    }
    
    // Execute query
    if ($stmt->execute()) {
        $response['success'] = true;
        $response['message'] = $user_id > 0 ? 'User updated successfully!' : 'User created successfully!';
        $response['data'] = [
            'user_id' => $user_id > 0 ? $user_id : $conn->insert_id,
            'action' => $user_id > 0 ? 'update' : 'create'
        ];
    } else {
        throw new Exception("Execute failed: " . $stmt->error);
    }
    
    $stmt->close();
    
} catch (Exception $e) {
    $response['message'] = $e->getMessage();
    error_log("Error in saveuser.php: " . $e->getMessage());
} finally {
    $conn->close();
}

echo json_encode($response);
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: getusers.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation