Ultra File Manager

Edit: /home/u523034047/domains/nainitalfloweritech.com/public_html/admin/edit-subcategory.php

<?php
session_start();
include('include/config.php');
include('include/admin-menu.php');

if (empty($_SESSION['alogin'])) {
    header('Location: index.php');
    exit();
}

date_default_timezone_set('Asia/Kolkata');
$currentTime = date('Y-m-d H:i:s');

$id = intval($_GET['id']);

/* ===== UPDATE SUBCATEGORY ===== */
if (isset($_POST['submit'])) {

$stmt = $con->prepare(
        "UPDATE subcategory 
         SET categoryid=?, subcategory=?, updationDate=? 
         WHERE id=?"
    );

$stmt->bind_param(
        "issi",
        $_POST['category'],
        $_POST['subcategory'],
        $currentTime,
        $id
    );

$_SESSION['msg'] = $stmt->execute()
        ? "SubCategory updated successfully!"
        : "Update failed!";

header("Location: edit-subcategory.php?id=".$id);
    exit();
}

/* ===== FETCH SUBCATEGORY ===== */
$stmt = $con->prepare("
    SELECT s.subcategory, c.id AS cid, c.categoryName
    FROM subcategory s
    JOIN category c ON c.id = s.categoryid
    WHERE s.id = ?
");
$stmt->bind_param("i", $id);
$stmt->execute();
$row = $stmt->get_result()->fetch_assoc();
?>

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Edit SubCategory | Admin</title>
<meta name="viewport" content="width=device-width, initial-scale=1">

<h4 class="mb-3">
    <i class="fa fa-edit"></i> Edit SubCategory
</h4>

<?php if(!empty($_SESSION['msg'])){ ?>
<div class="alert alert-success text-center">
    <?php echo $_SESSION['msg']; $_SESSION['msg']=""; ?>
</div>
<?php } ?>

<div class="mb-3">
    <label class="form-label">Category</label>
    <select name="category" class="form-select" required>
        <option value="<?php echo $row['cid']; ?>">
            <?php echo htmlentities($row['categoryName']); ?>
        </option>
        <?php
        $cats = $con->query("SELECT * FROM category");
        while($c = $cats->fetch_assoc()){
            if ($c['id'] != $row['cid']) {
                echo "<option value='{$c['id']}'>{$c['categoryName']}</option>";
            }
        }
        ?>
    </select>
</div>

<div class="mb-3">
    <label class="form-label">SubCategory Name</label>
    <input type="text"
           name="subcategory"
           value="<?php echo htmlentities($row['subcategory']); ?>"
           class="form-control"
           required>
</div>

<button type="submit" name="submit" class="btn btn-primary w-100">
    <i class="fa fa-save"></i> Update SubCategory
</button>

<a href="subcategory.php" class="btn btn-link w-100 mt-2">
    ← Back to SubCategory List
</a>

</form>

</div>
</div>
</body>
</html>

Ukuran: 3.3 KB