D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
sg.encodersunlimited.com
/
sgadminpr
/
Filename :
edit-testimonial.php
back
Copy
<?php require_once('config.php'); // Fetch testimonial details by ID if (isset($_GET['id'])) { $id = $_GET['id']; $sql = "SELECT * FROM testimonials WHERE id = '$id'"; $result = mysqli_query($conn, $sql); $testimonial = mysqli_fetch_assoc($result); } // Update testimonial details if ($_SERVER['REQUEST_METHOD'] == 'POST') { $name = $_POST['name']; $designation = $_POST['designation']; $description = $_POST['description']; // Handle image upload (optional) if (isset($_FILES['image']) && $_FILES['image']['error'] == 0) { $image = 'uploads/' . $_FILES['image']['name']; move_uploaded_file($_FILES['image']['tmp_name'], $image); } else { $image = $testimonial['image']; } $sql = "UPDATE testimonials SET name = '$name', designation = '$designation', description = '$description', image = '$image' WHERE id = '$id'"; if (mysqli_query($conn, $sql)) { header("Location: show-testimonial.php"); exit(); } else { echo "Error: " . $sql . "<br>" . mysqli_error($conn); } } ?> <!doctype html> <html lang="en"> <head> <title>Edit Testimonial</title> <?php include('../style2.php'); ?> </head> <body> <div class="dashboard__page--wrapper"> <?php include('sidebar.php'); ?> <div class="page__body--wrapper" id="dashbody__page--body__wrapper"> <main class="main__content_wrapper"> <div class="dashboard__container add__property--container"> <div class="add__property--heading mb-30"> <h2 class="add__property--heading__title">Edit Testimonial</h2> </div> <div class="add__property__inner d-flex"> <div class="add__property--step__inner"> <div class="add__property--box mb-30"> <form class="add__property--form" action="" method="POST" enctype="multipart/form-data"> <div class="row"> <div class="col-12 mb-20"> <label class="add__listing--input__label">Name</label> <input type="text" name="name" class="add__listing--input__field" value="<?php echo $testimonial['name']; ?>" required> </div> <div class="col-12 mb-20"> <label class="add__listing--input__label">Designation</label> <input type="text" name="designation" class="add__listing--input__field" value="<?php echo $testimonial['designation']; ?>" required> </div> <div class="col-12 mb-20"> <label class="add__listing--input__label">Description</label> <textarea name="description" class="add__listing--textarea__field" required><?php echo $testimonial['description']; ?></textarea> </div> <div class="col-12 mb-20"> <label class="add__listing--input__label">Image</label> <input type="file" name="image" class="add__listing--input__field" accept="image/*"> <img src="<?php echo $testimonial['image']; ?>" alt="Testimonial Image" width="100"> </div> <div class="col-12"> <button type="submit" class="btn btn-primary">Update Testimonial</button> </div> </div> </form> </div> </div> </div> </div> </main> </div> </div> <?php include 'footer.php'; ?> </body> </html>