📁 File Manager
Editing:
/home/wedigitalindia/public_html/bartozmarketing.com/admin/edit_product.php
<?php include("connection.php"); include("header.php"); $pro_id = isset($_GET['p_id']) ? intval($_GET['p_id']) : 0; // Fetch existing product $sql = "SELECT * FROM product WHERE p_id='$pro_id'"; $query = mysqli_query($con, $sql); if (!$query || mysqli_num_rows($query) == 0) { die("Product not found"); } $row = mysqli_fetch_assoc($query); // Generate slug function function generateSlug($string) { $slug = preg_replace('/[^A-Za-z0-9-]+/', '-', strtolower($string)); return trim($slug, '-'); } if (isset($_POST['update'])) { $title = mysqli_real_escape_string($con, $_POST['title']); $inputSlug = mysqli_real_escape_string($con, $_POST['slug']); $description = mysqli_real_escape_string($con, $_POST['description']); $activity = mysqli_real_escape_string($con, $_POST['activity']); $top_cat_id = intval($_POST['top_cat_id']); $old_image = $_POST['old_image']; // Slug generation $baseSlug = empty($inputSlug) ? generateSlug($title) : generateSlug($inputSlug); $slug = $baseSlug; $counter = 1; // Ensure unique slug while (true) { $checkSlug = mysqli_query( $con, "SELECT COUNT(*) as total FROM product WHERE slug='$slug' AND p_id != '$pro_id'" ); $slugRow = mysqli_fetch_assoc($checkSlug); if ($slugRow['total'] == 0) { break; } $slug = $baseSlug . '-' . $counter; $counter++; } // Image handling $Image = $old_image; if (!empty($_FILES['Image']['name'])) { $imageName = $_FILES['Image']['name']; $imageTmp = $_FILES['Image']['tmp_name']; $imageExt = strtolower(pathinfo($imageName, PATHINFO_EXTENSION)); $allowedImage = ['jpg', 'jpeg', 'png', 'webp']; if (!in_array($imageExt, $allowedImage)) { die("Only JPG, JPEG, PNG, WEBP files allowed."); } $newImage = 'service_' . time() . '_' . rand(1111, 9999) . '.' . $imageExt; $imagePath = "./assets/images/service/" . $newImage; if (move_uploaded_file($imageTmp, $imagePath)) { // Delete old image if (!empty($old_image) && file_exists("./assets/images/service/" . $old_image)) { unlink("./assets/images/service/" . $old_image); } $Image = $newImage; } } // Update query $sqlUpdate = "UPDATE product SET Image = '$Image', title = '$title', slug = '$slug', description = '$description', activity = '$activity', t_id = '$top_cat_id' WHERE p_id = '$pro_id'"; $updateQuery = mysqli_query($con, $sqlUpdate); if ($updateQuery) { header("Location: view_product.php"); exit(); } else { echo "Update Failed: " . mysqli_error($con); } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <title>Service Update</title> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta content="" name="description" /> <meta content="" name="author" /> <!-- App favicon --> <!-- <link rel="shortcut icon" href="assets/images/favicon.ico" /> --> <!-- Plugins css --> <link href="assets/libs/dropzone/dropzone.css" rel="stylesheet" type="text/css" /> <link rel="stylesheet" type="text/css" href="https://use.fontawesome.com/releases/v5.8.1/css/all.css"> <link rel="shortcut icon" href="./assets/logo/fav.png" /> <!-- Bootstrap Css --> <link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css" /> <!-- Icons Css --> <link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" /> <!-- App Css--> <link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css" /> <!-- App js --> <!-- <script src="assets/js/plugin.js"></script> --> <style> .form .input { width: 100%; background: white; border: none; padding: 15px 20px; border-radius: 20px; margin-bottom: 9px; margin-top: 15px; box-shadow: rgba(0, 0, 0, 0.24) 0px 3px 8px; border-inline: 2px solid transparent; } input[name='Image'] { display: none; } div#upload { cursor: pointer; } ::-webkit-file-upload-button { display: none; } .filepath { display: none; } img[alt="img"] { width: clamp(50px, 15%, 100px); aspect-ratio: 1/0.70; } </style> </head> <body data-sidebar="dark"> <!-- <body data-layout="horizontal" data-topbar="dark"> --> <!-- Begin page --> <div id="layout-wrapper"> <div class="w-80 "> <div class="page-content" style="width: 80%;margin-left: 260px;"> <div class="container"> <!-- start page title --> <div class="row"> <div class="col-12"> <div class="page-title-box d-sm-flex align-items-center justify-content-between"> <h4 class="mb-sm-0 font-size-18">update Product</h4> </div> </div> </div> <!-- end page title --> <div class="row"> <div class="tab-content" id="myTabContent"> <div class="tab-pane fade show active" id="home" role="tabpanel" aria-labelledby="home-tab"> <div class="col-12"> <div class="card"> <div class="card-body"> <div> <form class="form" action="" method="POST" enctype="multipart/form-data"> <!-- Hidden for old image --> <input type="hidden" name="old_image" value="<?php echo $row['Image']; ?>"> <div class="dropzone"> <div class="fallback"> <input type="file" name="Image" id="imageInput" /> </div> <div class="dz-message needsclick" id="upload"> <div class="mb-3"> <i class="display-4 text-muted bx bxs-cloud-upload"></i> </div> <h4>Drop files here or click to upload.</h4> </div> </div> <ul class="list-unstyled mb-0" id="dropzone-preview"></ul> <!-- Preview --> <div class="filepath" style="display:block; margin-top:10px;"> <img id="previewImg" src="./assets/images/service/<?php echo $row['Image']; ?>" alt="img" style="max-height:150px;"> <span id="filename"><?php echo $row['Image']; ?></span> </div> <br> <div class="row"> <div class="col-lg-3"> <label class="form-label">Select Top Category</label> <select class="form-select" name="top_cat_id" id="top_category" required> <option value="">Select Top Level Category</option> <?php $qr = "SELECT * FROM tbl_top_category ORDER BY cat_name ASC"; $results = mysqli_query($con, $qr); while ($rows = mysqli_fetch_assoc($results)) { $selected = ($row['t_id'] == $rows['t_id']) ? 'selected' : ''; echo '<option ' . $selected . ' value="' . $rows['t_id'] . '">' . $rows['cat_name'] . '</option>'; } ?> </select> </div> <div class="col-lg-3"> <label for="">Title</label> <input type="text" class="form-control" id="title" name="title" value="<?php echo $row['title']; ?>" placeholder="Enter Your title" onkeyup="generateSlug()" /> </div> <div class="col-lg-3"> <label for="">Slug</label> <input type="text" class="form-control" id="slug" name="slug" value="<?php echo $row['slug']; ?>" placeholder="Enter Your slug" /> </div> <div class="col-md-3"> <label for="">Activity</label> <select id="formrow-inputState" class="form-select" name="activity"> <option disabled <?= empty($row['activity']) ? 'selected' : '' ?>>Select activity</option> <option value="yes" <?= ($row['activity'] ?? '') == "yes" ? 'selected' : '' ?>>Yes</option> <option value="no" <?= ($row['activity'] ?? '') == "no" ? 'selected' : '' ?>>No</option> </select> </div> </div> <br> <label for="">Description</label> <textarea name="description" id="Experience"><?php echo htmlspecialchars($row['description'] ?? ''); ?></textarea> <div class="text-center mt-4"> <button type="submit" name="update" class="btn btn-primary" value="submit"> Update </button> <a href="view_product.php"><button type="button" class="btn btn-danger">View Data</button></a> </div> </form> </div> </div> </div> </div> </div> </div> <!-- end col --> </div> <!-- end row --> </div> <!-- container-fluid --> </div> <!-- End Page-content --> </div> <!-- end main content--> </div> <!-- END layout-wrapper --> <!-- JAVASCRIPT --> <script src="assets/libs/jquery/jquery.min.js"></script> <script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script> <script src="assets/libs/metismenu/metisMenu.min.js"></script> <script src="assets/libs/simplebar/simplebar.min.js"></script> <script src="assets/libs/node-waves/waves.min.js"></script> <!-- Plugins js --> <script src="assets/libs/dropzone/dropzone-min.js"></script> <!-- Form file upload init js --> <script src="assets/js/pages/form-file-upload.init.js"></script> <script src="assets/js/app.js"></script> <script src="./ck editor/ckeditor.js"></script> <script> ['Experience', 'Experience1', 'Experience2', 'Experience3'].forEach(function(id) { CKEDITOR.replace(id); }); </script> <script> const imgInput = document.querySelector("input[name='Image']"); const uploadBox = document.getElementById('upload'); const previewImg = document.getElementById('previewImg'); const filenameSpan = document.getElementById('filename'); uploadBox.onclick = () => imgInput.click(); imgInput.onchange = () => { if (imgInput.files.length > 0) { const file = imgInput.files[0]; const fileURL = URL.createObjectURL(file); previewImg.src = fileURL; filenameSpan.textContent = file.name; document.querySelector(".filepath").style.display = 'block'; } }; </script> <!-- slug auto --> <script> function generateSlug() { let title = document.getElementById("title").value; let slug = title.toLowerCase() .replace(/[^a-z0-9\s-]/g, '') .replace(/\s+/g, '-') .replace(/-+/g, '-') .trim(); document.getElementById("slug").value = slug; } </script> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <script> $(document).ready(function() { function loadMidCategory(topCatId, selectedMid = '') { if (topCatId != "") { $.ajax({ url: "get_mid_categories.php", type: "POST", data: { t_id: topCatId }, success: function(data) { $("#mid_category").html(data); if (selectedMid != '') { $("#mid_category").val(selectedMid); } } }); } } // On change $("#top_category").change(function() { var topCatId = $(this).val(); loadMidCategory(topCatId); }); // 🔥 AUTO LOAD ON EDIT PAGE var selectedTop = "<?php echo $row['t_id']; ?>"; var selectedMid = "<?php echo $row['m_id']; ?>"; if (selectedTop != "") { loadMidCategory(selectedTop, selectedMid); } }); </script> <script> document.getElementById('l_id').addEventListener('change', function() { const locationId = this.value; if (!locationId) { document.getElementById('l_description').value = ''; return; } fetch('get-pro-location.php', { method: 'POST', headers: { 'Content-Type': 'application/x-www-form-urlencoded' }, body: 'pro_id=<?= $pro_id ?>&l_id=' + locationId }) .then(res => res.json()) .then(data => { console.log(data); if (CKEDITOR.instances['Experience2']) { CKEDITOR.instances['Experience2'].setData(data.l_description ?? ''); } }) .catch(err => console.error(err)); }); </script> <!-- --> </body> </html>
Save
Cancel