134 lines
6.6 KiB
PHP
134 lines
6.6 KiB
PHP
|
<?php include('container/security.php');?>
|
||
|
|
<!DOCTYPE html>
|
||
|
|
<html lang="en" data-theme="light">
|
||
|
|
<head>
|
||
|
|
<!-- head links start -->
|
||
|
|
<?php include 'container/head_links.php';?>
|
||
|
|
<!-- head links start -->
|
||
|
|
</head>
|
||
|
|
<body>
|
||
|
|
<!-- side_bar start -->
|
||
|
|
<?php include 'container/side_bar.php' ?>
|
||
|
|
<!-- side_bar end -->
|
||
|
|
<main class="dashboard-main">
|
||
|
|
<!-- Header start -->
|
||
|
|
<?php include 'container/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">Manage AI Tool Cateogory</h6>
|
||
|
|
<ul class="d-flex align-items-center gap-2">
|
||
|
|
<li class="fw-medium">
|
||
|
|
<a href="index-2.html" class="d-flex align-items-center gap-1 hover-text-primary">
|
||
|
|
<iconify-icon icon="solar:home-smile-angle-outline" class="icon text-lg"></iconify-icon>
|
||
|
|
Dashboard
|
||
|
|
</a>
|
||
|
|
</li>
|
||
|
|
<li>-</li>
|
||
|
|
<li class="fw-medium">Manage Cateogory</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
<?php
|
||
|
|
// Get the ID from the URL
|
||
|
|
if (isset($_GET['id'])) {
|
||
|
|
$id = intval($_GET['id']); // Get the category ID from the URL
|
||
|
|
|
||
|
|
// Fetch the category data from the database using mysqli_query
|
||
|
|
$qry = "SELECT * FROM categories WHERE id = $id";
|
||
|
|
$run = mysqli_query($conn, $qry);
|
||
|
|
|
||
|
|
// Check if the category exists
|
||
|
|
if (mysqli_num_rows($run) > 0) {
|
||
|
|
$row = mysqli_fetch_assoc($run); // Get the category data
|
||
|
|
} else {
|
||
|
|
echo "Category not found.";
|
||
|
|
exit;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
<div class="row gy-4">
|
||
|
|
<div class="col-md-12">
|
||
|
|
<div class="card">
|
||
|
|
<div class="card-header">
|
||
|
|
<h5 class="card-title mb-0">Edit Category</h5>
|
||
|
|
</div>
|
||
|
|
<div class="card-body">
|
||
|
|
<form action="" method="POST" enctype="multipart/form-data">
|
||
|
|
<div class="row gy-3">
|
||
|
|
<div class="col-4">
|
||
|
|
<label class="form-label">Category EN Name</label>
|
||
|
|
<input type="text" name="c_name" class="form-control" required placeholder="Enter Category EN Name" value="<?= isset($row['c_name']) ? $row['c_name'] : ''; ?>">
|
||
|
|
</div>
|
||
|
|
<div class="col-4">
|
||
|
|
<label class="form-label">Category CN Name</label>
|
||
|
|
<input type="text" name="cn_name" class="form-control" required placeholder="Enter Category CN Name" value="<?= isset($row['cn_name']) ? $row['cn_name'] : ''; ?>">
|
||
|
|
</div>
|
||
|
|
<div class="col-4">
|
||
|
|
<label class="form-label">Category Icon</label>
|
||
|
|
<input type="file" name="c_icon" class="form-control">
|
||
|
|
<!-- Show existing icon -->
|
||
|
|
<?php if (isset($row['c_icon'])): ?>
|
||
|
|
<img src="<?= $row['c_icon']; ?>" alt="Category Icon" width="50">
|
||
|
|
<?php endif; ?>
|
||
|
|
</div>
|
||
|
|
<div class="col-12">
|
||
|
|
<label class="form-label">Description EN</label>
|
||
|
|
<textarea name="description" class="form-control" rows="5" placeholder="Write EN Description"><?= isset($row['description']) ? $row['description'] : ''; ?></textarea>
|
||
|
|
</div>
|
||
|
|
<div class="col-12">
|
||
|
|
<label class="form-label">Description CN</label>
|
||
|
|
<textarea name="cn_description" class="form-control" rows="5" placeholder="Write CN Description"><?= isset($row['cn_description']) ? $row['cn_description'] : ''; ?></textarea>
|
||
|
|
</div>
|
||
|
|
<div class="col-12">
|
||
|
|
<button type="submit" class="btn btn-primary mt-3">Update Category</button>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</form>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<?php include 'container/footer.php' ?>
|
||
|
|
</main>
|
||
|
|
<!-- Footer Links Start -->
|
||
|
|
<?php include 'container/footer_links.php' ?>
|
||
|
|
<script>
|
||
|
|
let table = new DataTable('#dataTable');
|
||
|
|
</script>
|
||
|
|
</body>
|
||
|
|
</html>
|
||
|
|
<?php
|
||
|
|
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
|
||
|
|
// Collect the form data
|
||
|
|
$c_name = mysqli_real_escape_string($conn, $_POST['c_name']);
|
||
|
|
$cn_name = mysqli_real_escape_string($conn, $_POST['cn_name']);
|
||
|
|
$description = mysqli_real_escape_string($conn, $_POST['description']);
|
||
|
|
$cn_description = mysqli_real_escape_string($conn, $_POST['cn_description']);
|
||
|
|
|
||
|
|
// File upload handling for category icon
|
||
|
|
if ($_FILES['c_icon']['name']) {
|
||
|
|
$icon_name = time() . '-' . $_FILES['c_icon']['name'];
|
||
|
|
$target_dir = "assets/images/cat_icons/";
|
||
|
|
$target_file = $target_dir . basename($icon_name);
|
||
|
|
|
||
|
|
// Move uploaded file to the target directory
|
||
|
|
if (move_uploaded_file($_FILES['c_icon']['tmp_name'], $target_file)) {
|
||
|
|
// Update the icon field in the database if the upload is successful
|
||
|
|
$icon_qry = "UPDATE categories SET c_icon = '$icon_name' WHERE id = $id";
|
||
|
|
mysqli_query($conn, $icon_qry);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
// Update the category data in the database
|
||
|
|
$update_qry = "UPDATE categories SET c_name = '$c_name', cn_name = '$cn_name', description = '$description', cn_description = '$cn_description' WHERE id = $id";
|
||
|
|
|
||
|
|
if (mysqli_query($conn, $update_qry)) {
|
||
|
|
echo "<script>alert('Category updated successfully'); window.location.href = 'category_edit?id=$id';</script>"; // Redirect to dashboard after success
|
||
|
|
} else {
|
||
|
|
echo "Error updating category: " . mysqli_error($conn);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
?>
|