📁 File Manager
Editing:
/home/wedigitalindia/www/jaybalajiassociates.com/admin/edittestimoni.php
<?php include("connection.php"); include("header.php"); $id = $_GET['id']; $sql = "SELECT * FROM `testimonial` WHERE `id`='$id'"; $query = mysqli_query($con, $sql); $row = mysqli_fetch_assoc($query); if (isset($_POST['update'])) { $para = mysqli_real_escape_string($con, $_POST['para']); $customer_name = mysqli_real_escape_string($con, $_POST['customer_name']); $customer_designation = !empty($_POST['customer_designation']) ? "'" . mysqli_real_escape_string($con, $_POST['customer_designation']) . "'" : "NULL"; $old_image = $_POST['old_image']; // Check if a new image is uploaded if (!empty($_FILES['Image']['name']) && $_FILES['Image']['error'] === 0) { $originalName = $_FILES['Image']['name']; $ext = pathinfo($originalName, PATHINFO_EXTENSION); // Create a unique image name $uniqueName = 'img_' . time() . '_' . uniqid() . '.' . $ext; $img_path = "./assets/images/client/" . $uniqueName; if (move_uploaded_file($_FILES['Image']['tmp_name'], $img_path)) { // Delete old image if it exists if (!empty($old_image) && file_exists("./assets/images/client/" . $old_image)) { unlink("./assets/images/client/" . $old_image); } $Image = $uniqueName; } else { echo "Failed to upload new image."; $Image = $old_image; } } else { $Image = $old_image; } $sql1 = "UPDATE `testimonial` SET `Image` = '$Image', `customer_name` = '$customer_name', `para` = '$para', `customer_designation` = $customer_designation WHERE `id` = '$id'"; $query1 = mysqli_query($con, $sql1); if ($query1) { header("Location: viewtestimoni.php"); exit(); } else { echo "Update failed: " . mysqli_error($con); } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <title>Testimonial Update</title> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta content="Premium Multipurpose Admin & Dashboard Template" name="description" /> <meta content="Themesbrand" 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-icon.jpg" /> <!-- 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"> <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">Testimonial Update</h4> </div> </div> </div> <!-- end page title --> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-body" style="margin-left: 10% !important;"> <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/client/<?php echo $row['Image']; ?>" alt="img" style="max-height:150px;"> <span id="filename"><?php echo $row['Image']; ?></span> </div> <br> <input type="text" class="form-control mb-3" name="customer_name" value="<?php echo $row['customer_name']; ?>" placeholder="Email"> <br> <input type="text" class="form-control mb-3" name="customer_designation" value="<?php echo isset($row['customer_designation']) ? $row['customer_designation'] : ''; ?>" placeholder="Customer Designation (Optional)"> <textarea placeholder="text" name="para" id="Experience" class="input" required=""> <?php echo isset($row['para']) ? htmlspecialchars($row['para']) : ''; ?> </textarea> <div class="text-center mt-4"> <button type="submit" name="update" class="btn btn-primary" value="submit"> <i class="fa fa-cloud-upload"></i> Update </button> <a href="viewtestimoni.php"><button type="button" class="btn btn-danger">View Data</button></a> </div> </form> </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> CKEDITOR.replace('Experience'); </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> </body> </html> <?php include("footer.php"); ?>
Save
Cancel