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

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

$message = '';

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $category_id = intval($_POST['category_id']);
    $brand_id = intval($_POST['brand_id']);
    $name = trim($_POST['name']);

if (empty($name) || empty($category_id) || empty($brand_id)) {
        $message = "All fields are required.";
    } else {
        $sql = "INSERT INTO series (category_id, brand_id, name) VALUES (?, ?, ?)";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("iis", $category_id, $brand_id, $name);
        if ($stmt->execute()) {
            header("Location: manage_series.php");
            exit();
        } else {
            $message = "Error: " . $stmt->error;
        }
        $stmt->close();
    }
}

include 'header.php';
?>

<div class="flex justify-between items-center mb-6">
    <h1 class="text-3xl font-bold text-gray-800">Manage Series</h1>
    <button type="button" onclick="openModal()" class="bg-red-900 text-white px-4 py-2 rounded hover:bg-red-800 transition">
        <i class="fa-solid fa-plus mr-2"></i> Add New Series
    </button>
</div>

<?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; ?>

<div class="bg-white rounded-lg shadow overflow-hidden">
    <table class="w-full text-left border-collapse">
        <thead class="bg-gray-50">
            <tr>
                <th class="py-3 px-4 border-b font-bold text-gray-600">S. No</th>
                <th class="py-3 px-4 border-b font-bold text-gray-600">Category</th>
                <th class="py-3 px-4 border-b font-bold text-gray-600">Brand</th>
                <th class="py-3 px-4 border-b font-bold text-gray-600">Series Name</th>
                <th class="py-3 px-4 border-b font-bold text-gray-600">Created At</th>
                <th class="py-3 px-4 border-b font-bold text-gray-600">Actions</th>
            </tr>
        </thead>
        <tbody>
            <?php
            $sql = "SELECT s.id, c.name as category_name, b.name as brand_name, s.name, s.created_at FROM series s JOIN categories c ON s.category_id = c.id JOIN brands b ON s.brand_id = b.id ORDER BY s.id DESC";
            $result = $conn->query($sql);
            if ($result->num_rows > 0) {
                $serial_number = 1;
                while($row = $result->fetch_assoc()) {
                    echo "<tr class='hover:bg-gray-50 transition'>";
                    echo "<td class='py-3 px-4 border-b'>" . $serial_number++ . "</td>";
                    echo "<td class='py-3 px-4 border-b'>{$row['category_name']}</td>";
                    echo "<td class='py-3 px-4 border-b'>{$row['brand_name']}</td>";
                    echo "<td class='py-3 px-4 border-b font-medium'>{$row['name']}</td>";
                    echo "<td class='py-3 px-4 border-b text-sm text-gray-500'>{$row['created_at']}</td>";
                    echo "<td class='py-3 px-4 border-b space-x-2'>";
                    echo "<a href='edit_series.php?id={$row['id']}' class='text-blue-600 hover:text-blue-800'><i class='fa-solid fa-pen-to-square'></i> Edit</a>";
                    echo "<a href='delete_series.php?id={$row['id']}' class='text-red-600 hover:text-red-800' onclick='return confirm(\"Are you sure you want to delete this series?\")'><i class='fa-solid fa-trash'></i> Delete</a>";
                    echo "</td>";
                    echo "</tr>";
                }
            } else {
                echo "<tr><td colspan='6' class='py-8 text-center text-gray-500'>No series found. Click 'Add New Series' to create one.</td></tr>";
            }
            ?>
        </tbody>
    </table>
</div>

<div id="addSeriesModal" class="fixed inset-0 bg-gray-600 bg-opacity-50 overflow-y-auto h-full w-full hidden">
    <div class="relative top-20 mx-auto p-5 border w-96 shadow-lg rounded-md bg-white">
        <div class="mt-3">
            <h3 class="text-lg font-medium text-gray-900 mb-4">Add New Series</h3>
            <form method="POST">
                <div class="mb-4">
                    <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 class="mb-4">
                    <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
                        $brand_sql = "SELECT id, name FROM brands 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 class="mb-4">
                    <label for="name" class="block text-gray-700 font-bold mb-2">Series 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 class="flex justify-end space-x-4">
                    <button type="button" onclick="closeModal()" class="bg-gray-500 text-white px-4 py-2 rounded hover:bg-gray-600 transition">Cancel</button>
                    <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 Series
                    </button>
                </div>
            </form>
        </div>
    </div>
</div>

function closeModal() {
    document.getElementById('addSeriesModal').classList.add('hidden');
    // Destroy select2 instances to prevent issues
    $('#category_id').select2('destroy');
    $('#brand_id').select2('destroy');
}
</script>

<?php include 'footer.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage_series.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation