D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
siliguritoys.com
/
slgadmintoys
/
Filename :
edit_category.php
back
Copy
<?php include 'config.php'; if (isset($_GET['id'])) { $id = intval($_GET['id']); $query = "SELECT * FROM product_category WHERE category_id = $id"; $result = mysqli_query($conn, $query); $category = mysqli_fetch_assoc($result); if (!$category) { echo "<script>alert('Category not found!'); window.location.href='categories.php';</script>"; exit(); } } else { echo "<script>window.location.href='categories.php';</script>"; exit(); } if ($_SERVER["REQUEST_METHOD"] == "POST") { $category_name = mysqli_real_escape_string($conn, $_POST['category_name']); $category_desc = mysqli_real_escape_string($conn, $_POST['category_desc']); $category_status = mysqli_real_escape_string($conn, $_POST['category_status']); $created_at = date('Y-m-d H:i:s'); // Image Upload Handling $category_image = $category['category_image']; if (!empty($_FILES["category_image"]["name"])) { $target_dir = "uploads/"; $file_name = time() . '_' . basename($_FILES["category_image"]["name"]); $target_file = $target_dir . $file_name; if (move_uploaded_file($_FILES["category_image"]["tmp_name"], $target_file)) { $category_image = $file_name; } else { echo "<p class='text-danger'>Failed to upload image.</p>"; } } // Update query $update_query = "UPDATE product_category SET category_name='$category_name', category_desc='$category_desc', category_image='$category_image', category_status='$category_status', created_at='$created_at' WHERE category_id=$id"; if (mysqli_query($conn, $update_query)) { echo "<script>window.location.href='categories.php';</script>"; exit(); } else { echo "<p class='text-danger'>Error: " . mysqli_error($conn) . "</p>"; } } ?> <!DOCTYPE html> <html lang="en" data-theme="light"> <head> <?php include 'style.php'; ?> </head> <body> <?php include 'sidebar.php'; ?> <main class="dashboard-main"> <?php include 'header.php'; ?> <div class="dashboard-main-body"> <div class="d-flex flex-wrap align-items-center justify-content-between gap-3 mb-24"> <h6 class="fw-semibold mb-0">Edit Category</h6> </div> <div class="row gy-4"> <div class="col-md-12"> <div class="card"> <div class="card-body"> <form method="POST" enctype="multipart/form-data"> <div class="row gy-3"> <div class="col-12"> <label class="form-label">Name</label> <input type="text" name="category_name" class="form-control" value="<?php echo htmlspecialchars($category['category_name']); ?>" required> </div> <div class="col-12"> <label class="form-label">Description</label> <textarea name="category_desc" class="form-control" rows="4" required><?php echo htmlspecialchars($category['category_desc']); ?></textarea> </div> <div class="col-12"> <label class="form-label">Category Image</label> <input class="form-control" type="file" name="category_image"> <?php if (!empty($category['category_image'])): ?> <img src="uploads/<?php echo $category['category_image']; ?>" alt="Category Image" width="100"> <?php endif; ?> </div> <div class="col-12"> <label class="form-label">Status</label> <select class="form-select" name="category_status" required> <option value="Active" <?php echo ($category['category_status'] == 'Active') ? 'selected' : ''; ?>>Active</option> <option value="Inactive" <?php echo ($category['category_status'] == 'Inactive') ? 'selected' : ''; ?>>Inactive</option> </select> </div> <div class="col-12"> <button type="submit" class="btn btn-primary w-100">Update</button> </div> </div> </form> </div> </div> </div> </div> </div> <?php include 'footer.php'; ?> </body> </html>