Tiny File Manager

Back Back Up Advanced Editor

<?php

include('config/dbcon.php');
include('authentication.php');
//session_start();

include('include/header.php');
?>

<div class="container-fluid px-4">
    
       <div class="row mt-4">
        <div class="col-md-12">
        <?php include('message.php'); ?>
         <div class="card">
                <div class="card-header">
                    <h4>Edit Service<a href="service-view.php" class="btn btn-danger float-end">Back</a></h4>
                     
                </div>
                <div class="card-body">
                <?php
                if(isset($_GET['id']))
                {
                   // $service_id = $_GET['id'];

$string = preg_replace('/[^A-Za-z0-9\-]/','-',$_GET['id']);//remove all special characters
                    $final_string = preg_replace('/-+/', '-', $string);
                    $service_id = $final_string;

$service_query = "SELECT * FROM services WHERE id= '$service_id' LIMIT 1";
                    $service_query_res = mysqli_query($con, $service_query);

if(mysqli_num_rows($service_query_res) > 0)
                    {
                        $service_row = mysqli_fetch_array($service_query_res);
                        ?>

<input type="hidden" name="service_id" value="<?= $service_row['id'] ?>">
                          
                            <div class="row">
                                
                                <div class="col-md-6 md-3">
                                  <label for="">Slug (URL)</label>
                                    <input type="text" name="slug" value="<?= $service_row['slug']; ?>" required class="form-control">
                                </div>
                                <div class="col-md-6 md-3">
                                  <label for="">Name English</label>
                                    <input type="text" name="name" value="<?= $service_row['name']; ?>" required class="form-control">
                                </div>
                                <div class="col-md-6 md-3">
                                  <label for="">Name Bangla</label>
                                    <input type="text" name="name_bn" value="<?= $service_row['name_bn']; ?>" required class="form-control">
                                </div>
                                
                                <div class="col-md-12 md-3">
                                  <label for="">Description English</label>
                                    <textarea id="summernote1" name="description" required class="form-control" rows="4"><?= $service_row['description']; ?></textarea>
                                </div>
                                <div class="col-md-12 md-3">
                                  <label for="">Description Bangla</label>
                                    <textarea id="summernote2" name="description_bn" required class="form-control" rows="4"><?= $service_row['description_bn']; ?></textarea>
                                </div>
                                
                                <div class="col-md-12 md-3">
                                  <label for="">Meta Title</label>
                                    <input type="text" name="meta_title" max="191" value="<?= $service_row['meta_title']; ?>" required class="form-control">
                                </div>
                                <div class="col-md-6 md-3">
                                  <label for="">Meta Description</label>
                                    <textarea  name="meta_description" required class="form-control" rows="4"><?= $service_row['meta_description'] ?></textarea>
                                </div>
                                <div class="col-md-6 md-3">
                                  <label for="">Meta Keyword</label>
                                    <textarea  name="meta_keyword" required class="form-control" rows="4"><?= $service_row['meta_keyword'] ?></textarea>
                                </div>
                                 
                                <div class="col-md-12 md-3">
                                  <label for="">Image</label>
                                   
                                   <input type="hidden" name="old_image" value="<?= $service_row['image'] ?>">   
                                    <input type="file" name="image" class="form-control">
                                </div>
                                <div class="col-md-6 md-3">
                                    <label for="Status">Status</label>
                                        <input type="checkbox" name="status" <?= $service_row['status'] == '1' ? 'checked':''?> width="70px" height="70px" />
                                </div>
                                <div class="col-md-6 md-3">
                                       <button type="submit" class="btn btn-primary" name="service_update">Update Service</button> 
                                </div>
                                
                            </div>
                        </form>

<?php

}else{
                    ?>
                    <h4>No Record Found.</h4>

<?php
                }
                }
                ?>

</div>
            </div>

</div>

</div>
</div>

<?php
include('include/footer.php');

include('include/script.php');