1#@!#!123s

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

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

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

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

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

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

        $sql_update = "UPDATE client SET organization='$organization', web_link='$web_link', status='$status' WHERE c_id=$id";

    }else{

        $logo = $_FILES['logo']['name'];
        $logo = explode(".", $_FILES['logo']['name']);
        $logo = end($logo);
        $logo_name = $organization.date('Ymdhis').".".$logo;

        $sql_update = "UPDATE client SET organization='$organization', web_link='$web_link', logo='$logo_name', status='$status' WHERE c_id=$id";

        move_uploaded_file($_FILES['logo']['tmp_name'], 'img/clients/'.$logo_name);

    }

  $run_udate_query = mysqli_query($conn, $sql_update);

 if ($run_udate_query) { 

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

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

}

}

mainheader('Client Update', '1cl');
?>
      <!--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"><a href="testimonial.php">Testimonial</a></li>
                              <li class="breadcrumb-item active" aria-current="page">Client 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;">Client Update</h4>
                        
                        </div>
                        <?php include 'messege.php'; ?>
                              <form action="<?php $_SERVER['PHP_SELF']; ?>" method="POST" enctype="multipart/form-data">
                                <div class="form-group">
                                      <label class="control-label col-md-3">Organization</label>
                                      <div class="col-md-9">
                                          <input type="text" name="organization" value="<?= $row['organization']; ?>" class="form-control" required />
                                      </div>
                                  </div>

                                  <div class="form-group">
                                      <label class="control-label col-md-6">Web Link </label>
                                      <div class="col-md-9">
                                          <input type="text" name="web_link" value="<?= $row['web_link']; ?>" class="form-control" />
                                       </div>
                                  </div>

                                   <div class="form-group">
                                      <label class="control-label col-md-3">Logo</label>
                                      <div class="col-md-9">
                                          <input type="file" name="logo" class="form-control" /><br>
                                          <img src="img/clients/<?= $row['logo']; ?>" width="100px">
                                      </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_client" class="btn btn-primary">
                                      </div>
                                  </div>

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

              </div>

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

<?php footer(); ?>