📁 File Manager
Editing:
/home/wedigitalindia/www/jaybalajiassociates.com/admin/add_service.php
<?php include("connection.php"); include("header.php"); ini_set('display_errors', 1); error_reporting(E_ALL); 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 = "Service name is required"; } else { $slug = generateSlug($slug ?: $name); // unique slug $chk = mysqli_query($con, "SELECT id FROM services WHERE slug='$slug'"); 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 upload $uploadDir = "./assets/images/services/"; if (!is_dir($uploadDir)) mkdir($uploadDir, 0777, true); $image = NULL; if (!empty($_FILES['image']['name'])) { $ext = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION); $image = time().'_'.uniqid('srv_').'.'.$ext; move_uploaded_file($_FILES['image']['tmp_name'], $uploadDir.$image); } $imageSql = $image ? "'$image'" : "NULL"; $sql = "INSERT INTO services (name, slug, image, short_description, description) VALUES ('$name','$slug',$imageSql,'$short','$desc')"; if (mysqli_query($con, $sql)) { header("Location: view_services.php"); exit; } else { $error = mysqli_error($con); } } } ?> <div class="main-content"> <div class="page-content"> <div class="container-fluid"> <h4>Add Service</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>Service Name</label> <input type="text" name="name" id="name" class="form-control" onkeyup="generateSlug()" required> </div> <div class="col-md-4"> <label>Slug</label> <input type="text" name="slug" id="slug" class="form-control"> </div> <div class="col-md-4"> <label>Service Image</label> <input type="file" name="image" class="form-control" accept="image/*"> </div> </div> <div class="mb-3"> <label>Short Description</label> <textarea name="short_description" id="short_desc" class="form-control" rows="3"></textarea> </div> <div class="mb-3"> <label>Description</label> <textarea name="description" id="description" class="form-control" rows="6"></textarea> </div> <button name="submit" class="btn btn-primary">Save Service</button> <a href="view_services.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