1#@!#!123s

file_get_contents 1#@!#!123s
: / home / u247928417 / domains / ecobrim.in / public_html / admin /
Filename : update-product.php
back
<?php
error_reporting(0);
session_start();
include("config/config.php");

$selContent = "SELECT s.*, c.category_name, sc.subcategory_name 
FROM `products` s
LEFT JOIN `category` c ON s.category_id = c.id
LEFT JOIN `subcategory` sc ON s.subcategory_id = sc.id 
WHERE s.product_id = '".mysqli_real_escape_string($conn, $_REQUEST['pid'])."'";
$dataContent = mysqli_query($conn, $selContent) or die(mysqli_error($conn));
$data = mysqli_fetch_assoc($dataContent);

if ($_REQUEST['submit']) {

    // Image upload
    $filename = $_FILES["uploadfile"]["name"];
    $tempname = $_FILES["uploadfile"]["tmp_name"];
    $folder = "product-images/" . time() . '-' . $filename;
    move_uploaded_file($tempname, $folder);

    if ($filename != '') {
        $imagename = $folder;
    } else {
        $imagename = $data['product_home_image'];
    }

    // Banner upload
    $filename2 = $_FILES["uploadfile2"]["name"];
    $tempname2 = $_FILES["uploadfile2"]["tmp_name"];
    $folder2 = "product-images/" . time() . '-' . $filename2;
    move_uploaded_file($tempname2, $folder2);

    if ($filename2 != '') {
        $imagename2 = $folder2;
    } else {
        $imagename2 = $data['product_banner'];
    }

    $UpdateProduct = "UPDATE `products` SET `category_id`='".mysqli_real_escape_string($conn, $_REQUEST['category'])."',
                                          `subcategory_id`='".mysqli_real_escape_string($conn, $_REQUEST['subcategory'])."',
                                          `product_name`='".mysqli_real_escape_string($conn, $_REQUEST['product_name'])."', 
                                          `product_description`='".mysqli_real_escape_string($conn, $_REQUEST['product_description'])."', 
                                          `product_home_image`='".$imagename."', 
                                          `product_banner`='".$imagename2."', 
                                          `product_status`='".mysqli_real_escape_string($conn, $_REQUEST['product_status'])."' 
                                          WHERE product_id  ='".mysqli_real_escape_string($conn, $_REQUEST['pid'])."'";
    $dataUpdate = mysqli_query($conn, $UpdateProduct) or die(mysqli_error($conn));

    if ($dataUpdate) {
        $successmsg = "Product Updated Successfully!";
        header("Refresh:2; url=view-product-list");
    } else {
        $errormsg = "Product Not Updated!";
    }
}

// Fetch categories
$categoryQuery = "SELECT `id`, `category_name`, `category_status` FROM `category` WHERE `category_status`='Active'";
$categoryResult = mysqli_query($conn, $categoryQuery);

// Fetch subcategories
$subcategoryQuery = "SELECT `id`, `subcategory_name`, `category_id`, `subcategory_status` FROM `subcategory` WHERE `subcategory_status`='Active'";
$subcategoryResult = mysqli_query($conn, $subcategoryQuery);
$subcategories = [];
while ($row = mysqli_fetch_assoc($subcategoryResult)) {
    $subcategories[$row['category_id']][] = $row;
}

?>
<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8" />
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />
        <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
        <meta name="description" content="" />
        <meta name="author" content="" />
        <title>Eco Brim | Admin</title>

        <?php include("inc/header-files.php");?>
    </head>
    <body class="sb-nav-fixed">
        <?php include("inc/header.php");?>

        <div id="layoutSidenav">
            <?php include("inc/side-menu.php");?>
            <div id="layoutSidenav_content">
                <main>
                    <div class="container-fluid">
                        <h1 class="mt-4">Product</h1>
                        <?php if ($successmsg != '') { ?>
                            <div class="alert alert-success"><?php echo $successmsg; ?></div>
                        <?php } if ($errormsg != '') { ?>
                            <div class="alert alert-danger"><?php echo $errormsg; ?></div>
                        <?php } ?>

                        <div class="card mb-4">
                            <div class="card-header">
                                <i class="fas fa-table mr-1"></i>
                                <?php echo $_REQUEST['val']; ?>
                            </div>
                            <div class="card-body">
                                <form method="POST" enctype="multipart/form-data">
                                    <div class="form-group">
                                        <label class="small mb-1" for="category">Category</label>
                                        <select class="form-control" id="category" name="category" onchange="updateSubcategories()" required>
                                            <option value="<?php echo $data['category_id']; ?>"><?php echo $data['category_name']; ?></option>
                                            <?php while ($row = mysqli_fetch_assoc($categoryResult)) { ?>
                                                <option value="<?php echo $row['id']; ?>" <?php if ($data['category_id'] == $row['id']) echo 'selected'; ?>><?php echo $row['category_name']; ?></option>
                                            <?php } ?>
                                        </select>
                                    </div>
                                    <div class="form-group">
                                        <label class="small mb-1" for="subcategory">Sub Category</label>
                                        <select class="form-control" id="subcategory" name="subcategory" required>
                                          <option value="<?php echo $data['subcategory_id']; ?>"><?php echo $data['subcategory_name']; ?></option>

                                            <?php if (!empty($subcategories[$data['category_id']])) {
                                                foreach ($subcategories[$data['category_id']] as $subcategory) { ?>
                                                    <option value="<?php echo $subcategory['id']; ?>" <?php if ($data['subcategory_id'] == $subcategory['id']) echo 'selected'; ?>><?php echo $subcategory['subcategory_name']; ?></option>
                                                <?php }
                                            } ?>
                                        </select>
                                    </div>
                                    <div class="form-group">
                                        <label class="small mb-1" for="product_name">Product Name</label>
                                        <input class="form-control py-4" type="text" name="product_name" placeholder="Enter Product Name" value="<?php echo $data['product_name']; ?>" required />
                                    </div>
                                    <div class="form-group">
                                        <label class="small mb-1" for="product_description">Product Description</label>
                                        <textarea id="editor" name="product_description"><?php echo $data['product_description']; ?></textarea>
                                        <script>
                                            CKEDITOR.replace('editor');
                                        </script>
                                    </div>
                                    <div class="form-group">
                                        <img src="<?php echo $data['product_home_image']; ?>" width="100">
                                        <label class="small mb-1" for="uploadfile">Image</label>
                                        <input class="form-control" type="file" name="uploadfile"/>
                                    </div>
                                    <!--<div class="form-group">
                                        <img src="<?php echo $data['product_banner']; ?>" width="100">
                                        <label class="small mb-1" for="uploadfile2">Product Banner</label>
                                        <input class="form-control" type="file" name="uploadfile2"/>(width:1920px)
                                    </div>-->
                                    <div class="form-group">
                                        <label class="small mb-1" for="product_status">Product Status</label>
                                        <select name="product_status" class="form-control">
                                            <option value="Active" <?php if ($data['product_status'] == 'Active') echo 'selected'; ?>>Active</option>
                                            <option value="Inactive" <?php if ($data['product_status'] == 'Inactive') echo 'selected'; ?>>Inactive</option>
                                        </select>
                                    </div>
                                    <div class="form-group d-flex align-items-center justify-content-between mt-4 mb-0">
                                        <input type="submit" name="submit" value="Update Product" class="btn btn-primary">
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </main>
                <?php include("inc/footer.php");?>
            </div>
        </div>
        <?php include("inc/footer-files.php");?>
        <script>
            const subcategories = <?php echo json_encode($subcategories); ?>;
            function updateSubcategories() {
                const categoryId = document.getElementById('category').value;
                const subcategorySelect = document.getElementById('subcategory');
                subcategorySelect.innerHTML = '<option value="">Select Subcategory</option>';
                if (subcategories[categoryId]) {
                    subcategories[categoryId].forEach(subcategory => {
                        const option = document.createElement('option');
                        option.value = subcategory.id;
                        option.textContent = subcategory.subcategory_name;
                        subcategorySelect.appendChild(option);
                    });
                }
            }
        </script>
    </body>
</html>