Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
revealability
/
panel
/
admin
:
edit_slider.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php session_start(); include '../assets/constant/config.php'; try { $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { echo "Connection failed: " . $e->getMessage(); } ?> <?php include('include/sidebar.php'); ?> <!-- Top Bar End --> <?php include('include/header.php'); ?> <div class="page-content-wrapper "> <div class="container-fluid"> <div class="row"> <div class="col-sm-12"> <div class="page-title-box"> <div class="btn-group float-right"> </div> <h4 class="page-title">Edit Slider</h4> </div> </div> <div class="clearfix"></div> </div> <!-- end page title end breadcrumb --> <div class="row"> <div class="col-lg-12"> <div class="card"> <div class="card-body"> <!-- Nav tabs --> <!-- Tab panes --> <div class="tab-content"> <div class="tab-pane active p-3" id="home" role="tabpanel"> <form name="myform" action="app/slider_crud.php" class="row" method="POST" enctype="multipart/form-data" onsubmit="return validation()"> <?php $stmt = $conn->prepare("SELECT * FROM `slider` WHERE id='" . $_POST['id'] . "' "); $stmt->execute(); $record = $stmt->fetchAll(); foreach ($record as $key) { ?> <input class="form-control" type="hidden" name="id" value="<?php echo $key['id']; ?>"> <div class="form-group col-md-6"> <label class="control-label">Existing Photo</label><br> <?php // Read the image file and encode it to Base64 $imagePath = "../assets/images/" . $key['photo']; // Path to your image file $imageData = file_get_contents($imagePath); $base64Image = base64_encode($imageData); ?> <input type="hidden" value="<?php echo $key['photo'] ?>" name="old_photo_img"> <img class="img-fluid" src="data:image/jpeg;base64,<?php echo $base64Image; ?>" style="width:100px;height:auto;"><br> </div> <div class="form-group col-md-6"> <label class="control-label">Change Photo<span class="text-danger">*</span>(file size must be less than 1200 x 415 pixel)</label> <input class="form-control" type="file" name="photo" value="<?php echo $key['photo'] ?>" accept=".jpeg,.png"> </div> <div class="form-group col-md-6"> <label class="control-label">Heading</label> <input class="form-control" type="text" name="heading" value="<?php echo $key['heading'] ?>" required="" /> </div> <div class="form-group col-md-6"> <label class="control-label">Heading 1</label> <input class="form-control" type="text" name="heading1" value="<?php echo $key['heading1'] ?>" required="" /> </div> <div class="form-group col-md-12"> <button class="btn btn-primary" type="submit" name="update">Update</button> </div> <?php } ?> </form> </div> </div> </div> </div><!--end card--> </div><!--end col--> </div><!--end row--> </div> <!-- Page content Wrapper --> </div> <!-- content --> <?php include('include/footer.php'); ?> <script> function validation() { var fileInput = document.getElementById('edit_slider').photo; var filePath = fileInput.value; var allowedExtensions = /(\.jpg|\.jpeg|\.png)$/i; if (!allowedExtensions.exec(filePath)) { alert('Invalid file type! Please upload a JPG, JPEG, or PNG image.'); fileInput.value = ''; return false; } return true; } </script> <script> function addSlider() { jQuery.validator.addMethod("lettersonly", function(value, element) { // Check if the value is empty if (value.trim() === "") { return false; } return /^[a-zA-Z\s]*$/.test(value); }, "Please enter alphabet characters only"); $('#add_slider').validate({ rules: { heading: { required: true, lettersonly: true }, short_text: { required: true } }, messages: { heading: { required: "Please enter the heading", pattern: "Only alphanumeric characters are allowed" }, short_text: { required: "Please enter the short text", pattern: "Only alphanumeric characters are allowed" }, }, }); }; </script>