Ultra File Manager

Edit: /home/u523034047/domains/nainitalfloweritech.com/public_html/admin/category.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');

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

$stmt = $con->prepare(
        "INSERT INTO category (categoryName, categoryDescription) VALUES (?, ?)"
    );
    $stmt->bind_param("ss", $_POST['category'], $_POST['description']);

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

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

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

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

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

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

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

<div class="card-box">
<h4 class="mb-3"><i class="fa fa-folder-plus"></i> Add Category</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 Name</label>
        <input type="text" name="category" class="form-control" required>
    </div>
    <div class="col-md-6">
        <label>Description</label>
        <textarea name="description" class="form-control" rows="2"></textarea>
    </div>
</div>

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

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

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

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

<?php
$q = $con->query("SELECT * FROM category ORDER BY 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['categoryDescription']); ?></td>
<td><?php echo htmlentities($row['creationDate']); ?></td>
<td><?php echo htmlentities($row['updationDate']); ?></td>
<td>
    <a href="edit-category.php?id=<?php echo $row['id']; ?>" class="btn btn-sm btn-info">
        <i class="fa fa-edit"></i>
    </a>
    <a href="category.php?id=<?php echo $row['id']; ?>&del=1"
       onclick="return confirm('Delete this category?')"
       class="btn btn-sm btn-danger">
        <i class="fa fa-trash"></i>
    </a>
</td>
</tr>
<?php } ?>

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

</div>

</body>
</html>

Ukuran: 4.4 KB