1#@!#!123s

file_get_contents 1#@!#!123s
: / home3 / wwwcraftenterpri / www / admin /
Filename : update-products.php
back
<?php
session_start();
include('config.php');

if(!isset($_SESSION['user'])){
  header("Location: index.php"); 
}
$id = $_GET['edit'];
if(isset($_POST["update_product"])){
 
  $product_name = mysqli_real_escape_string($conn,$_POST['product_name']);
  $product_description = mysqli_real_escape_string($conn,$_POST['product_description']);
  $product_rate = mysqli_real_escape_string($conn,$_POST['product_rate']);
  $min_order_qty = mysqli_real_escape_string($conn,$_POST['min_order_qty']);

  $Update_query = "UPDATE  products SET product_name =  '$product_name',product_description =  '$product_description',product_rate =  '$product_rate',min_order_qty =  '$min_order_qty' WHERE id = '$id'";
  $conn->query($Update_query);
  $Sucess = true;
}

if(!empty($_FILES['product_image']['name'] )){
  $product_image = $_FILES['product_image']['name'];
  $Update_query = "UPDATE  products SET product_image = '$product_image' WHERE id = '$id'";
  $conn->query($Update_query);
  $target_file_logo =  $target_dir_product_images . basename($_FILES["product_image"]["name"]);
  move_uploaded_file($_FILES["product_image"]["tmp_name"], $target_file_logo);
  $Sucess = true;
}
?>


<!DOCTYPE html>
<html>
    <head>
        <title>Update product</title>
        <meta charset="utf-8">
        <script src="http://code.jquery.com/jquery-1.11.1.min.js"></script>
        <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.min.css" rel="stylesheet" integrity="sha384-T8Gy5hrqNKT+hzMclPo118YTQO6cYprQmhrYwIiQ/3axmI1hQomh7Ud2hPOy8SP1" crossorigin="anonymous">
        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.0/js/bootstrap.min.js"></script>
        <link href = "./css/dashboard.css" rel = "stylesheet">
        <link href = "./css/main.css" rel = "stylesheet"> 
        <link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.0/css/bootstrap.min.css">
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.0/css/bootstrap-theme.min.css">
    </head>
    
    <body class = "home">
      <div class="container-fluid display-table">
          <div class="row display-table-row">
              <div class="col-md-2 col-sm-1 hidden-xs display-table-cell v-align box" id="navigation">
                  <div class="navi">
                      <ul>
                      <li ><br></li>
                      <li><a href="manage_brands.php"><i class="fa fa-tasks" aria-hidden="true"></i><span class="hidden-xs hidden-sm">  Manage Brands</span></a></li>
                          <li class = "active"><a href="manage_products.php"><i class="fa fa-tasks" aria-hidden="true"></i><span class="hidden-xs hidden-sm">  Manage products</span></a></li>
                          <li ><a href="manage_clientele.php"><i class="fa fa-user" aria-hidden="true"></i><span class="hidden-xs hidden-sm">  Manage Clientele</span></a></li>
                          <li  ><a href="change_details.php"><i class="fa fa-key" aria-hidden="true"></i><span class="hidden-xs hidden-sm">  Change Password</span></a></li>
                      </ul>
                  </div>
              </div>
              <div class="col-md-10 col-sm-11 display-table-cell v-align">
                  <div class="row">
                      <header>
                        <div class="product_logo_dashboard">
                            <a href="#"><img src="../images/logo_1.png" class="img-fluid" alt=""></a>
                        </div>
                          <div class="col-md-7">
                              <nav class="navbar-default pull-left">
                                  <div class="navbar-header">
                                      <button type="button" class="navbar-toggle collapsed" data-toggle="offcanvas" data-target="#side-menu" aria-expanded="false">
                                          <span class="sr-only">Toggle navigation</span>
                                          <span class="icon-bar"></span>
                                          <span class="icon-bar"></span>
                                          <span class="icon-bar"></span>
                                      </button>
                                  </div>
                              </nav>
                          </div>
                          <div class="col-md-5">
                              <div class="header-rightside">
                                  <ul class="list-inline header-top pull-right">
                                      <li class="dropdown">   
                                        <a href="index.php" class="view btn-sm active">Log out</a>
                                      </li>
                                  </ul>
                              </div>
                          </div>
                      </header>
                  </div>
                  <div class="user-dashboard">
                      <div class = "container">
                        <br>
                        <div class="section_title text-center">
                          <?php
                            if(isset($Sucess)){
                          ?>
                            <div class="alert alert-success alert-dismissible" role="alert">
                                products has been Updated successfully
                                <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                          <?php }?>
                          <h2>Update Product</h2>
                        </div>
                        <?php 
                          $id = $_GET['edit']; 
                          $fetch_query = "SELECT * FROM products WHERE id=$id";
                          $result = $conn->query($fetch_query);
                          while($rows = $result->fetch_assoc())  
                          {
                        ?>
                          <form method = "POST" enctype="multipart/form-data">
                            <div class="form-group">
                              <label>Product Name</label>
                              <input class="form-control " name = "product_name" type="text" value='<?php echo $rows['product_name'];?>'>
                            </div>
                            <div class="form-group">
                              <label>Product Description</label>
                              <textarea class="form-control " name = "product_description"><?php echo $rows['product_description']; ?></textarea>
                            </div>
                            <div class="form-group">
                              <label>Product Image</label>
                              <img class = "thumbnail" id = "product_image" src="<?php echo $target_dir_product_images . $rows['product_image'];?>">
                              <input class="form-control file_selector" name = "product_image" id = "product_image_Selector" type="file" value="<?php echo $target_dir_product_images . $rows['product_image'];?>">
                              <span>image size: 370 x 250px</span>
                            </div>
                            <div class="form-group">
                              <label>Product Rate</label>
                              <input class="form-control " name = "product_rate" type="number" value='<?php echo $rows['product_rate'];?>' required>
                            </div>
                            <div class="form-group">
                              <label>Min Order Quantity</label>
                              <input class="form-control " name = "min_order_qty" type="text" value='<?php echo $rows['min_order_qty'];?>' required>
                            </div>
                            <button type="submit" name="update_product" class="btn deneb_btn btn-lg update_btn">Update</button>
                          </form>
                        <?php }?>
                      </div>
                    <div>
                  </div>
                </div>
                    
              </div>
          </div>
      </div>
      <script>
        $(document).ready(function(){
            var product_image = document.getElementById('product_image_Selector').defaultValue;
            console.log(product_logo);
            document.getElementById('product_image').src = product_image;
          });
      </script>
    </body>
</html>