Ultra File Manager

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

<?php
session_start();
include('include/config.php');
include('include/admin-menu.php');
if (empty($_SESSION['alogin'])) {
    header('Location: index.php');
    exit();
}

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

$stmt = $con->prepare(
        "INSERT INTO subcategory (categoryid, subcategory) VALUES (?, ?)"
    );
    $stmt->bind_param("is", $_POST['category'], $_POST['subcategory']);

$_SESSION['msg'] = $stmt->execute()
        ? "SubCategory created successfully!"
        : "Failed to create subcategory!";

header("Location: subcategory.php");
    exit();
}

/* ===== DELETE SUBCATEGORY ===== */
if (isset($_GET['del'], $_GET['id'])) {

$id = intval($_GET['id']);
    $stmt = $con->prepare("DELETE FROM subcategory WHERE id=?");
    $stmt->bind_param("i", $id);

$_SESSION['delmsg'] = $stmt->execute()
        ? "SubCategory deleted successfully!"
        : "Delete failed!";

header("Location: subcategory.php");
    exit();
}
?>

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

<div class="card-box">
<h4 class="mb-3"><i class="fa fa-sitemap"></i> Add SubCategory</h4>

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

<form method="post">
<div class="row g-3">
    <div class="col-md-6">
        <label>Category</label>
        <select name="category" class="form-select" required>
            <option value="">Select Category</option>
            <?php
            $q = $con->query("SELECT * FROM category");
            while($c = $q->fetch_assoc()){
                echo "<option value='{$c['id']}'>{$c['categoryName']}</option>";
            }
            ?>
        </select>
    </div>

<div class="col-md-6">
        <label>SubCategory Name</label>
        <input type="text" name="subcategory" class="form-control" required>
    </div>
</div>

<button type="submit" name="submit" class="btn btn-primary mt-3">
    <i class="fa fa-save"></i> Create SubCategory
</button>
</form>
</div>

<div class="card-box">
<h4 class="mb-3"><i class="fa fa-list"></i> Manage SubCategories</h4>

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

<table id="subcatTable" class="table table-bordered table-striped">
<thead>
<tr>
    <th>#</th>
    <th>Category</th>
    <th>SubCategory</th>
    <th>Created</th>
    <th>Updated</th>
    <th width="120">Action</th>
</tr>
</thead>
<tbody>

<?php
$q = $con->query("
    SELECT s.id, c.categoryName, s.subcategory, s.creationDate, s.updationDate
    FROM subcategory s
    JOIN category c ON c.id = s.categoryid
    ORDER BY s.id DESC
");
$cnt = 1;
while($row = $q->fetch_assoc()){
?>
<tr>
<td><?php echo $cnt++; ?></td>
<td><?php echo htmlentities($row['categoryName']); ?></td>
<td><?php echo htmlentities($row['subcategory']); ?></td>
<td><?php echo htmlentities($row['creationDate']); ?></td>
<td><?php echo htmlentities($row['updationDate']); ?></td>
<td>
    <a href="edit-subcategory.php?id=<?php echo $row['id']; ?>" class="btn btn-sm btn-info">
        <i class="fa fa-edit"></i>
    </a>
    <a href="subcategory.php?id=<?php echo $row['id']; ?>&del=1"
       onclick="return confirm('Delete this subcategory?')"
       class="btn btn-sm btn-danger">
        <i class="fa fa-trash"></i>
    </a>
</td>
</tr>
<?php } ?>

</tbody>
</table>
</div>

</div>

</body>
</html>

Ukuran: 4.8 KB