Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.19.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u802471691

Directory:

/home/u802471691/domains/thetechnozone.in/public_html/admin

Free Space:

9.3 TB

🔧 Quick Actions

✏️ Editing: add_accessories.php

<?php
include '../db.php';

$message = '';

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $brand_id = intval($_POST['brand_id']);
    $category_id = intval($_POST['category_id']);
    $series_id = !empty($_POST['series_id']) ? intval($_POST['series_id']) : null;
    $name = trim($_POST['name']);
    $description = trim($_POST['description']);
    $price = floatval($_POST['price']);
    $image_path = '';

if (empty($name) || empty($brand_id) || empty($category_id) || empty($price)) {
        $message = "All required fields are required.";
    } else {
        // Handle file upload
        if (isset($_FILES['image']) && $_FILES['image']['error'] == 0) {
            $target_dir = "../uploads/";
            $target_file = $target_dir . basename($_FILES["image"]["name"]);
            $imageFileType = strtolower(pathinfo($target_file, PATHINFO_EXTENSION));
            $check = getimagesize($_FILES["image"]["tmp_name"]);
            if ($check !== false) {
                if ($_FILES["image"]["size"] > 5000000) {
                    $message = "Sorry, your file is too large.";
                } else {
                    if ($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg" && $imageFileType != "gif") {
                        $message = "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
                    } else {
                        $new_filename = uniqid() . "." . $imageFileType;
                        $target_file = $target_dir . $new_filename;
                        if (move_uploaded_file($_FILES["image"]["tmp_name"], $target_file)) {
                            $image_path = "uploads/" . $new_filename;
                        } else {
                            $message = "Sorry, there was an error uploading your file.";
                        }
                    }
                }
            } else {
                $message = "File is not an image.";
            }
        }

if (empty($message)) {
            $sql = "INSERT INTO products (brand_id, category_id, series_id, name, image, description, price) VALUES (?, ?, ?, ?, ?, ?, ?)";
            $stmt = $conn->prepare($sql);
            $stmt->bind_param("iiisssd", $brand_id, $category_id, $series_id, $name, $image_path, $description, $price);
            if ($stmt->execute()) {
                $message = "Accessory added successfully.";
            } else {
                $message = "Error: " . $stmt->error;
            }
            $stmt->close();
        }
    }
}

include 'header.php';
?>

<div class="max-w-4xl mx-auto bg-white p-8 rounded-lg shadow">
    <h1 class="text-3xl font-bold text-gray-800 mb-6">Add New Accessory</h1>

<?php if ($message): ?>
        <div class="mb-4 p-4 rounded <?php echo strpos($message, 'successfully') !== false ? 'bg-green-100 text-green-700' : 'bg-red-100 text-red-700'; ?>">
            <?php echo $message; ?>
        </div>
    <?php endif; ?>

<form method="POST" enctype="multipart/form-data">
        <div class="grid grid-cols-1 md:grid-cols-2 gap-6">
            <div>
                <label for="brand_id" class="block text-gray-700 font-bold mb-2">Brand *</label>
                <select id="brand_id" name="brand_id" class="w-full px-3 py-2 border border-gray-300 rounded focus:outline-none focus:ring-2 focus:ring-red-500" required>
                    <option value="">Select Brand</option>
                    <?php
                    // Modified query to filter by Accessories or All
                    $brand_sql = "SELECT id, name FROM brands WHERE brand_type IN ('Accessories', 'All') ORDER BY name";
                    $brand_result = $conn->query($brand_sql);
                    while($brand_row = $brand_result->fetch_assoc()) {
                        echo "<option value='{$brand_row['id']}'>{$brand_row['name']}</option>";
                    }
                    ?>
                </select>
            </div>

<div>
                <label for="category_id" class="block text-gray-700 font-bold mb-2">Category *</label>
                <select id="category_id" name="category_id" class="w-full px-3 py-2 border border-gray-300 rounded focus:outline-none focus:ring-2 focus:ring-red-500" required>
                    <option value="">Select Category</option>
                    <?php
                    $cat_sql = "SELECT id, name FROM categories ORDER BY name";
                    $cat_result = $conn->query($cat_sql);
                    while($cat_row = $cat_result->fetch_assoc()) {
                        echo "<option value='{$cat_row['id']}'>{$cat_row['name']}</option>";
                    }
                    ?>
                </select>
            </div>

<div>
                <label for="series_id" class="block text-gray-700 font-bold mb-2">Series</label>
                <select id="series_id" name="series_id" class="w-full px-3 py-2 border border-gray-300 rounded focus:outline-none focus:ring-2 focus:ring-red-500">
                    <option value="">Select Series</option>
                </select>
            </div>

<div>
                <label for="name" class="block text-gray-700 font-bold mb-2">Device Name *</label>
                <input type="text" id="name" name="name" class="w-full px-3 py-2 border border-gray-300 rounded focus:outline-none focus:ring-2 focus:ring-red-500" required>
            </div>

<div>
                <label for="price" class="block text-gray-700 font-bold mb-2">Price *</label>
                <input type="number" step="0.01" id="price" name="price" class="w-full px-3 py-2 border border-gray-300 rounded focus:outline-none focus:ring-2 focus:ring-red-500" required>
            </div>

<div>
                <label for="image" class="block text-gray-700 font-bold mb-2">Image</label>
                <input type="file" id="image" name="image" accept="image/*" class="w-full px-3 py-2 border border-gray-300 rounded focus:outline-none focus:ring-2 focus:ring-red-500">
            </div>
        </div>

<div class="mt-6">
            <label for="description" class="block text-gray-700 font-bold mb-2">Description</label>
            <textarea id="description" name="description" rows="4" class="w-full px-3 py-2 border border-gray-300 rounded focus:outline-none focus:ring-2 focus:ring-red-500"></textarea>
        </div>

<div class="mt-6 flex justify-end space-x-4">
            <a href="manage_accessories.php" class="bg-gray-500 text-white px-4 py-2 rounded hover:bg-gray-600 transition">Cancel</a>
            <button type="submit" class="bg-red-900 text-white px-4 py-2 rounded hover:bg-red-800 transition">
                <i class="fa-solid fa-save mr-2"></i> Add Accessory
            </button>
        </div>
    </form>
</div>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
function updateSeries() {
    var brandId = document.getElementById('brand_id').value;
    var categoryId = document.getElementById('category_id').value;
    var seriesSelect = document.getElementById('series_id');

// Destroy select2 to allow DOM manipulation
    $('#series_id').select2('destroy');
    seriesSelect.innerHTML = '<option value="">Select Series</option>';

if (brandId && categoryId) {
        fetch('get_series.php?brand_id=' + brandId + '&category_id=' + categoryId)
            .then(response => response.json())
            .then(data => {
                data.forEach(function(series) {
                    var option = document.createElement('option');
                    option.value = series.id;
                    option.textContent = series.name;
                    seriesSelect.appendChild(option);
                });
                // Reinitialize select2 after populating options
                $('#series_id').select2({
                    placeholder: 'Search and select series',
                    allowClear: true
                });
            })
            .catch(error => console.error('Error:', error));
    } else {
        // Reinitialize select2 with empty options
        $('#series_id').select2({
            placeholder: 'Search and select series',
            allowClear: true
        });
    }
}

$('#brand_id').on('change', updateSeries);
$('#category_id').on('change', updateSeries);
</script>

<?php include 'footer.php'; ?>
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
<script>
// Initialize select2
$('#brand_id').select2({
    placeholder: 'Search and select brand',
    allowClear: true
});
$('#category_id').select2({
    placeholder: 'Search and select category',
    allowClear: true
});
$('#series_id').select2({
    placeholder: 'Search and select series',
    allowClear: true
});
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: add_accessories.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation