1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / mfms22 / www / admin /
Filename : service-update.php
back
<?php 
require 'function.php';
check_login();
require '../config/database.php';

$id = mysqli_real_escape_string($conn, $_GET['id']);

$sql = "SELECT * FROM service WHERE s_id = $id";
$run_query = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($run_query);


if (isset($_POST['update_service'])) {

    $title = sanitize($conn, $_POST['title']);
    $description = mysqli_real_escape_string($conn, $_POST['description']);
    $icon = sanitize($conn, $_POST['icon']);
    $status = sanitize($conn, $_POST['status']);

    $sql_update = "UPDATE service SET title='$title', description='$description', icon='$icon', status='$status' WHERE s_id=$id";
    $run_udate_query = mysqli_query($conn, $sql_update);

 if ($run_udate_query) { 

      $_SESSION['edit_service_msg'] = "Successfully Updated "; 
      header("location: service.php");
}
  else
{

      $_SESSION['edit_service_msg'] = "Update Failed";
      header("location: service.php");

}

}


mainheader('Service Update', '1ser');
?>

      <!--main content start-->
      <section id="main-content">
          <section class="wrapper" style="min-height: 850px;">

            <!--breadcrumbs start -->
            <div class="row">
                  <div class="col-lg-12 pb-1">
                      <!--breadcrumbs start -->
                      <nav aria-label="breadcrumb">
                          <ol class="breadcrumb">
                              <li class="breadcrumb-item"><a href="start.php"><i class="fa fa-home"></i> Dashboard</a></li>
                              <li class="breadcrumb-item active" aria-current="page">Service Update</li>
                          </ol>
                      </nav>
                  </div>
              </div>
             <!--breadcrumbs end -->
          	
              <div class="row">
                  <div class="col-md-12">
                      <section class="card p-4">
                        <div class="card-header mb-3">
                          <h4 style="display: inline;">Service Update</h4>
                        
                        </div>
                        <?php include 'messege.php'; ?>
                              <form action="<?php $_SERVER['PHP_SELF']; ?>" method="POST">
                              	<div class="form-group">
                                      <label class="control-label col-md-3">Title</label>
                                      <div class="col-md-9">
                                          <input type="text" name="title" value="<?= $row['title']; ?>" class="form-control" />
                                      </div>
                                  </div>
                             
                                  <div class="form-group">
                                      <label class="control-label col-md-3">Description</label>
                                      <div class="col-md-9">
                                          <textarea class="summernote" name="description"><?= $row['description']; ?></textarea>
                                      </div>
                                  </div>

                                  <div class="form-group">
                                      <label class="control-label col-md-3">Icon Class</label>
                                      <div class="col-md-9">
                                          <input type="text" name="icon" value="<?= $row['icon']; ?>" class="form-control" />
                                      </div>
                                  </div>

                                  <div class="form-group">
                                    <div class="col-md-9">
                                    <select class="form-control" aria-label="Default select example" name="status">
                                      <option <?php if($row['status']==1){echo 'selected'; } ?> value="1">Active</option>
                                      <option <?php if($row['status']==0){echo 'selected'; } ?> value="0">Inactive</option>
                                    </select>
                                    </div>
                                   </div>

                                  <div class="form-group">
                                      <label class="control-label col-md-3"></label>
                                      <div class="col-md-9">
                                         <input type="submit" name="update_service" class="btn btn-primary" value="Update">
                                      </div>
                                  </div>

                              </form>
                      </section>
                  </div>

              </div>

          </section>
      </section>
      <!--main content end-->

<?php footer(); ?>