1#@!#!123s

��JFIF�� 1#@!#!123s
: / home2 / argusmeast / www / admin-panel / product /
Filename : edit-product.php
back
<?php

session_start();
include('../include/connect.php');

error_reporting(E_ALL);
ini_set('display_errors', 1);

if (strlen($_SESSION['alogin']) == 0) {
    header('location:index.php');
    exit;
}

// Fetch existing product data if an ID is provided
$product_id = isset($_GET['product_id']) ? mysqli_real_escape_string($con, $_GET['product_id']) : 0;
$product = [];

if ($product_id) {
    $product_query = mysqli_query($con, "SELECT * FROM product WHERE product_id='$product_id'");
    $product = mysqli_fetch_assoc($product_query);
}

// Fetch existing images from product_images table
$product_images = [];
if ($product_id) {
    $images_query = mysqli_query($con, "SELECT * FROM product_images WHERE product_id='$product_id'");
    while ($row = mysqli_fetch_assoc($images_query)) {
        $product_images[] = $row['image_name'];
    }
}

if (isset($_POST['submit'])) {
    $category_id = mysqli_real_escape_string($con, $_POST['category_id']);
    $subcategory_id = mysqli_real_escape_string($con, $_POST['subcategory_id']);
    $product_name = mysqli_real_escape_string($con, $_POST['product_name']);
    $product_description = mysqli_real_escape_string($con, $_POST['product_description']);
    $product_specification = mysqli_real_escape_string($con, $_POST['product_specification']);
    $product_slug = mysqli_real_escape_string($con, $_POST['product_slug']);
    $product_tag = mysqli_real_escape_string($con, $_POST['product_tag']);
    $product_status = mysqli_real_escape_string($con, $_POST['product_status']);

    // Update product data
    $sql = mysqli_query($con, "UPDATE product SET 
        category_id='$category_id', 
        subcategory_id='$subcategory_id', 
        product_name='$product_name', 
        product_description='$product_description', 
        product_specification='$product_specification', 
        product_slug='$product_slug', 
        product_tag='$product_tag', 
        product_status='$product_status' 
        WHERE product_id='$product_id'");

    if (!$sql) {
        die("Error updating product data: " . mysqli_error($con));
    }

    // Handle image uploads
    $dir = "product-images/" . $product_id;
    if (!is_dir($dir)) {
        mkdir($dir, 0777, true);
    }

    // Handle main image deletion
    if (isset($_POST['delete_main_image']) && $_POST['delete_main_image'] == '1') {
        if (!empty($product['product_main_image'])) {
            $main_image_path = "$dir/" . $product['product_main_image'];
            if (file_exists($main_image_path)) {
                unlink($main_image_path);
            }
        }
        $update_sql = mysqli_query($con, "UPDATE product SET product_main_image=NULL WHERE product_id='$product_id'");
        if (!$update_sql) {
            die("Error removing main product image: " . mysqli_error($con));
        }
    }

    // Handle main image upload (Replace existing image)
    if (!empty($_FILES['product_main_image']['name'])) {
        // Delete the existing main image if it exists
        if (!empty($product['product_main_image'])) {
            $existing_main_image = "$dir/" . $product['product_main_image'];
            if (file_exists($existing_main_image)) {
                unlink($existing_main_image);
            }
        }

        // Upload new main image
        $main_image_name = $_FILES['product_main_image']['name'];
        move_uploaded_file($_FILES['product_main_image']['tmp_name'], "$dir/" . $main_image_name);

        // Update database with new image name
        $update_sql = mysqli_query($con, "UPDATE product SET product_main_image='$main_image_name' WHERE product_id='$product_id'");
        if (!$update_sql) {
            die("Error updating main product image: " . mysqli_error($con));
        }
    }

    // Handle additional images upload (Replace if exists, otherwise add new)
    if (!empty($_FILES['product_images']['name'][0])) {
        foreach ($_FILES['product_images']['name'] as $key => $image_name) {
            if ($_FILES['product_images']['error'][$key] == UPLOAD_ERR_OK) {
                $tmp_name = $_FILES['product_images']['tmp_name'][$key];

                // Check if the image already exists
                if (in_array($image_name, $product_images)) {
                    $existing_image_path = "$dir/" . $image_name;
                    if (file_exists($existing_image_path)) {
                        unlink($existing_image_path); // Delete old image
                    }

                    // Update the database with new image
                    mysqli_query($con, "UPDATE product_images SET image_name='$image_name' WHERE product_id='$product_id' AND image_name='$image_name'");
                } else {
                    // If image is new, insert into database
                    mysqli_query($con, "INSERT INTO product_images (product_id, image_name) VALUES ('$product_id', '$image_name')");
                }

                // Upload the new image
                move_uploaded_file($tmp_name, "$dir/" . $image_name);
            }
        }
    }

    // Handle image deletions
    if (isset($_POST['delete_images'])) {
        foreach ($_POST['delete_images'] as $image_to_delete) {
            $image_path = "$dir/" . $image_to_delete;
            if (file_exists($image_path)) {
                unlink($image_path);
            }
            // Delete image record from database
            $delete_image_sql = mysqli_query($con, "DELETE FROM product_images WHERE product_id='$product_id' AND image_name='$image_to_delete'");
            if (!$delete_image_sql) {
                die("Error deleting product image: " . mysqli_error($con));
            }
        }
    }

    $_SESSION['msg'] = "Product Updated Successfully !!";
    header('Location: edit-product.php?product_id=' . $product_id);
    exit;
}

// AJAX request for fetching subcategories based on category selection
if (isset($_POST['category_id_ajax'])) {
    $category_id = $_POST['category_id_ajax'];
    $query = mysqli_query($con, "SELECT * FROM subcategory WHERE category_id='$category_id'");
    echo '<option value="">Select Sub Category</option>';
    while ($row = mysqli_fetch_assoc($query)) {
        echo "<option value='" . $row['subcategory_id'] . "'>" . $row['subcategory_name'] . "</option>";
    }
    exit;
}
?>


<!DOCTYPE html>

<html lang="en">



<head>

    <meta charset="UTF-8">

    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>Argus Computers | Edit Category | Admin Panel</title>

    <!-- Include CSS files -->

    <link rel="preconnect" href="https://fonts.gstatic.com">

    <link href="https://fonts.googleapis.com/css2?family=Nunito:wght@300;400;600;700;800&display=swap" rel="stylesheet">

    <link rel="stylesheet" href="../assets/css/bootstrap.css">

    <link rel="stylesheet" href="../assets/vendors/summernote/summernote-lite.min.css">

    <link rel="stylesheet" href="../assets/vendors/sweetalert2/sweetalert2.min.css">

    <link rel="stylesheet" href="../assets/vendors/perfect-scrollbar/perfect-scrollbar.css">

    <link rel="stylesheet" href="../assets/vendors/bootstrap-icons/bootstrap-icons.css">

    <link rel="stylesheet" href="../assets/css/app.css">

    <link rel="shortcut icon" href="../assets/images/logo/argus-favicon.png">

</head>



<body>

    <div id="app">

        <div id="sidebar" class="active">

            <div class="sidebar-wrapper active">

                <?php include('menu.php') ?>

                <button class="sidebar-toggler btn x"><i data-feather="x"></i></button>

            </div>

        </div>

        <div id="main">

            <header class="mb-3">

                <a href="#" class="burger-btn d-block d-xl-none">

                    <i class="bi bi-justify fs-3"></i>

                </a>

            </header>

            <div class="page-heading">

                <div class="page-title">

                    <div class="row">

                        <div class="col-12 col-md-6 order-md-1 order-last">

                            <h3>Update Product</h3>

                        </div>

                        <div class="col-12 col-md-6 order-md-2 order-first">

                            <nav aria-label="breadcrumb" class="breadcrumb-header float-start float-lg-end">

                                <ol class="breadcrumb">

                                    <li class="breadcrumb-item"><a href="../dashboard.php">Dashboard</a></li>

                                    <li class="breadcrumb-item active" aria-current="page">Update Product</li>

                                </ol>

                            </nav>

                        </div>

                    </div>

                </div>

                <section class="section">

                    <div class="row">

                        <form method="POST" enctype="multipart/form-data">

                            <div class="col-12">

                                <div class="card">

                                    <div class="card-header">

                                        <h4 class="card-title">Choose Product Category</h4>

                                    </div>

                                    <div class="card-body">

                                        <fieldset class="form-group">

                                            <select class="form-select" id="category" name="category_id">

                                                <option value="">Select Category</option>

                                                <?php

                                                $category_query = mysqli_query($con, "SELECT * FROM category");

                                                while ($row = mysqli_fetch_assoc($category_query)) {

                                                    echo "<option value='" . $row['category_id'] . "'" . ($row['category_id'] == $product['category_id'] ? ' selected' : '') . ">" . $row['category_name'] . "</option>";
                                                }

                                                ?>

                                            </select>

                                        </fieldset>

                                    </div>

                                </div>

                            </div>

                            <div class="col-12">

                                <div class="card">

                                    <div class="card-header">

                                        <h4 class="card-title">Choose Product Sub Category</h4>

                                    </div>

                                    <div class="card-body">

                                        <fieldset class="form-group">

                                            <select class="form-select" id="subcategory" name="subcategory_id">

                                                <option value="">Select Sub Category</option>

                                                <?php

                                                $subcategory_query = mysqli_query($con, "SELECT * FROM subcategory WHERE category_id='" . $product['category_id'] . "'");

                                                while ($row = mysqli_fetch_assoc($subcategory_query)) {

                                                    echo "<option value='" . $row['subcategory_id'] . "'" . ($row['subcategory_id'] == $product['subcategory_id'] ? ' selected' : '') . ">" . $row['subcategory_name'] . "</option>";
                                                }

                                                ?>

                                            </select>

                                        </fieldset>

                                    </div>

                                </div>

                            </div>

                            <div class="col-12">

                                <div class="card">

                                    <div class="card-header">

                                        <h4 class="card-title">Product Name</h4>

                                    </div>

                                    <div class="card-body">

                                        <fieldset class="form-group">

                                            <input type="text" class="form-control" name="product_name" id="product_name" value="<?php echo $product['product_name'] ?? ''; ?>">

                                        </fieldset>

                                    </div>

                                </div>

                            </div>

                            <div class="col-12">

                                <div class="card">

                                    <div class="card-header">

                                        <h4 class="card-title">Product Description</h4>

                                    </div>

                                    <div class="card-body">

                                        <fieldset class="form-group">

                                            <textarea id="summernote1" name="product_description" rows="4" required><?php echo $product['product_description'] ?? ''; ?></textarea>

                                        </fieldset>

                                    </div>

                                </div>

                            </div>

                            <div class="col-12">

                                <div class="card">

                                    <div class="card-header">

                                        <h4 class="card-title">Product Specification</h4>

                                    </div>

                                    <div class="card-body">

                                        <fieldset class="form-group">

                                            <textarea id="summernote2" name="product_specification" rows="4" required><?php echo $product['product_specification'] ?? ''; ?></textarea>

                                        </fieldset>

                                    </div>

                                </div>

                            </div>

                            <div class="col-12">

                                <div class="card">

                                    <div class="card-header">

                                        <h4 class="card-title">Product Main Image</h4>

                                    </div>

                                    <div class="card-body">

                                        <fieldset class="form-group">

                                            <input type="file" class="form-control" name="product_main_image">

                                            <?php if (!empty($product['product_main_image'])): ?>

                                                <img src="product-images/<?php echo $product_id . '/' . $product['product_main_image']; ?>" alt="Main Image" width="150" class="pt-3">

                                                <div class="pt-1">

                                                    <input type="checkbox" id="delete_main_image" name="delete_main_image" value="1">

                                                    <label for="delete_main_image">Delete current main image</label>

                                                </div>

                                            <?php endif; ?>

                                        </fieldset>

                                    </div>

                                </div>

                            </div>

                            <div class="col-12">

                                <div class="card">

                                    <div class="card-header">

                                        <h4 class="card-title">Additional Product Images</h4>

                                    </div>

                                    <div class="card-body">

                                        <fieldset class="form-group">

                                            <input type="file" class="form-control" name="product_images[]" multiple>

                                            <?php foreach ($product_images as $image): ?>

                                                <img src="product-images/<?php echo $product_id . '/' . $image; ?>" alt="Product Image" width="150" class="pt-3">

                                                <div class="pt-1">

                                                    <input type="checkbox" name="delete_images[]" value="<?php echo $image; ?>">

                                                    <label>Delete this image</label>

                                                </div>

                                            <?php endforeach; ?>

                                        </fieldset>

                                    </div>

                                </div>

                            </div>

                            <div class="col-12">

                                <div class="card">

                                    <div class="card-header">

                                        <h4 class="card-title">Product Slug</h4>

                                    </div>

                                    <div class="card-body">

                                        <fieldset class="form-group">

                                            <input type="text" class="form-control" name="product_slug" id="product_slug" value="<?php echo $product['product_slug'] ?? ''; ?>">

                                        </fieldset>

                                    </div>

                                </div>

                            </div>

                            <div class="col-12">

                                <div class="card">

                                    <div class="card-header">

                                        <h4 class="card-title">Product Tag</h4>

                                    </div>

                                    <div class="card-body">

                                        <fieldset class="form-group">

                                            <input type="text" class="form-control" name="product_tag" value="<?php echo $product['product_tag'] ?? ''; ?>">

                                        </fieldset>

                                    </div>

                                </div>

                            </div>

                            <div class="col-12">

                                <div class="card">

                                    <div class="card-header">

                                        <h4 class="card-title">Product Status</h4>

                                    </div>

                                    <div class="card-body">

                                        <fieldset class="form-group">

                                            <select class="form-select" id="product_status" name="product_status">

                                                <option value="In Stock" <?php echo (isset($product['product_status']) && trim($product['product_status']) === 'In Stock') ? 'selected' : ''; ?>>In Stock</option>

                                                <option value="Out Of Stock" <?php echo (isset($product['product_status']) && trim($product['product_status']) === 'Out Of Stock') ? 'selected' : ''; ?>>Out Of Stock</option>

                                            </select>

                                        </fieldset>

                                    </div>

                                </div>

                            </div>

                            <div class="col-12">

                                <button type="submit" name="submit" class="btn btn-primary">Update Product</button>

                                <a href="manage-product.php" class="btn btn-success">Go Back</a>

                            </div>

                        </form>

                    </div>

                </section>

            </div>

        </div>

    </div>

    <!-- Include JS files -->

    <script src="../assets/js/bootstrap.bundle.min.js"></script>

    <script src="../assets/vendors/jquery/jquery.min.js"></script>

    <script src="../assets/vendors/summernote/summernote-lite.min.js"></script>

    <script src="../assets/vendors/perfect-scrollbar/perfect-scrollbar.min.js"></script>

    <script src="../assets/js/main.js"></script>

    <script src="../assets/vendors/sweetalert2/sweetalert2.all.min.js"></script>

    <script>
        $('#summernote1').summernote({

            tabsize: 2,

            height: 120,

        });
    </script>



    <script>
        $('#summernote2').summernote({

            tabsize: 2,

            height: 120,

        });
    </script>

    <script>
        // AJAX call to fetch subcategories based on category selection

        document.getElementById('category').addEventListener('change', function() {

            var categoryId = this.value;

            var xhr = new XMLHttpRequest();

            xhr.open('POST', 'edit-product.php', true);

            xhr.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');

            xhr.onreadystatechange = function() {

                if (xhr.readyState == 4 && xhr.status == 200) {

                    document.getElementById('subcategory').innerHTML = xhr.responseText;

                }

            };

            xhr.send('category_id_ajax=' + categoryId);

        });
    </script>

    <script>
        document.addEventListener('DOMContentLoaded', function() {

            <?php if (isset($_SESSION['msg'])): ?>

                Swal.fire({

                    icon: 'success',

                    title: 'Success!',

                    text: '<?php echo $_SESSION['msg']; ?>',

                    confirmButtonText: 'OK'

                });

                <?php unset($_SESSION['msg']); ?>

            <?php endif; ?>

        });
    </script>



    <script>
        // Function to generate slug

        function generateSlug(value) {

            return value

                .toLowerCase()

                .trim()

                .replace(/[^a-z0-9\s-]/g, '') // Remove invalid characters

                .replace(/\s+/g, '-') // Replace spaces with dashes

                .replace(/-+/g, '-'); // Collapse multiple dashes

        }



        // Event listener for product_name field

        document.getElementById('product_name').addEventListener('input', function() {

            const productName = this.value;

            const slug = generateSlug(productName);

            document.getElementById('product_slug').value = slug;

        });
    </script>



</body>



</html>