D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
universalhomedecor.in
/
admin
/
Filename :
edit_product.php
back
Copy
<?php session_start(); include 'config.php'; if (!isset($_SESSION['admin_name'])) { echo '<script>window.location.href = "login.php";</script>'; exit; } // Fetch categories from the database $categories = []; $categoryQuery = "SELECT * FROM `product_category`"; $categoryResult = mysqli_query($conn, $categoryQuery); if ($categoryResult) { while ($row = mysqli_fetch_assoc($categoryResult)) { $categories[] = $row; } } if (!isset($_GET['id'])) { echo "Product ID is missing!"; exit; } $id = intval($_GET['id']); $query = "SELECT * FROM `products` WHERE `id`=$id"; $result = mysqli_query($conn, $query); if (!$result || mysqli_num_rows($result) === 0) { echo "Product not found!"; exit; } $item = mysqli_fetch_assoc($result); $imageSrc = htmlspecialchars($item['image'], ENT_QUOTES, 'UTF-8'); // Check if form is submitted if ($_SERVER["REQUEST_METHOD"] == "POST") { // Validate and sanitize form inputs $name = mysqli_real_escape_string($conn, $_POST['name']); $description = mysqli_real_escape_string($conn, $_POST['description']); $short_desc = mysqli_real_escape_string($conn, $_POST['short_desc']); $category = mysqli_real_escape_string($conn, $_POST['category']); $price = floatval($_POST['price']); // Handle image upload $imgpath = $imageSrc; // Default to the current image if ($_FILES['image']['error'] == UPLOAD_ERR_OK) { $imgpath = image_upload($_FILES['image']); } // Update product details $query = "UPDATE `products` SET `name`='$name', `description`='$description', `short_desc`='$short_desc', `category`='$category', `price`='$price', `image`='$imgpath' WHERE `id`=$id"; if (mysqli_query($conn, $query)) { header("Location: products.php"); exit; } else { echo "Error updating product: " . mysqli_error($conn); exit; } } ?> <!DOCTYPE html> <html lang="en"> <head> <?php require('style.php'); ?> </head> <body> <!-- loader starts--> <div class="loader-wrapper"> <div class="loader"> <div class="box"></div> <div class="box"></div> <div class="box"></div> <div class="box"></div> <div class="box"></div> </div> </div> <!-- loader ends--> <!-- tap on top starts--> <div class="tap-top"><i data-feather="chevrons-up"></i></div> <!-- tap on tap ends--> <!-- page-wrapper Start--> <div class="page-wrapper default-wrapper" id="pageWrapper"> <!-- Page Header Start--> <div class="page-header"> <div class="header-wrapper row m-0"> <div class="header-logo-wrapper col-auto p-0"> <div class="logo-wrapper"><a href="index.html"><img class="img-fluid for-light" src="assets/images/logo.png" alt=""><img class="img-fluid for-dark" src="assets/images/logo.png" alt=""></a></div> </div> <div class="left-header col-xxl-5 col-xl-6 col-md-4 col-auto box-col-6 horizontal-wrapper p-0"> <div class="left-menu-header"> <ul class="header-left"> <li> <div class="form-group w-100"> <div class="Typeahead Typeahead--twitterUsers"> <div class="u-posRelative d-flex"> <input class="demo-input py-0 Typeahead-input form-control-plaintext w-100" type="text" placeholder="Search anything..." name="q" title=""> </div> </div> </div> </li> </ul> </div> </div> <div class="nav-right col-xxl-7 col-xl-6 col-auto box-col-6 pull-right right-header p-0 ms-auto"> <ul class="nav-menus"> <li class="serchinput"> <div class="serchbox"> <svg> <use href="https://admin.pixelstrap.net/crocsassets/svg/icon-sprite.svg#fill-search"></use> </svg> </div> <div class="form-group search-form"> <input type="text" placeholder="Search here..."> </div> </li> <li> <div class="mode"> <i class="fa-solid fa-circle-half-stroke"></i> </div> </li> <li class="profile-nav onhover-dropdown p-0"> <div class="d-flex align-items-center profile-media"><img class="b-r-10 img-40" src="assets/images/dashboard/profile.png" alt=""> <div class="flex-grow-1"><span>Universal</span> <p class="mb-0">Home Decor </p> </div> </div> </li> </ul> </div> <script class="result-template" type="text/x-handlebars-template"> <div class="ProfileCard u-cf"> <div class="ProfileCard-avatar"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-airplay m-0"><path d="M5 17H4a2 2 0 0 1-2-2V5a2 2 0 0 1 2-2h16a2 2 0 0 1 2 2v10a2 2 0 0 1-2 2h-1"></path><polygon points="12 15 17 21 7 21 12 15"></polygon></svg></div> <div class="ProfileCard-details"> <div class="ProfileCard-realName">{{name}}</div> </div> </script> <script class="empty-template" type="text/x-handlebars-template"><div class="EmptyMessage">Your search turned up 0 results. This most likely means the backend is down, yikes!</div></script> </div> </div> <!-- Page Header Ends --> <!-- Page Body Start --> <div class="page-body-wrapper default-menu default-menu"> <!-- Page Sidebar Start --> <?php require('sidebar.php') ?> <!-- Page Sidebar Ends --> <div class="page-body"> <div class="container-fluid"> <div class="page-title"> <div class="row"> <div class="col-sm-6 ps-0"> <h3>Update Product</h3> </div> </div> </div> </div> <!-- Container-fluid starts --> <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>?id=<?php echo $id; ?>" method="POST" enctype="multipart/form-data"> <div class="container-fluid"> <div class="row"> <div class="col-sm-12"> <div class="card"> <div class="card-body"> <div class="form theme-form"> <div class="row"> <div class="col"> <div class="mb-3"> <label>Product Name</label> <input type="text" name="name" id="name" class="form-control" value="<?php echo $item['name']; ?>"> </div> </div> </div> <div class="row"> <div class="col-sm-4"> <div class="mb-3"> <label>Price</label> <input type="text" name="price" id="price" class="form-control" value="<?php echo $item['price']; ?>"> </div> </div> <div class="col-sm-4"> <div class="mb-3"> <label>Short Description</label> <input type="text" name="short_desc" id="short_desc" class="form-control" value="<?php echo $item['short_desc']; ?>"> </div> </div> <div class="col-sm-4"> <div class="mb-3"> <label for="category" class="form-label">Category</label> <select class="form-control" id="category" name="category" required style="color: #000;"> <?php foreach ($categories as $category) { $selected = ($item['category'] == $category['category_name']) ? 'selected' : ''; echo '<option value="' . htmlspecialchars($category['id'], ENT_QUOTES, 'UTF-8') . '" ' . $selected . '>' . htmlspecialchars($category['category_name'], ENT_QUOTES, 'UTF-8') . '</option>'; } ?> </select> </div> </div> </div> <div class="row"> <div class="col"> <div class="mb-3"> <textarea name="description" placeholder="Enter Description" class="form-control" rows="6"><?php echo $item['description']; ?></textarea> </div> </div> </div> <div class="row"> <div class="col"> <div class="mb-3"> <label>Upload project file</label> <h4>Drop files here or click to upload.</h4><span class="note needsclick">(This is just a demo dropzone. Selected files are <strong>not</strong> actually uploaded.)</span><br> <input type="file" name="image" placeholder="Upload Image" class="form-control" accept=".jpg, .jpeg, .png, .svg"> </div> </div> </div> </div> <div class="row"> <div class="modal-footer"> <button type="submit" class="btn btn-success" name="edit">Update Product</button> <button type="reset" class="btn btn-outline-secondary" data-bs-dismiss="modal">Cancel</button> </div> </div> </div> </div> </div> </div> </div> </form> <!-- Container-fluid Ends --> </div> <!-- footer start --> <?php require('footer.php') ?> </body> </html>