/home/hdwebsolution/www/ns-interior/admin-pages/add-products.php
<?php
include('site-header.php');
include('left-nevigation.php');
include('site-top-header.php');
$msg = "";
$editMode = isset($_GET['edit']);
$editId = $editMode ? intval($_GET['edit']) : 0;
$product = [
'pro_category' => '',
'pro_name' => '',
'pro_type' => '',
'pro_offer' => '',
'pro_desc' => '',
'pro_brf' => '',
'pro_more' => '',
'dp_rate' => '',
'percentage' => '',
'pro_image' => ''
];
if ($editMode) {
$sel = mysqli_query($link, "SELECT * FROM tbl_product WHERE pro_id = $editId");
if ($sel && mysqli_num_rows($sel) > 0) {
$product = mysqli_fetch_assoc($sel);
}
}
if (isset($_POST['sub']) || isset($_POST['upd'])) {
$category_id = intval($_POST['category_id']);
$pro_name = mysqli_real_escape_string($link, $_POST['pro_name']);
$pro_type = mysqli_real_escape_string($link, $_POST['pro_type']);
$pro_offer = $_POST['pro_offer'];
$pro_desc = $_POST['pro_desc'];
$pro_brf = $_POST['pro_brf'];
$pro_more = $_POST['pro_more'];
$dp_rate = $_POST['dp_rate'];
$percentage = $_POST['percentage'];
$fnn = $product['pro_image'];
// Handle image upload
if (!empty($_FILES['att']['name'])) {
$tmp = $_FILES['att']['tmp_name'];
$fn = $_FILES['att']['name'];
$ext = pathinfo($fn, PATHINFO_EXTENSION);
$fnn = rand() . '.' . $ext;
move_uploaded_file($tmp, "../product-image/$fnn");
if ($editMode && !empty($product['pro_image'])) {
@unlink("../product-image/" . $product['pro_image']);
}
}
if ($editMode) {
$update_sql = "UPDATE tbl_product SET
pro_category = '$category_id',
pro_name = '$pro_name',
pro_type = '$pro_type',
pro_offer = '$pro_offer',
pro_desc = '$pro_desc',
pro_brf = '$pro_brf',
pro_more = '$pro_more',
dp_rate = '$dp_rate',
percentage = '$percentage',
pro_image = '$fnn'
WHERE pro_id = $editId";
if (mysqli_query($link, $update_sql)) {
$msg = "<p style='color:green;'>Product updated successfully!</p>";
} else {
$msg = "<p style='color:red;'>Update Failed: " . mysqli_error($link) . "</p>";
}
} else {
$insert_sql = "INSERT INTO tbl_product (
pro_category, pro_name, pro_type, pro_offer,
pro_desc, pro_brf, pro_more, dp_rate, percentage, pro_image
) VALUES (
'$category_id', '$pro_name', '$pro_type', '$pro_offer',
'$pro_desc', '$pro_brf', '$pro_more', '$dp_rate', '$percentage', '$fnn'
)";
if (mysqli_query($link, $insert_sql)) {
$msg = "<p style='color:green;'>Product inserted successfully!</p>";
} else {
$msg = "<p style='color:red;'>Insert Failed: " . mysqli_error($link) . "</p>";
}
}
}
?>
<main id="playground">
<section id="page-title" class="row">
<div class="col-md-8">
<h1><?= $editMode ? 'Edit Product' : 'Add Product' ?></h1>
<div class="col-md-12">
<a href="show-product.php#<?=$_GET['edit'];?>" class="btn btn-primary">Back</a>
</div>
</div>
</section>
<div class="container-fluid">
<?= @$msg ?>
<form method="post" enctype="multipart/form-data">
<div class="row">
<div class="col-md-6">
<!-- Category -->
<div class="form-group">
<label>Category:</label>
<select class="form-control" name="category_id" id="category_id" required>
<option value="">-- Select Category --</option>
<?php
$cat_sql = mysqli_query($link, "SELECT * FROM tbl_category ORDER BY cate_name ASC");
while ($row = mysqli_fetch_assoc($cat_sql)) {
$selected = $row['cat_id'] == $product['pro_category'] ? 'selected' : '';
echo "<option value='{$row['cat_id']}' $selected>{$row['cate_name']}</option>";
}
?>
</select>
</div>
<!-- Product Name -->
<div class="form-group">
<label>Product Name:</label>
<input class="form-control" type="text" name="pro_name" value="<?= htmlspecialchars($product['pro_name']) ?>" required>
</div>
<!-- Image -->
<div class="form-group">
<label>Image:</label>
<input class="form-control" type="file" name="att">
<?php if ($product['pro_image']) : ?>
<br><img src="../product-image/<?= $product['pro_image'] ?>" width="100">
<?php endif; ?>
</div>
<div class="form-group">
<label>Meta Title:</label>
<input class="form-control" type="text" name="pro_type" value="<?= $product['pro_type'] ?>">
</div>
<div class="form-group">
<label>Meta Description:</label>
<input class="form-control" type="text" name="dp_rate" value="<?= $product['dp_rate'] ?>">
</div>
<div class="form-group">
<label>Meta Keywords:</label>
<input class="form-control" type="text" name="percentage" value="<?= $product['percentage'] ?>">
</div>
</div>
<div class="col-md-12">
<!--<div class="form-group">-->
<!-- <label>Product Paragraph:</label>-->
<!-- <textarea class="form-control" name="pro_offer" id="ckeditor1"><?= $product['pro_offer'] ?></textarea>-->
<!--</div>-->
<!--<div class="form-group">-->
<!-- <label>Description:</label>-->
<!-- <textarea class="form-control" name="pro_more" id="ckeditor2"><?= $product['pro_more'] ?></textarea>-->
<!--</div>-->
<div class="form-group">
<label>Short Description:</label>
<textarea class="form-control" name="pro_desc" id="ckeditor1"><?= $product['pro_desc'] ?></textarea>
</div>
<div class="form-group">
<label>Long Description:</label>
<textarea class="form-control" name="pro_brf" id="ckeditor2"><?= $product['pro_brf'] ?></textarea>
</div>
</div>
<div class="col-md-12 text-center">
<input type="submit" name="<?= $editMode ? 'upd' : 'sub' ?>" value="<?= $editMode ? 'UPDATE' : 'SUBMIT' ?>" class="btn btn-success">
</div>
</div>
</form>
</div>
<script src="ckeditor/ckeditor.js"></script>
<script>
document.getElementById('category_id').addEventListener('change', function () {
let cat_id = this.value;
let subCatSelect = document.getElementById('sub_category_id');
subCatSelect.innerHTML = "<option>Loading...</option>";
fetch('get-subcategories.php?cat_id=' + cat_id)
.then(response => response.text())
.then(data => {
subCatSelect.innerHTML = data;
})
.catch(err => {
console.error('Fetch error:', err);
subCatSelect.innerHTML = "<option>Error loading</option>";
});
});
</script>
<script>
CKEDITOR.replace('ckeditor1');
CKEDITOR.replace('ckeditor2');
CKEDITOR.replace('ckeditor3');
CKEDITOR.replace('ckeditor4');
</script>
<?php include('site-footer.php'); ?>