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_6031bb72/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');
// Sidebar wrap
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(0);
?>
<style type="text/css">
.multiselect {
/* width: 256px;*/
margin-top: 5px;
margin-left: 9px;
margin-bottom: 18px;
}
.selectBox {
position: relative;
}
.selectBox select {
width: 100%;
padding: 10px;
/*font-weight: bold;*/
}
.overSelect {
position: absolute;
left: 0;
right: 0;
top: 0;
bottom: 0;
}
#Deal_Types_checkboxes {
display: none;
border: 1px #dadada solid;
max-height: 150px;
overflow-y: auto;
}
#Deal_Types_checkboxes label {
display: block;
}
#Deal_Types_checkboxes label:hover {
background-color: #f2a60e78;
}
#Deal_Types_search {
width: 100%;
box-sizing: border-box;
padding: 8px;
margin-bottom: 10px;
border: 1px solid #ccc;
}
#Property_Types_checkboxes {
display: none;
border: 1px #dadada solid;
max-height: 150px;
overflow-y: auto;
}
#Property_Types_checkboxes label {
display: block;
}
#Property_Types_checkboxes label:hover {
background-color: #f2a60e78;
}
#Property_Types_search {
width: 100%;
box-sizing: border-box;
padding: 8px;
margin-bottom: 10px;
border: 1px solid #ccc;
}
</style>
<!-- [ 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-dark text-light fw-bold btn-sm btn-round has-ripple"><i class="feather icon-edit"></i> Upadte 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['img_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['img_error'] . '</strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['img_error']);
?>
<form method="POST" enctype="multipart/form-data" autocomplete="off">
<?php
$fetchData = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM product_tbl WHERE id='" . $_REQUEST['id'] . "'"));
?>
<div class="container">
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="cat_id">Product Brands</label>
<select class="form-select" name="cat_id" required id="cat_id">
<option value="">Please select Area</option>
<?php
$catQry = mysqli_query($conn, "SELECT * FROM category_tbl WHERE status=1 ORDER BY id ASC");
while ($row = mysqli_fetch_array($catQry)) {
?>
<option value="<?= $row['id'] ?>" <?= ($row['id'] == $fetchData['cat_id']) ? 'selected' : ''; ?>><?= $row['title'] ?></option>
<?php }; ?>
</select>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="sub_cat_id">Product Models</label>
<select class="form-select" name="sub_cat_id" required id="sub_cat_id">
<option value="">Please select City</option>
<?php
$sub_catQry = mysqli_query($conn, "SELECT * FROM sub_category_tbl WHERE status=1 AND cat_id='" . $fetchData['cat_id'] . "' ORDER BY id ASC");
while ($row_sub_cat = mysqli_fetch_array($sub_catQry)) {
?>
<option value="<?= $row_sub_cat['id'] ?>" <?= ($row_sub_cat['id'] == $fetchData['sub_cat_id']) ? 'selected' : ''; ?>><?= $row_sub_cat['title'] ?></option>
<?php }; ?>
</select>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="title">Product Name</label>
<input type="text" name="title" class="form-control" value="<?= $fetchData['title'] ?>" required>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="title">Product Name Arabic</label>
<input type="text" name="title_ar" class="form-control" value="<?= $fetchData['title_ar'] ?>" required>
</div>
</div>
<!-- Deal Types start --->
<!-- <div class="col-md-6">
<div class="multiselect">
<label class="form-label" for="Deal_Types">Deal Types</label>
<div class="selectBox" onclick="showDeal_TypesCheckboxes()">
<select id="Deal_Types_select">
<option>Select Deal_Types</option>
</select>
<div class="overSelect"></div>
</div>
<div id="Deal_Types_checkboxes">
<input type="text" id="Deal_Types_search" onkeyup="filterDeal_Types()" placeholder="Search Deal_Types ...">
</?php
$Deal_TypesQuery = mysqli_query($conn, "SELECT * FROM deal_type_tbl WHERE status=1");
while ($row = mysqli_fetch_array($Deal_TypesQuery)) {
$Deal_Types_ids = explode(',', $fetchData['deal_id']);
if (in_array($row['id'], $Deal_Types_ids)) {
$checked = "checked";
} else {
$checked = "";
}
?>
<label for="Deal_Types</?= $row['id'] ?>" style="font-size: 15px; padding: 10px;">
<input type="checkbox" id="Deal_Types</?= $row['id'] ?>" value="</?= $row['id'] ?>" class="mx-2" name="Deal_Types_atb[]" onchange="updateDeal_TypesSelectBox();" </?= $checked ?> /></?= $row['title'] ?>
</label>
</?php } ?>
</div>
</div>
</div> -->
<!-- Deal Types ends --->
<!-- Product Types start --->
<!-- <div class="col-md-6">
<div class="multiselect">
<label class="form-label" for="Product Types">Product Types</label>
<div class="selectBox" onclick="showProperty_TypesCheckboxes()">
<select id="Property_Types_select">
<option>Select Product Types</option>
</select>
<div class="overSelect"></div>
</div>
<div id="Property_Types_checkboxes">
<input type="text" id="Property_Types_search" onkeyup="filterProperty_Types()" placeholder="Search Product Types ...">
</?php
$SizesQuery = mysqli_query($conn, "SELECT * FROM property_type_tbl WHERE status=1");
while ($row = mysqli_fetch_array($SizesQuery)) {
$Property_Types_ids = explode(',', $fetchData['property_types_id']);
if (in_array($row['id'], $Property_Types_ids)) {
$checked = "checked";
} else {
$checked = "";
}
?>
<label for="Property_Types</?= $row['id'] ?>" style="font-size: 15px; padding: 10px;">
<input type="checkbox" id="Property_Types</?= $row['id'] ?>" value="</?= $row['id'] ?>" class="mx-2" name="Property_Types_atb[]" onchange="updateProperty_TypesSelectBox();" </?= $checked ?> /></?= $row['title'] ?>
</label>
</?php } ?>
</div>
</div>
</div> -->
<!-- Product Types ends --->
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Model Code">Model Code</label>
<input type="text" name="model_code" class="form-control" value="<?= $fetchData['model_code'] ?>" required>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Model Year">Model Year</label>
<input type="text" name="model_year" class="form-control" value="<?= $fetchData['model_year'] ?>" required>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="Part Number">Part Number</label>
<input type="text" name="part_no" class="form-control" value="<?= $fetchData['part_no'] ?>" required>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="Part Grade">Part Grade</label>
<input type="text" name="part_grade" class="form-control" value="<?= $fetchData['part_grade'] ?>" required>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="Part Grade Arabic">Part Grade Arabic</label>
<input type="text" name="part_grade_ar" class="form-control" value="<?= $fetchData['part_grade_ar'] ?>" required>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="old_price">Old Price</label>
<input type="text" name="old_price" oninput="FillNumber(this)" value="<?= $fetchData['old_price'] ?>" class="form-control">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="price">Price</label>
<input type="text" name="price" oninput="FillNumber(this)" class="form-control" value="<?= $fetchData['price'] ?>" required>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="quantity">Quantity</label>
<input type="text" name="quantity" oninput="FillNumber(this)" value="<?= $fetchData['quantity'] ?>" class="form-control" required>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="short_description">Description</label>
<textarea id="editor1" name="short_description"><?= $fetchData['short_description'] ?></textarea>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="short_description">Description Arabic</label>
<textarea id="editor2" name="short_description_ar"><?= $fetchData['short_description_ar'] ?></textarea>
</div>
</div>
<div class="form-group">
<div class="row" id="input-container">
<div class="col-lg-10">
<label class="form-label" for="Image">Image </label>
<input type="file" name="image1" class="form-control">
<img src="<?= $base_url ?>images/Upload/product/<?= $fetchData["image1"]; ?>" style="width:100px; height: 60px; margin: 10px;">
</div>
<div class="col-lg-2">
<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-white fw-bold">Add</a>
</div>
</div>
</div>
<!-- Muliple Product images 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">
<label class="form-label" for="Image">Image </label>
<input type="file" name="image_editatb[]" class="form-control">
<?php
$file_ext = strtolower(pathinfo($row["image_atb"], PATHINFO_EXTENSION));
if (in_array($file_ext, ['jpg', 'jpeg', 'png', 'gif', 'webp', 'avif'])) {
echo '<img src="' . $base_url . 'images/Upload/product/' . $row["image_atb"] . '" style="width:60px; margin:10px;">';
} elseif (in_array($file_ext, ['mp4', 'mkv', 'webm', 'ogg'])) {
echo '<video width="200" controls style="margin:10px;">
<source src="' . $base_url . 'images/Upload/product/' . $row["image_atb"] . '" type="video/' . $file_ext . '">
</video>';
} else {
echo '<p>Unsupported file format</p>';
}
?>
</div>
<div class="col-lg-2">
<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 etc wrap edit --->
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Description1">Description1</label>
<textarea id="editor3" name="description1"><?= $fetchData['description1'] ?></textarea>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Description1 Arabic">Description1 Arabic</label>
<textarea id="editor4" name="description1_ar"><?= $fetchData['description1_ar'] ?></textarea>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="Shipping Status">Shipping Company</label>
<select class="form-select" name="shipping_status" id="shipping_status" required>
<option value="0">Select Shipping Company</option>
<?php
$catQry_shipping = mysqli_query($conn, "SELECT * FROM shipping_tbl WHERE status=1 ORDER BY id ASC");
while ($row_shipping = mysqli_fetch_array($catQry_shipping)) {
?>
<option value="<?=$row_shipping['id']?>" <?=($row_shipping['id']==$fetchData['shipping_status'])?'selected':''?>><?=$row_shipping['title']?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="shipping_price">Price</label>
<input type="text" name="shipping_price" oninput="FillNumber(this)" class="form-control" value="<?=$fetchData['shipping_price']?>" required>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="Vat Status">Vat Status</label>
<select class="form-select" name="vat_status" id="vat_status" required>
<option value="0" <?= ($fetchData['vat_status'] == 0) ? 'selected' : ''; ?>>Hide</option>
<option value="1" <?= ($fetchData['vat_status'] == 1) ? 'selected' : ''; ?>>Show</option>
</select>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="Shipping Status">Shipping Status</label>
<select class="form-select" name="shipping_include" id="shipping_include" required>
<option value="0" <?= ($fetchData['shipping_include'] == 0) ? 'selected' : ''; ?>>Include</option>
<option value="1" <?= ($fetchData['shipping_include'] == 1) ? 'selected' : ''; ?>>Free</option>
</select>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="Front Status">Front Status</label>
<select class="form-select" name="opportunities_status" id="opportunities_status" required>
<option value="0" <?= ($fetchData['opportunities_status'] == 0) ? 'selected' : ''; ?>>Hide</option>
<option value="1" <?= ($fetchData['opportunities_status'] == 1) ? 'selected' : ''; ?>>Show</option>
</select>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="status">Status</label>
<select class="form-select" name="status" id="status" required>
<option value="1" <?= ($fetchData['status'] == 1) ? 'selected' : ''; ?>>Show</option>
<option value="0" <?= ($fetchData['status'] == 0) ? 'selected' : ''; ?>>Hide</option>
</select>
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<button name="edit" type="submit" class="btn btn-success">Update</button>
<a class="text-white btn btn-secondary " href="show.php?page=pro">Back</a>
</div>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- [ form-element ] end -->
</div>
<!-- [ Main Content ] end -->
</div>
</section>
<!-- Required Js -->
<?php include('../include/footer.php'); ?>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$('#cat_id').on('change', function() {
var area_id = this.value;
$.ajax({
url: "city-ajax.php",
type: "POST",
data: {
area_id: area_id
},
cache: false,
success: function(result) {
$("#sub_cat_id").html(result);
}
});
});
});
</script>
<!-- ///////// Image ///////////// -->
<script>
$(document).ready(function() {
$("#myButton").click(function() {
$.ajax({
url: "generate_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() {
$(".delete-btn").click(function() {
var id = $(this).data("id");
var deleteButton = $(this);
$.ajax({
url: "delete.php",
type: "POST",
data: {
id: id
},
success: function(response) {
deleteButton.closest('.data-item').remove();
}
});
});
});
</script>
<!-- //////////// Deal Types /////////// -->
<!-- <script>
function updateDeal_TypesSelectBox() {
var checkboxes = document.querySelectorAll('input[name="Deal_Types_atb[]"]:checked');
var selectBox = document.getElementById("Deal_Types_select");
if (checkboxes.length > 0) {
selectBox.options[0].text = checkboxes.length + " selected";
} else {
selectBox.options[0].text = "Select Deal_Types";
}
}
// Initial call to update the select box text based on the pre-checked checkboxes
document.addEventListener("DOMContentLoaded", function() {
updateDeal_TypesSelectBox();
});
var Deal_Types_expanded = false;
function showDeal_TypesCheckboxes() {
var checkboxes = document.getElementById("Deal_Types_checkboxes");
var checkboxItems = checkboxes.getElementsByTagName("input");
if (!Deal_Types_expanded) {
if (checkboxItems.length > 0) {
checkboxes.style.display = "block";
Deal_Types_expanded = true;
}
} else {
checkboxes.style.display = "none";
Deal_Types_expanded = false;
}
}
function filterDeal_Types() {
var input = document.getElementById("Deal_Types_search");
var filter = input.value.toLowerCase();
var checkboxes = document.getElementById("Deal_Types_checkboxes");
var labels = checkboxes.getElementsByTagName("label");
for (var i = 0; i < labels.length; i++) {
var label = labels[i];
var text = label.textContent || label.innerText;
if (text.toLowerCase().indexOf(filter) > -1) {
label.style.display = "";
} else {
label.style.display = "none";
}
}
}
</script> -->
<!-- //////////// Property Types /////////// -->
<!-- <script>
function updateProperty_TypesSelectBox() {
var checkboxes = document.querySelectorAll('input[name="Property_Types_atb[]"]:checked');
var selectBox = document.getElementById("Property_Types_select");
if (checkboxes.length > 0) {
selectBox.options[0].text = checkboxes.length + " selected";
} else {
selectBox.options[0].text = "Select Property Types";
}
}
// Initial call to update the select box text based on the pre-checked checkboxes
document.addEventListener("DOMContentLoaded", function() {
updateProperty_TypesSelectBox();
});
var Property_Types_expanded = false;
function showProperty_TypesCheckboxes() {
var checkboxes = document.getElementById("Property_Types_checkboxes");
var checkboxItems = checkboxes.getElementsByTagName("input");
if (!Property_Types_expanded) {
if (checkboxItems.length > 0) {
checkboxes.style.display = "block";
Property_Types_expanded = true;
}
} else {
checkboxes.style.display = "none";
Property_Types_expanded = false;
}
}
function filterProperty_Types() {
var input = document.getElementById("Property_Types_search");
var filter = input.value.toLowerCase();
var checkboxes = document.getElementById("Property_Types_checkboxes");
var labels = checkboxes.getElementsByTagName("label");
for (var i = 0; i < labels.length; i++) {
var label = labels[i];
var text = label.textContent || label.innerText;
if (text.toLowerCase().indexOf(filter) > -1) {
label.style.display = "";
} else {
label.style.display = "none";
}
}
}
</script> -->
<?php
if (isset($_POST['edit'])) {
$cat_id = $_POST['cat_id'];
$sub_cat_id = $_POST['sub_cat_id'];
// $deal_ids = isset($_POST['Deal_Types_atb']) ? implode(",", $_POST['Deal_Types_atb']) : "";
// $property_types_ids = isset($_POST['Property_Types_atb']) ? implode(",", $_POST['Property_Types_atb']) : "";
$title = str_replace("'", "\'", $_POST['title']);
$title_ar = str_replace("'", "\'", $_POST['title_ar']);
$price = str_replace("'", "\'", $_POST['price']);
$model_code = str_replace("'", "\'", $_POST['model_code']);
$model_year = str_replace("'", "\'", $_POST['model_year']);
$old_price = str_replace("'", "\'", $_POST['old_price']);
$vat_status = str_replace("'", "\'", $_POST['vat_status']);
$shipping_status = str_replace("'", "\'", $_POST['shipping_status']);
$shipping_include = str_replace("'", "\'", $_POST['shipping_include']);
$shipping_price = str_replace("'", "\'", $_POST['shipping_price']);
$part_no = str_replace("'", "\'", $_POST['part_no']);
$part_grade = str_replace("'", "\'", $_POST['part_grade']);
$quantity = str_replace("'", "\'", $_POST['quantity']);
$short_description = str_replace("'", "\'", $_POST['short_description']);
$short_description_ar = str_replace("'", "\'", $_POST['short_description_ar']);
$part_grade_ar = str_replace("'", "\'", $_POST['part_grade_ar']);
// $heading1_ar = str_replace("'", "\'", $_POST['heading1_ar']);
$description1 = str_replace("'", "\'", $_POST['description1']);
$description1_ar = str_replace("'", "\'", $_POST['description1_ar']);
// $heading2 = str_replace("'", "\'", $_POST['heading2']);
// $heading2_ar = str_replace("'", "\'", $_POST['heading2_ar']);
// $description2 = str_replace("'", "\'", $_POST['description2']);
// $description2_ar = str_replace("'", "\'", $_POST['description2_ar']);
// $heading3 = str_replace("'", "\'", $_POST['heading3']);
// $heading3_ar = str_replace("'", "\'", $_POST['heading3_ar']);
// $description3 = str_replace("'", "\'", $_POST['description3']);
// $description3_ar = str_replace("'", "\'", $_POST['description3_ar']);
// $heading4 = str_replace("'", "\'", $_POST['heading4']);
// $heading4_ar = str_replace("'", "\'", $_POST['heading4_ar']);
// $description4 = str_replace("'", "\'", $_POST['description4']);
// $description4_ar = str_replace("'", "\'", $_POST['description4_ar']);
$opportunities_status = $_POST['opportunities_status'];
$status = $_POST['status'];
$slug = create_url($title);
// $d=sprintf("%04d",$_REQUEST['id']);
// $product_id="Product".$d;
// Handle image update
if (!empty($_FILES['image1']['name'])) {
$file_name = $_FILES['image1']['name'];
$file_tmp = $_FILES['image1']['tmp_name'];
$file_ext = strtolower(end(explode('.', $file_name)));
$random_number = rand(111111111, 999999999);
$new_file_name = $random_number . '.' . $file_ext;
$file_path = "../../images/Upload/product/" . $new_file_name;
if (move_uploaded_file($file_tmp, $file_path)) {
$dlt = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM `product_tbl` WHERE id = '" . $_REQUEST['id'] . "'"));
$dlt_path = "../../images/Upload/product/" . $dlt['image1'];
if (file_exists($dlt_path)) {
unlink($dlt_path);
}
$sql = mysqli_query($conn, "UPDATE `product_tbl` SET `image1` = '$new_file_name' WHERE id = '" . $_REQUEST['id'] . "'");
}
}
// Update popular_packages_tbl content
mysqli_query($conn, "UPDATE `product_tbl` SET
-- `product_id`='$product_id',
`cat_id`='$cat_id',
`sub_cat_id`='$sub_cat_id',
-- `deal_id`='$deal_ids',
-- `size`='$size',
-- `size_ar`='$size_ar',
-- `property_types_id`='$property_types_ids',
`title`='$title',
`title_ar`='$title_ar',
`price`='$price',
`model_code`='$model_code',
`model_year`='$model_year',
`old_price`='$old_price',
`vat_status`='$vat_status',
`shipping_status`='$shipping_status',
`shipping_include`='$shipping_include',
`shipping_price`='$shipping_price',
`part_no`='$part_no',
`part_grade`='$part_grade',
`short_description`='$short_description',
`short_description_ar`='$short_description_ar',
`quantity`='$quantity',
`description1`='$description1',
`description1_ar`='$description1_ar',
`part_grade_ar`='$part_grade_ar',
-- `heading2_ar`='$heading2_ar',
-- `description2`='$description2',
-- `description2_ar`='$description2_ar',
-- `heading3`='$heading3',
-- `heading3_ar`='$heading3_ar',
-- `description3`='$description3',
-- `description3_ar`='$description3_ar',
-- `heading4`='$heading4',
-- `heading4_ar`='$heading4_ar',
-- `description4`='$description4',
-- `description4_ar`='$description4_ar',
`opportunities_status`='$opportunities_status',
`status`='$status',
`slug`= '$slug' WHERE
`id` = '" . $_REQUEST['id'] . "'");
// Handle updates Image to product_img_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 = rand(111111111, 999999999) . '_' . $_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 Image to product_img_tbl
if (isset($_FILES['image_atb']['name']) && is_array($_FILES['image_atb']['name'])) {
foreach ($_FILES['image_atb']['name'] as $key => $val) {
$image = rand(111111111, 999999999) . '_' . $_FILES['image_atb']['name'][$key];
$file_path = "../../images/Upload/product/" . $image;
if (move_uploaded_file($_FILES['image_atb']['tmp_name'][$key], $file_path)) {
mysqli_query($conn, "INSERT INTO `product_img_tbl` (`product_id`, `image_atb`) VALUES ('" . $_REQUEST['id'] . "', '$image')");
}
}
}
echo "<script>window.location='show.php?page=pro';</script>";
$_SESSION['message'] = "Product Updated successfully";
}
?>