📁 File Manager
Editing:
/home/wedigitalindia/www/jaybalajiassociates.com/admin/edit_solution.php
<?php include("connection.php"); include("header.php"); ini_set('display_errors', 1); error_reporting(E_ALL); // Get ID $id = (int)($_GET['id'] ?? 0); if ($id <= 0) die("Invalid Solution"); // Fetch solution $solution = mysqli_fetch_assoc( mysqli_query($con, "SELECT * FROM solutions WHERE id=$id") ); if (!$solution) die("Solution not found"); // Slug generator function generateSlug($string) { return trim(preg_replace('/[^A-Za-z0-9-]+/', '-', strtolower($string)), '-'); } $error = ''; if (isset($_POST['submit'])) { $name = trim($_POST['name']); $slug = trim($_POST['slug']); $short = $_POST['short_description'] ?? ''; $desc = $_POST['description'] ?? ''; if ($name == '') { $error = "Solution name is required"; } else { $slug = generateSlug($slug ?: $name); // Ensure unique slug (ignore current ID) $chk = mysqli_query($con, "SELECT id FROM solutions WHERE slug='$slug' AND id!=$id" ); if (mysqli_num_rows($chk) > 0) { $slug .= '-' . time(); } $name = mysqli_real_escape_string($con, $name); $slug = mysqli_real_escape_string($con, $slug); $short = mysqli_real_escape_string($con, $short); $desc = mysqli_real_escape_string($con, $desc); // Image update (optional) $imageSql = ''; if (!empty($_FILES['image']['name'])) { $uploadDir = "./assets/images/solutions/"; // remove old image if ($solution['image'] && file_exists($uploadDir.$solution['image'])) { unlink($uploadDir.$solution['image']); } $ext = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION); $img = time().'_'.uniqid('srv_').'.'.$ext; move_uploaded_file($_FILES['image']['tmp_name'], $uploadDir.$img); $imageSql = ", image='$img'"; } // Update $sql = "UPDATE solutions SET name='$name', slug='$slug', short_description='$short', description='$desc' $imageSql WHERE id=$id"; if (mysqli_query($con, $sql)) { header("Location: view_solutions.php"); exit; } else { $error = mysqli_error($con); } } } ?> <div class="main-content"> <div class="page-content"> <div class="container-fluid"> <h4>Edit solution</h4> <?php if ($error): ?> <div class="alert alert-danger"><?php echo $error; ?></div> <?php endif; ?> <form method="POST" enctype="multipart/form-data"> <div class="row mb-3"> <div class="col-md-4"> <label>Solution Name</label> <input type="text" name="name" id="name" class="form-control" value="<?php echo htmlspecialchars($solution['name']); ?>" onkeyup="generateSlug()" required> </div> <div class="col-md-4"> <label>Slug</label> <input type="text" name="slug" id="slug" class="form-control" value="<?php echo htmlspecialchars($solution['slug']); ?>"> </div> <div class="col-md-4"> <label>Solutions Image</label> <input type="file" name="image" class="form-control" accept="image/*"> <?php if (!empty($solution['image'])): ?> <img src="assets/images/solutions/<?php echo htmlspecialchars($solution['image']); ?>" class="img-thumbnail mt-2" style="max-height:120px;"> <?php endif; ?> </div> </div> <div class="mb-3"> <label>Short Description</label> <textarea name="short_description" id="short_desc" class="form-control" rows="3"><?php echo htmlspecialchars($solution['short_description']); ?></textarea> </div> <div class="mb-3"> <label>Description</label> <textarea name="description" id="description" class="form-control" rows="6"><?php echo htmlspecialchars($solution['description']); ?></textarea> </div> <button name="submit" class="btn btn-primary">Update solution</button> <a href="view_solutions.php" class="btn btn-danger">Back</a> </form> </div> </div> </div> <?php include("footer.php"); ?> <script src="./ck editor/ckeditor.js"></script> <script> CKEDITOR.replace('description'); CKEDITOR.replace('short_desc'); function generateSlug() { let text = document.getElementById("name").value.toLowerCase() .replace(/[^a-z0-9\s-]/g,'') .replace(/\s+/g,'-') .replace(/-+/g,'-') .replace(/^-+|-+$/g,''); document.getElementById("slug").value = text; } </script>
Save
Cancel