📁 File Manager
Editing:
/home/wedigitalindia/public_html/mvskpowdercoating.com/admin/category-edit.php
<?php require_once('header.php'); ?> <?php if (isset($_GET['id'])) { $categoryId = $_GET['id']; $statement = $pdo->prepare("SELECT * FROM tbl_category WHERE id = ?"); $statement->execute([$categoryId]); $category = $statement->fetch(PDO::FETCH_ASSOC); if (!$category) { header('Location: category.php'); exit; } } else { header('Location: category.php'); exit; } if (isset($_POST['editCat'])) { $valid = 1; $error_message = ''; $success_message = ''; function clean($string) { $string = str_replace(' ', '-', $string); return preg_replace('/[^A-Za-z0-9\-]/', '', $string); } if (empty($_POST['name'])) { $valid = 0; $error_message .= "Category name cannot be empty<br>"; } $name = $_POST['name']; if ($valid == 1) { $statement = $pdo->prepare("UPDATE tbl_category SET name = ? WHERE id = ?"); $statement->execute([$name, $categoryId]); $success_message = 'Category is updated successfully.'; } } ?> <section class="content-header"> <div class="content-header-left"> <h1>Edit Category</h1> </div> <div class="content-header-right"> <a href="category.php" class="btn btn-primary btn-sm">View All</a> </div> </section> <section class="content"> <div class="row"> <div class="col-md-12"> <?php if (!empty($error_message)): ?> <div class="callout callout-danger"> <p><?php echo $error_message; ?></p> </div> <?php endif; ?> <?php if (!empty($success_message)): ?> <div class="callout callout-success"> <p><?php echo $success_message; ?></p> </div> <?php endif; ?> <form class="form-horizontal" name="myForm" onsubmit="return validateForm()" method="post" enctype="multipart/form-data"> <div class="box box-info"> <div class="box-body"> <div class="form-group"> <label for="" class="col-sm-3 control-label">Name <span>*</span></label> <div class="col-sm-4"> <input type="text" name="name" id="name" class="form-control" value="<?php echo htmlspecialchars($category['name']); ?>"> </div> </div> <div class="form-group"> <label for="" class="col-sm-3 control-label"></label> <div class="col-sm-6"> <button type="submit" class="btn btn-success pull-left" name="editCat">Update Category</button> </div> </div> </div> </div> </form> </div> </div> </section> <?php require_once('footer.php'); ?> <script> $("form.form-horizontal #name").on("keyup", function(){ var val = $(this).val(); var sanitizedInput = val.replace(/[^a-zA-Z0-9\-]/g, ''); val = sanitizedInput; $("form.form-horizontal #slug").val(val); }); function validateForm() { var input = $("form.form-horizontal #slug").val(); $("form.form-horizontal #slug").val(input.replace(/[^a-zA-Z0-9\-]/g, '')); } </script>
Save
Cancel