1#@!#!123s

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

$sc_id = $_GET['id'];



// Feature Select Query
$sql_select = "SELECT * FROM soft_screenshot WHERE sc_id=$sc_id";
$run_query_select = mysqli_query($conn, $sql_select);
$row = mysqli_fetch_assoc($run_query_select);


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

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

    if($_FILES['screenshot']['name']==NULL){

        $sql = "UPDATE soft_screenshot SET title='$title', status=$status WHERE sc_id=$sc_id";

    }else{

    $screenshot = $_FILES['screenshot']['name'];
    $screenshot = explode(".", $_FILES['screenshot']['name']);
    $screenshot = end($screenshot);
    $screenshot_name = $title.date('Ymdhis').".".$screenshot;

    $sql = "UPDATE soft_screenshot SET title='$title', screenshot='$screenshot_name', status=$status WHERE sc_id=$sc_id";
   

    move_uploaded_file($_FILES['screenshot']['tmp_name'], 'img/screenshot/'.$screenshot_name);

  }

   $query = mysqli_query($conn, $sql) or die('faild');

    if ($query) { 

          $_SESSION['update_softscreenshot_msg'] = "Data Update Successfully";  
          header("location: softscreenshot.php");
        }
          else
        {

          $_SESSION['update_softscreenshot_msg'] = "Data Update Failed";
          header("location: softscreenshot.php");

    }
}


mainheader('Software Screenshoot Update', '1ss');
?>

      <!--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">Software Screenshoot Update</li>
                          </ol>
                      </nav>
                  </div>
              </div>
             <!--breadcrumbs end -->


              <div class="row">
                  <div class="col-md-5">
                      <section class="card p-4">
                        <div class="card-header mb-3">
                          <h4 style="display: inline;">Update Screenshot</h4>
                        
                        </div>

                        
                              <form action="<?php $_SERVER['PHP_SELF'] ?>" method="POST" enctype="multipart/form-data">

                                  <div class="form-group"> 
                                      <label class="control-label col-md-6">Title </label>
                                      <div class="col-md-12">
                                          <input type="text" name="title" value="<?= $row['title']; ?>" class="form-control" required />
                                      </div>
                                  </div>

                                  <div class="form-group">
                                    <label class="control-label col-md-9">Status</label>
                                    <div class="col-md-12">
                                     <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-9">Software Screenshot</label>
                                      <div class="col-md-12">
                                          <input type="file" name="screenshot" class="form-control" />
                                      </div>
                                  </div>

                                  <div class="form-group">
                                      <div class="col-md-12">
                                          <img src="img/screenshot/<?= $row['screenshot']; ?>" width="150px">
                                      </div>
                                  </div>

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

                              </form>
                      </section>

                  </div>

                  


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


<?php footer(); ?>