/home/hdwebsolution/www/ns-interior/admin-pages/add-edit-sub-category.php
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
include('site-header.php');
?>
<!-- end of LOGO CONTAINER -->
<?php include('left-nevigation.php'); ?>
<script src="ckeditor/ckeditor.js"></script>
<main id="playground">
<?php include('site-top-header.php'); ?>
<?php
include('../connection.php');
$msg = '';
$cate_sub_name = '';
$category_id = '';
$cate_sub_id = '';
$cate_sub_desc = '';
$cate_sub_brf = '';
$cate_sub_para = '';
$home_status = '';
$status = '';
$image = '';
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$category_id = mysqli_real_escape_string($link, $_POST['category_id']);
$name = mysqli_real_escape_string($link, $_POST['category_name']);
$cate_sub_desc = mysqli_real_escape_string($link, $_POST['sub_desc']);
$cate_sub_brf = mysqli_real_escape_string($link, $_POST['sub_brf']);
$cate_sub_para = mysqli_real_escape_string($link, $_POST['sub_para']);
$home_status = mysqli_real_escape_string($link, $_POST['home_status']);
$status = mysqli_real_escape_string($link, $_POST['status']);
// Handle image
if (!empty($_FILES['sub_image']['name'])) {
$targetDir = "uploads/";
if (!file_exists($targetDir)) {
mkdir($targetDir, 0777, true);
}
$fileName = time() . "_" . basename($_FILES['sub_image']['name']);
$targetFile = $targetDir . $fileName;
if (move_uploaded_file($_FILES['sub_image']['tmp_name'], $targetFile)) {
$image = $fileName;
}
} else {
$image = isset($_POST['old_image']) ? $_POST['old_image'] : '';
}
// Insert
if (isset($_POST['sub']) && $_POST['sub'] == 'SUBMIT' && $name !== '' && $category_id !== '') {
$cat_check = mysqli_query($link, "SELECT * FROM tbl_category WHERE cat_id = '$category_id'");
if (mysqli_num_rows($cat_check) > 0) {
$sql_insert = "INSERT INTO `tbl_sub_category`
(`category_id`, `name`, `sub_desc`, `sub_brf`, `sub_para`, `home_status`, `status`, `image`)
VALUES ('$category_id', '$name', '$cate_sub_desc', '$cate_sub_brf', '$cate_sub_para', '$home_status', '$status', '$image')";
if (mysqli_query($link, $sql_insert)) {
$msg = "<p style='color:green;'>Sub Category Saved Successfully!</p>";
} else {
$msg = "<p style='color:red;'>Failed to Save Sub Category. Error: " . mysqli_error($link) . "</p>";
}
} else {
$msg = "<p style='color:red;'>Invalid Category Selected.</p>";
}
}
// Update
if (isset($_POST['updatebtn']) && $_POST['updatebtn'] == 'Update' && $name !== '' && $_POST['cate_sub_id'] !== '' && $category_id !== '') {
$cate_sub_id = mysqli_real_escape_string($link, $_POST['cate_sub_id']);
$sql_update = "UPDATE `tbl_sub_category` SET
`category_id` = '$category_id',
`name` = '$name',
`sub_desc` = '$cate_sub_desc',
`sub_brf` = '$cate_sub_brf',
`sub_para` = '$cate_sub_para',
`home_status` = '$home_status',
`status` = '$status',
`image` = '$image'
WHERE `id` = '$cate_sub_id'";
if (mysqli_query($link, $sql_update)) {
$msg = "<p style='color:green;'>Sub Category Updated Successfully!</p>";
} else {
$msg = "<p style='color:red;'>Failed to Update Sub Category. Error: " . mysqli_error($link) . "</p>";
}
}
}
// Load for edit
if (isset($_GET['edit']) && $_GET['edit'] !== '') {
$id = intval($_GET['edit']);
$sel_sub = mysqli_query($link, "SELECT * FROM tbl_sub_category WHERE id = $id");
if ($rowsubcat = mysqli_fetch_assoc($sel_sub)) {
$category_id = $rowsubcat['category_id'];
$cate_sub_name = $rowsubcat['name'];
$cate_sub_id = $rowsubcat['id'];
$cate_sub_desc = $rowsubcat['sub_desc'];
$cate_sub_brf = $rowsubcat['sub_brf'];
$cate_sub_para = $rowsubcat['sub_para'];
$home_status = $rowsubcat['home_status'];
$status = $rowsubcat['status'];
$image = $rowsubcat['image'];
}
}
?>
<section id="page-title" class="row">
<div class="col-md-8">
<h1>Sub Category</h1>
<p class="lead">Add or Update your Sub Category below.</p>
</div>
</section>
<div class="container-fluid">
<form method="post" enctype="multipart/form-data">
<div class="row">
<div class="col-md-12">
<a href="update-sub-category.php" class="btn btn-primary">Back</a>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="text-danger"><?= $msg; ?></label><br>
<label>Category</label>
<select name="category_id" class="form-control" required>
<option value="">-- Select Category --</option>
<?php
$cat_sql = mysqli_query($link, "SELECT cat_id, cate_name FROM tbl_category ORDER BY cate_name ASC");
while ($cat_row = mysqli_fetch_assoc($cat_sql)) {
$selected = ($cat_row['cat_id'] == $category_id) ? 'selected' : '';
echo "<option value='{$cat_row['cat_id']}' $selected>{$cat_row['cate_name']}</option>";
}
?>
</select>
<label>Sub Category Name</label>
<input type="text" class="form-control" name="category_name"
value="<?= htmlspecialchars($cate_sub_name); ?>"
placeholder="Enter Sub Category Name" required>
</div>
</div>
<!-- Description -->
<div class="col-md-12">
<label>Paragraph </label>
<textarea name="sub_desc" id="ckeditor1" class="form-control"><?= $cate_sub_desc; ?></textarea>
</div>
<!-- Home Status -->
<div class="col-md-12">
<label>Brief Description</label>
<textarea name="home_status" id="ckeditor2" class="form-control"><?= $home_status; ?></textarea>
</div>
<!-- Status -->
<div class="col-md-12">
<label>Tagline</label>
<textarea name="status" id="ckeditor3" class="form-control"><?= $status; ?></textarea>
</div>
<!-- Image -->
<div class="col-md-6">
<label>Image</label>
<input type="file" name="sub_image" class="form-control">
<?php if ($image): ?>
<p>Current: <img src="uploads/<?= $image; ?>" width="100"></p>
<input type="hidden" name="old_image" value="<?= $image; ?>">
<?php endif; ?>
</div>
<div class="col-md-12">
<div class="form-group">
<?php if ($cate_sub_id !== ''): ?>
<input type="hidden" value="<?= htmlspecialchars($cate_sub_id); ?>" name="cate_sub_id">
<input type="submit" class="btn btn-primary" name="updatebtn" value="Update">
<?php else: ?>
<input type="submit" class="btn btn-primary" name="sub" value="SUBMIT">
<?php endif; ?>
</div>
</div>
</div>
</form>
</div>
<script>
CKEDITOR.replace('ckeditor1');
CKEDITOR.replace('ckeditor2');
CKEDITOR.replace('ckeditor3');
CKEDITOR.replace('ckeditor4');
CKEDITOR.replace('ckeditor5');
</script>
<?php include('site-footer.php'); ?>