Ele57885fddfgdfgfghgقفغفغفقhfg555434536

kohjhjhصثقصثقصثقgdfgdg Ele57885fddfgdfgfghgقفغفغفقhfg555434536

<?php

include 'db.php';
    $cid=intval($_GET['cid']);
       
     $editempid = mysqli_query($db,"SELECT * from p15 where id='$cid'");

$editemp = mysqli_fetch_assoc($editempid);
    
     if(isset($_GET['cid1']))
   {

$cid1=intval($_GET['cid1']);

$insert = $db->query("update p15 set file1='' where id='$cid1'");

echo "<script>document.location='Product_edit.php?cid=$cid1'</script>"; 
   }   
   
   
   
   
    if(isset($_GET['cid2']))
   {

$cid2=intval($_GET['cid2']);

$insert = $db->query("update p15 set file2='' where id='$cid2'");

echo "<script>document.location='Product_edit.php?cid=$cid2'</script>";
    
      
      
      
   }   
   
   
    if(isset($_GET['cid3']))
   {

$cid3=intval($_GET['cid3']);

$insert = $db->query("update p15 set file3='' where id='$cid3'");

echo "<script>document.location='Product_edit.php?cid=$cid3'</script>";

}   
       
     
       if(isset($_GET['cid4']))
   {

$cid4=intval($_GET['cid4']);

$insert = $db->query("update p15 set file4='' where id='$cid1'");

echo "<script>document.location='Product_edit.php?cid=$cid4'</script>"; 
   }   
   
   
   
   
    if(isset($_GET['cid5']))
   {

$cid5=intval($_GET['cid5']);

$insert = $db->query("update p15 set file5='' where id='$cid5'");

echo "<script>document.location='Product_edit.php?cid=$cid5'</script>";
    
      
      
      
   }   
    ?>
  
<!DOCTYPE html>
<html lang="en">
   

<head>
      <meta charset="utf-8">
      <meta http-equiv="X-UA-Compatible" content="IE=edge">
      <meta name="viewport" content="width=device-width, initial-scale=1">
      <title>Product Management</title>
      
      <link rel="shortcut icon" href="assets/dist/img/ico/favicon.png" type="image/x-icon">
      
      
      <link href="assets/plugins/jquery-ui-1.12.1/jquery-ui.min.css" rel="stylesheet" type="text/css"/>
      
      <link href="assets/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css"/>
      
      
      
      <link href="assets/plugins/lobipanel/lobipanel.min.css" rel="stylesheet" type="text/css"/>
      
      <link href="assets/plugins/pace/flash.css" rel="stylesheet" type="text/css"/>
      
      <link href="assets/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
      
      <link href="assets/pe-icon-7-stroke/css/pe-icon-7-stroke.css" rel="stylesheet" type="text/css"/>
      
      <link href="assets/themify-icons/themify-icons.css" rel="stylesheet" type="text/css"/>
      
      
      
      <link href="assets/dist/css/stylecrm.css" rel="stylesheet" type="text/css"/>
      
      
      
         
         
        
          
           <script src="https://cdn.ckeditor.com/ckeditor5/11.0.1/classic/ckeditor.js"></script>
          
          
          <style>
    .ck.ck-editor__main>.ck-editor__editable:not(.ck-focused) {
    border-color: var(--ck-color-base-border);
    color: #000;
}
/*body {*/
/*    margin: 0;*/
/*    padding: 0;*/
/*    font-family: 'pt_sansregular';*/
/*    font-size: 14px;*/
    /* color: #ffffff; */
/*    height: 100%;*/
/*    -webkit-font-smoothing: antialiased;*/
/*    background-color: #ffffff;*/
/*}*/
.ck.ck-editor__main>.ck-editor__editable p,h1,h2,h3,h4,h5,h6{
    color:#000;
}
</style>
         
         
   </head>
   
   
   
   <script>

function get_subcat(value) {
  $.ajax({
  type: "POST",
  url: "get_subcat.php",
  data:'name='+value,
  success: function(data){
    $("#name1").html(data);
  }
  });
  
}

function getvillage(value) {
  $.ajax({
  type: "POST",
  url: "get_subcat1.php",
  data:'name1='+value,
  success: function(data){
    $("#name2").html(data);
  }
  });
}
function get_subcat1(value) {

$.ajax({
  type: "POST",
  url: "get_subcat2.php",
  data:'name2='+value,
  success: function(data){
    $("#name3").html(data);
  }
  });
  
}

function get_subcat2(value) {

$.ajax({
  type: "POST",
  url: "get_subcat3.php",
  data:'name3='+value,
  success: function(data){

$("#name4").html(data);
  }
  });
  
}

function get_subcat3(value) {

$.ajax({
  type: "POST",
  url: "get_subcat4.php",
  data:'name4='+value,
  success: function(data){

$("#name5").html(data);
  }
  });
  
  
  
}

function showMsg()
{

$("#msgC").html($("#district option:selected").text());
  $("#msgS").html($("#taluk option:selected").text());
  return false;
}

</script>

<body class="hold-transition sidebar-mini">
    <?php include('include/header.php'); ?>
         
         
         <div class="content-wrapper">
            
            <section class="content-header">
               <div class="header-icon">
                  <i class="fa fa-users"></i>
               </div>
               <div class="header-title">
                  <h1>Edit Product</h1>
                  <small>Product list</small>
               </div>
            </section>
            
            <section class="content">
               <div class="row">
                  
                  <div class="col-sm-12">
                     <div class="panel panel-bd lobidrag">
                        <div class="panel-heading">
                           <div class="btn-group" id="buttonlist"> 
                              <a href="#">
                                 <h4>Product Management</h4>
                              </a> 
                           </div>
                        </div>
                        <div class="panel-body">
                           <form class="col-sm-6" method="POST" action="employee4.php" enctype="multipart/form-data">

<div class="form-group">
                                 <label>Edit Category</label>
                                 <select name="name" class="form-control" onChange="get_subcat(this.value);" id="name">
                                      <option value="" hidden>~~SELECT CATEGORY~~</option>
                           <?php
                              $productSql = "SELECT * FROM p13 WHERE approve <> 'rejected' ";
                              $productData = $db->query($productSql);

while($row = $productData->fetch_array()) {                                
                                 $selected = "";
                                 if($row['name'] == $editemp["name"]) {
                                    $selected = "selected";
                                 } else {
                                    $selected = "";
                                 }

echo "<option value='".$row['name']."' id='changeProduct".$row['name']."' ".$selected." >".$row['name']."</option>";
                                 } // /while

?>
                                    
                                 </select>
                              </div>

<!--<div class="form-group">
                                 <label>Edit Sub Category</label>
                                 <select name="name1" class="form-control" onChange="getvillage(this.value);" id="name1" >
                                      <option value="" hidden>~~SELECT SUB CATEGORY~~</option>
                           <//?php
                              $productSql = "SELECT * FROM p14 WHERE name='".$editemp["name"]."' AND approve <> 'rejected'";
                              $productData = $db->query($productSql);

while($row = $productData->fetch_array()) {                                
                                 $selected = "";
                                 if($row['name1'] == $editemp["name1"]) {
                                    $selected = "selected";
                                 } else {
                                    $selected = "";
                                 }

echo "<option value='".$row['name1']."' id='changeProduct".$row['name1']."' ".$selected." >".$row['name1']."</option>";
                                 }

?>
                                    
                                 </select>
                              </div>-->
                              
                                    <!--<div class="form-group">
                                 <label>Edit Sub Category-2</label>
                                 <select name="name2" class="form-control" onChange="get_subcat1(this.value);" id="name2" >
                                      <option value="" hidden>~~SELECT SUB CATEGORY-2~~</option>
                           <?php
                              $productSql = "SELECT * FROM p39 WHERE approve <> 'rejected'";
                              $productData = $db->query($productSql);

while($row = $productData->fetch_array()) {                                
                                 $selected = "";
                                 if($row['name2'] == $editemp["name2"]) {
                                    $selected = "selected";
                                 } else {
                                    $selected = "";
                                 }

echo "<option value='".$row['name2']."' id='changeProduct".$row['name2']."' ".$selected." >".$row['name2']."</option>";
                                 } // /while

?>
                                    
                                 </select>
                              </div>
                              
                              
                              
                              
                              <div class="form-group">
                                 <label>Edit Sub Category-3</label>
                                 <select name="name3" class="form-control" onChange="get_subcat2(this.value);" id="name3" >
                                      <option value="" hidden>~~SELECT SUB CATEGORY-3~~</option>
                           <?php
                              $productSql = "SELECT * FROM p42 WHERE approve <> 'rejected' group by name1";
                              $productData = $db->query($productSql);

while($row = $productData->fetch_array()) {                                
                                 $selected = "";
                                 if($row['name3'] == $editemp["name3"]) {
                                    $selected = "selected";
                                 } else {
                                    $selected = "";
                                 }

echo "<option value='".$row['name3']."' id='changeProduct".$row['name3']."' ".$selected." >".$row['name3']."</option>";
                                 } // /while

?>
                                   
                                    
                                 </select>
                                 
                                 
                                  </div>-->
                                 
                                 
                                 <!--<div class="form-group">
                                     
                                 <label>Edit Sub Category-4</label>
                                 <select name="name4" class="form-control" onChange="get_subcat3(this.value);" id="name4" >
                                      <option value="" hidden>~~SELECT SUB CATEGORY-4~~</option>
                           <//?php
                              $productSql = "SELECT * FROM p43";
                              $productData = $db->query($productSql);

while($row = $productData->fetch_array()) {                                
                                 $selected = "";
                                 if($row['name4'] == $editemp["name4"]) {
                                    $selected = "selected";
                                 } else {
                                    $selected = "";
                                 }

echo "<option value='".$row['name4']."' id='changeProduct".$row['name4']."' ".$selected." >".$row['name4']."</option>";
                                 } // /while

?>
                                    
                                 </select>
                              </div>
                                 
                                 
                                 
                                 
                                 
                                 
                                 <div class="form-group">
                                 <label>Edit Sub Category-5</label>
                                 <select name="name5" class="form-control"  id="name5" >
                                      <option value="" hidden>~~SELECT SUB CATEGORY-5~~</option>
                           <//?php
                              $productSql = "SELECT * FROM p49";
                              $productData = $db->query($productSql);

while($row = $productData->fetch_array()) {                                
                                 $selected = "";
                                 if($row['name5'] == $editemp["name5"]) {
                                    $selected = "selected";
                                 } else {
                                    $selected = "";
                                 }

echo "<option value='".$row['name5']."' id='changeProduct".$row['name5']."' ".$selected." >".$row['name5']."</option>";
                                 } // /while

?>
                                    
                                 </select>
                              </div>-->
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                
                            
                             <!--<div class="form-group">
                                 <label>Edit Unit</label>
                                 <select name="unit" class="form-control" id="unit" >
                                      <option value="" hidden>~~SELECT UNIT~~</option>
                           <?php
                              $productSql = "SELECT * FROM p50 WHERE approve <> 'rejected' group by name";
                              $productData = $db->query($productSql);

while($row = $productData->fetch_array()) {                                
                                 $selected = "";
                                 if($row['name'] == $editemp["name10"]) {
                                    $selected = "selected";
                                 } else {
                                    $selected = "";
                                 }

echo "<option value='".$row['name']."' id='changeProduct".$row['name']."' ".$selected." >".$row['name']."</option>";
                                 } // /while

?>
                                    
                                 </select>
                              </div>-->
                              
                              
                              
                              
                              
                              
                              <div class="form-group">
                                 <label>Edit Name of the Product</label>
                                 <input type="text" name="name7" class="form-control" value="<?php echo htmlspecialchars($editemp["name7"]); ?>" placeholder="Enter Name of the Product">
                              </div>
                                
                                
                                
                                
                                
                                <div class="form-group">
                                 <label>Edit Size</label>
                                 <select name="color" class="form-control" id="unit" >
                                      <option value="" hidden>~~SELECT Size~~</option>
                           <?php
                              $productSql = "SELECT * FROM p136";
                              $productData = $db->query($productSql);

while($row = $productData->fetch_array()) {                                
                                 $selected = "";
                                 if($row['name'] == $editemp["color"]) {
                                    $selected = "selected";
                                 } else {
                                    $selected = "";
                                 }

echo "<option value='".$row['name']."' id='changeProduct".$row['name']."' ".$selected." >".$row['name']."</option>";
                                 } // /while

?>
                                    
                                 </select>
                              </div>
                              
                              
                              
                              
                              
                              
                              
                              
                              
                              
                              
                              
                              
                              
                              
                              <div class="form-group">
                                 <label>Edit Option</label>
                                 <select name="nameawnt" class="form-control" id="unit" >
                                      <option value="" hidden>~~SELECT Option~~</option>
                           <?php
                              $productSql = "SELECT * FROM p216";
                              $productData = $db->query($productSql);

while($row = $productData->fetch_array()) {                                
                                 $selected = "";
                                 if($row['name1'] == $editemp["nameawnt"]) {
                                    $selected = "selected";
                                 } else {
                                    $selected = "";
                                 }

echo "<option value='".$row['name1']."' id='changeProduct".$row['name1']."' ".$selected." >".$row['name1']."</option>";
                                 } // /while

?>
                                    
                                 </select>
                              </div>

<div class="form-group">
                                 <label>Edit Sales Price</label>
                                 <input type="text" name="price" class="form-control" value="<?php echo(isset($editemp["name12"]))?$editemp["name12"]:""; ?>" placeholder="Enter Sales Price">
                              </div>

<div class="form-group">
                                 <label>Edit Description 1</label>
                                 <textarea type="text" name="desamnt" class="form-control" placeholder="Enter Description"><?php echo(isset($editemp["desamnt"]))?$editemp["desamnt"]:""; ?></textarea>
                              </div>
                              
                              <div class="form-group">
                                 <label>Edit Description 2</label>
                                 <textarea type="text" name="desamntwtnt" class="form-control" placeholder="Enter Description"><?php echo(isset($editemp["desamntwtnt"]))?$editemp["desamntwtnt"]:""; ?></textarea>
                              </div>
                              
                              <div class="form-group">
                                 <label>Edit Video Url</label>
                                 <input type="text" name="keyamnt" class="form-control" value="<?php echo(isset($editemp["keyamnt"]))?$editemp["keyamnt"]:""; ?>" placeholder="Enter Video Url">
                              </div>
                              
                              <div class="form-group">
                                 <label>Product Image 1</label>
                                
                                 <input type="file" name="file1" class="form-control"  placeholder="Upload Owner File">
                                 <?php 
$ret=mysqli_query($db,"select * from p15 where id='$cid'");
while($row=mysqli_fetch_array($ret))
{
?>
                                  <img src= "image/product/<?php echo $row['file1'];?>" style="height:150px;width:150px;">
                                  
                                   <a type="button" class="label-danger label label-default" href="Product_edit.php?cid1=<?php echo $row['id'];?>">Remove File1 Image</a>&nbsp;
                                   <?php }
     ?>
                              </div>
                              
                              
                              <div class="form-group">
                                 <label>Product Image 2</label>
                                
                                 <input type="file" name="file2" class="form-control"  placeholder="Upload Owner File">
                                 <?php 
$ret=mysqli_query($db,"select * from p15 where id='$cid'");
while($row=mysqli_fetch_array($ret))
{
?>
                                  <img src= "image/product/<?php echo $row['file2'];?>" style="height:150px;width:150px;">
                                  
                                   <a type="button" class="label-danger label label-default" href="Product_edit.php?cid2=<?php echo $row['id'];?>">Remove File2 Image</a>&nbsp;
                                   <?php }
     ?>
                              </div>
                              
                              
                              
                               <div class="form-group">
                                 <label>Product Image 3</label>
                                
                                 <input type="file" name="file3" class="form-control"  placeholder="Upload Owner File">
                                 <?php 
$ret=mysqli_query($db,"select * from p15 where id='$cid'");
while($row=mysqli_fetch_array($ret))
{
?>
                                  <img src= "image/product/<?php echo $row['file3'];?>" style="height:150px;width:150px;">
                                  
                                   <a type="button" class="label-danger label label-default" href="Product_edit.php?cid3=<?php echo $row['id'];?>">Remove File3 Image</a>&nbsp;
                                   <?php }
     ?>
                              </div>
                              
                              
                              <div class="form-group">
                                 <label>File4</label>
                                
                                 <input type="file" name="file4" class="form-control"  placeholder="Upload Owner File">
                                 <?php 
$ret=mysqli_query($db,"select * from p15 where id='$cid'");
while($row=mysqli_fetch_array($ret))
{
?>
                                  <img src= "image/product/<?php echo $row['file4'];?>" style="height:150px;width:150px;">
                                  
                                   <a type="button" class="btn btn-danger" href="Product_edit.php?cid4=<?php echo $row['id'];?>">Remove File4 Image</a>&nbsp;
                                   <?php }
     ?>
                              </div>
                              
                              
                              <div class="form-group">
                                 <label>File5</label>
                                
                                 <input type="file" name="file5" class="form-control"  placeholder="Upload Owner File">
                                 <?php 
$ret=mysqli_query($db,"select * from p15 where id='$cid'");
while($row=mysqli_fetch_array($ret))
{
?>
                                  <img src= "image/product/<?php echo $row['file5'];?>" style="height:150px;width:150px;">
                                  
                                   <a type="button" class="btn btn-danger" href="Product_edit.php?cid5=<?php echo $row['id'];?>">Remove File5 Image</a>&nbsp;
                                   <?php }
     ?>
                              </div>
                              
                               <input type="text" name="id" hidden="" value="<?php echo(isset($editemp['id']))?$editemp['id']:''; ?>">
                               
                               <input type="text" name="type" hidden="" value="<?php echo(isset($editemp['type']))?$editemp['type']:''; ?>">

</html>