Server : ApacheSystem : Linux sh00666.bluehost.com 5.14.0-687.26.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jul 14 16:32:02 EDT 2026 x86_64 User : ndkhermy ( 1200) PHP Version : 8.5.12 Disable Function : NONE Directory : /home1/ndkhermy/www/website_358eb648/admin/manage_product/ |
Upload File : |
<?php
include("../function.php");
if($_SESSION['admin_id']==""){
header('location:../login.php');
}
$login_tbl=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM admin WHERE admin_id='".$_SESSION['admin_id']."'"));
// Sidebar strat
include('../include/sidebar.php');
$id=$_REQUEST['id'];
// Sidebar wrap
/*error_reporting(E_ALL);
ini_set('display_errors',1)*/
?>
<!-- Edit data start --->
<?php
if(isset($_POST['edit'])){
$category_id=$_POST['category_id'];
$category_id=str_replace("'", "\'", $category_id);
$subcategory_id=$_POST['subcategory_id'];
$subcategory_id=str_replace("'", "\'", $subcategory_id);
$title1=$_POST['title1'];
$title1=str_replace("'", "\'", $title1);
$about1=$_POST['about1'];
$about1=str_replace("'", "\'", $about1);
$about2=$_POST['about2'];
$about2=str_replace("'", "\'", $about2);
$status=$_POST['status'];
$genrate_url=create_url($title1);
$slug=$genrate_url;
$file_name1=$_FILES['image1']['name'];
$file_tmp1=$_FILES['image1']['tmp_name'];
$file_ext1=strtolower(end(explode('.',$_FILES['image1']['name'])));
if(!empty($file_name1)){
$random_number1 = rand();
$new_file_name1 = $random_number1.'.'.$file_ext1;
$file_path1="../../images/Upload/product/".$new_file_name1;
move_uploaded_file($file_tmp1,$file_path1);
$dlt=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `product_tbl` WHERE id='$id'"));
$dlt_path="../../images/Upload/product/".$dlt['image1'];
unlink($dlt_path);
mysqli_query($conn,"UPDATE `product_tbl` SET `image1`='$new_file_name1' WHERE id='$id'");
}
mysqli_query($conn,
"UPDATE `product_tbl` SET
`category_id`='$category_id',
`subcategory_id`='$subcategory_id',
`title1`='$title1',
`about1`='$about1',
`about2`='$about2',
`slug`='$slug',
`status`='$status' WHERE id='$id'")or die(mysqli_error($conn));
// Handle updates to popular_packages_attributes_tbl
if (isset($_POST['id_editatb']) && is_array($_POST['id_editatb'])) {
foreach ($_POST['id_editatb'] as $key => $id_editatb) {
if (!empty($_FILES['image_editatb']['name'][$key])) {
$imageedit = $_FILES['image_editatb']['name'][$key];
$file_path = "../../images/Upload/product/" . $imageedit;
if (move_uploaded_file($_FILES['image_editatb']['tmp_name'][$key], $file_path)) {
$dlt = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM `product_img_tbl` WHERE id = '$id_editatb'"));
$dlt_path = "../../images/Upload/product/" . $dlt['image_atb'];
if (file_exists($dlt_path)) {
unlink($dlt_path);
}
mysqli_query($conn, "UPDATE `product_img_tbl` SET `image_atb` = '$imageedit' WHERE id = '$id_editatb'");
}
}
}
}
// Handle adding new content to popular_packages_attributes_tbl
if (isset($_FILES['image_atb']['name']) && is_array($_FILES['image_atb']['name'])) {
foreach ($_FILES['image_atb']['name'] as $key => $val) {
$image = $_FILES['image_atb']['name'][$key];
$file_path = "../../images/Upload/product/" . $image;
if (move_uploaded_file($_FILES['image_atb']['tmp_name'][$key], $file_path)) {
echo "INSERT INTO `product_img_tbl` SET
`product_id`='$id',
`image_atb`= '$image'";
mysqli_query($conn, "INSERT INTO `product_img_tbl` SET
`product_id`='$id',
`image_atb`= '$image'");
}
}
}
echo "<script>window.location='show.php?page=product';</script>";
$_SESSION['message']="Record Updated successfully";
}
?>
<!-- Edit data warp --->
<!-- [ Main Content ] start -->
<section class="pcoded-main-container">
<div class="pcoded-content">
<!-- [ breadcrumb ] start -->
<div class="page-header">
<div class="page-block">
<div class="row align-items-center">
<div class="col-md-12">
<div class="page-header-title">
<div class="card-header d-flex justify-content-between">
<button class="btn btn-info btn-sm btn-round has-ripple"><i class="feather icon-edit"></i> Edit | Product</button>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- [ breadcrumb ] end -->
<!-- [ Main Content ] start -->
<div class="row">
<div class="col-md-12">
<div class="card">
<!-- <div class="card-header d-flex justify-content-between">
</div> -->
<div class="card-body">
<?php if(isset($_SESSION['message'])){
echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
<i class="feather icon-thumbs-up text-success"></i> <strong class="text-dark">'.$_SESSION['message'].'</strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['message']);
?>
<?php if(isset($_SESSION['error'])){
echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
<i class="feather icon-alert-triangle text-danger"></i> <strong class="text-dark">'.$_SESSION['error'].'</strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['error']);
?>
<?php if(isset($_SESSION['error_message'])){
echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
<i class="feather icon-alert-triangle text-danger"></i> <strong class="text-dark">'.$_SESSION['error_message'].'</strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['error_message']);
?>
<?php
$fetQuery=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM product_tbl WHERE id='$id'"));
?>
<form method="POST" enctype="multipart/form-data" autocomplete="off" name="AddProduct">
<div class="container">
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="title1">Category</label>
<select class="form-select" name="category_id" id="cat_id">
<option selected disabled>Please Select Category</option>
<?php
$querycat=mysqli_query($conn,"SELECT * FROM product_category ORDER BY ID DESC");
while($fetch_cat=mysqli_fetch_array($querycat)){
?>
<option value="<?=$fetch_cat['id']?>" <?php echo ($fetQuery['category_id'] == $fetch_cat['id']) ? 'selected':''?>><?=$fetch_cat['title']?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="title1">Subcategory</label>
<select class="form-select" name="subcategory_id" id="sub_cat_id">
<option selected disabled>Please Select Subcategory</option>
<?php
$SubcatQry=mysqli_query($conn,"SELECT * FROM product_subcategory_tbl WHERE status=1");
while($row=mysqli_fetch_array($SubcatQry)){
?>
<option value="<?=$row['id']?>" <?=($row['id']==$fetQuery['subcategory_id'])? 'selected':'';?>><?=$row['title_sub']?></option>
<?php } ;?>
</select>
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<label class="form-label" for="title1">Title</label>
<input type="text" name="title1" class="form-control" required value="<?=$fetQuery['title1']?>">
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<label class="form-label" for="about1">Heading</label>
<textarea id="editor1" name="about1"><?=$fetQuery['about1']?></textarea>
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<label class="form-label" for="about2">Description</label>
<textarea id="editor3" name="about2"><?=$fetQuery['about2']?></textarea>
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<label class="form-label" for="status">Status</label>
<select class="form-select" name="status" required>
<option value="" >Please select status</option>
<option value="1" <?=($fetQuery['status']=='1')?'selected':'';?>>Show</option>
<option value="0" <?=($fetQuery['status']=='0')?'selected':'';?>>Hide</option>
</select>
</div>
</div>
<div class="form-group">
<div class="row" id="input-container">
<div class="col-lg-10">
<img src="<?=$base_url?>images/Upload/product/<?=$fetQuery["image1"];?>" style="width:60px; margin: 10px;">
<input type="file" name="image1" class="form-control">
</div>
<div class="col-lg-2 mt-5">
<label for="categories" class=" form-control-label mb-2 text-dark fw-bold">Add More</label>
<a id="myButton" class="bg-success form-control text-center text-dark fw-bold">Add</a>
</div>
</div>
</div>
<!-- Muliple Product images color etc start edit --->
<?php
$attribute=mysqli_query($conn,"SELECT * FROM `product_img_tbl` WHERE product_id='".$_REQUEST['id']."'");
if(mysqli_num_rows($attribute)>0){ ?>
<?php
$Atb=mysqli_query($conn,"SELECT * FROM product_img_tbl WHERE product_id='".$_REQUEST['id']."'");
while($row=mysqli_fetch_array($Atb)){ ?>
<div class="form-group input-element data-item">
<input type="hidden" name="id_editatb[]" class="form-control" required value="<?=$row['id']?>" >
<div class="row">
<div class="col-lg-10">
<img src="<?=$base_url?>images/Upload/product/<?=$row["image_atb"];?>" style="width:60px; margin:10px;">
<input type="file" name="image_editatb[]" class="form-control">
</div>
<div class="col-lg-2 mt-5">
<label for="categories" class=" form-control-label mb-2 text-white">Add More</label>
<a class="bg-danger form-control text-center text-white fw-bold delete-btn" data-id="<?=$row['id']?>">Remove</a>
</div>
</div>
</div>
<?php } ;?>
<?php } else { ?>
<?php } ?>
<!-- Muliple Product images color etc wrap edit --->
</div>
</div>
<div class="row">
<div class="col-md-6">
<input name="edit" type="submit" class="btn btn-danger" value="Update">
<a class="btn btn-secondary" class="text-white" href="show.php?page=product">Back</a>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- [ form-element ] end -->
</div>
<!-- [ Main Content ] end -->
</div>
</section>
<!-- Required Js -->
<?php include('../include/footer.php'); ?>
<script>
$(document).ready(function() {
$("#myButton").click(function() {
$.ajax({
url: "genrate_input.php",
success: function(html) {
$("#input-container").append(html);
}
});
});
});
$(document).on("click", ".remove-input", function() {
$(this).closest(".input-element").remove();
});
</script>
<script>
$(document).ready(function() {
$('#cat_id').on('change', function() {
var cat_id = this.value;
$.ajax({
url: "sub-category.php",
type: "POST",
data: {
cat_id: cat_id
},
cache: false,
success: function(result){
$("#sub_cat_id").html(result);
}
});
});
});
</script>
<script>
$(document).ready(function() {
$('.delete-btn').on('click', function() {
var itemId = $(this).data('id');
var deleteButton = $(this);
$.ajax({
url: 'delete.php',
method: 'POST',
data: { id: itemId },
success: function(response) {
// Handle the response from the server
console.log(response);
// Remove the deleted data from the DOM
deleteButton.closest('.data-item').remove();
},
error: function(xhr, status, error) {
// Handle the error
console.log(error);
}
});
});
});
</script>