1#@!#!123s

: / proc / self / root / home / buildteksolution / public_html / superadmin /
Filename : edit-product.php
back
<?php 
include 'cn.php';
session_start();
$sno=$_GET["id"];
$sql1 = "SELECT * FROM products WHERE id='$sno'" ;
$result1 = $con->query($sql1);
$row1 = $result1->fetch_assoc();
if(isset($_SESSION['username'])) {



if(isset($_POST['submit']))
{
    date_default_timezone_set('Asia/Kolkata');
$curdate= date('d-m-Y H:i');

if( $_FILES['img']['name']==''){

$imageName=$row1['image'];
}
else
{

 $image =$_FILES['img']['tmp_name'];
        $imageName =$_FILES['img']['name'];
        $imageSize =$_FILES['img']['size'];
        $imageType =$_FILES['img']['type'];
        
       
        $target_dir = "products/";
$target_file = $target_dir . basename($_FILES["img"]["name"]);
$uploadOk = 1;
$imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));
move_uploaded_file($_FILES["img"]["tmp_name"],$target_dir.$imageName);
}
   /* echo $imageName;
     echo $_POST['name'];
     echo $_POST['price'];
     echo $_POST['category'];
     echo $_POST['description'];
     echo $_POST['pid'];die;*/
  
      
$query1 ="UPDATE `products` SET `name`='".$_POST['name']."',`category`='".$_POST['category']."',`image`='".$imageName."',`price`='".$_POST['price']."' WHERE id='$sno'";

$result=mysqli_query($con,$query1);
 echo  "<script type='text/javascript'>alert(\"Updated Successfully\")
 location.href='products.php';
  </script>";    

}
?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
<link rel="stylesheet" href="https://cdn.datatables.net/1.11.3/css/dataTables.bootstrap4.min.css" crossorigin="anonymous">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.5.2/css/bootstrap.css" crossorigin="anonymous">
    <title>Golden Sparrow Web Designers</title>
   <link rel="icon" href="https://www.goldensparrow.com.au/lo.png">
    <style>
      .scrollbar{
        
overflow:auto ;
white-space: nowrap;

      }
    </style>
  </head>
  <body>
  
    
    <div class="container-scroller">
     
    <?php include 'header.php'; ?>
        <!-- partial -->
        <div class="main-panel">
          <div class="content-wrapper pb-0">

           <div class="col-12 grid-margin stretch-card">
                <div class="card">
                  <div class="card-body">
                    <h4 class="card-title">Edit Product</h4>
                    <!-- <p class="card-description">Basic form elements</p> -->
                    <form class="forms-sample" method="post" enctype="multipart/form-data">
                      <div class="form-group">
                        <label for="exampleInputName1">Product Name</label>
                        <input type="text" class="form-control" name="name" placeholder="Name" value="<?php echo $row1['name'];  ?>" />
                      </div>
                      
                      <div class="form-group">
                        <label for="exampleInputName1">Product Category</label>
                        <select name="category"   class="form-control" required>
                        <option value="<?php echo $row1['category'];  ?>"><?php echo $row1['category'];  ?></option>
                        
                   <?php
                   include("cn.php");
                    $sqlcat = "SELECT * FROM category" ;
$resultcat = $con->query($sqlcat);

  
  while($rowcat = $resultcat->fetch_assoc()) {
       
    ?>
  <option value="<?php echo $rowcat['name'];?>"><?php echo $rowcat['name'];?></option>
  <?php } ?>
</select>
                      </div>
                     
                   <div class="form-group">
                        <label for="exampleInputName1">Price</label>
                        <input type="text" class="form-control" name="price" placeholder="Price" value="<?php echo $row1['price'];  ?>" />
                      </div>
                      
                      <div class="form-group">
                        <label for="exampleInputName1">Image</label><img src="products/<?php echo $row1['image'];  ?>" height="100" width="100">
                        <input type="file" name="img" class="form-control">
                      </div>
                      <button type="submit" class="btn btn-primary me-2" name="submit"> Submit </button>
                      
                    </form>
                  </div>
                </div>
              </div>
           
            
          
          </div>
          <!-- content-wrapper ends -->
          <!-- partial:partials/_footer.html -->
          <?php include'footer.php'; ?>
        
          <!-- partial -->
        </div>
        <!-- main-panel ends -->
      </div>
      <!-- page-body-wrapper ends -->
    </div>
    <!-- container-scroller -->
    <script src="https://code.jquery.com/jquery-3.5.1.js"></script>
<script src="https://cdn.datatables.net/1.11.3/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.11.3/js/dataTables.bootstrap4.min.js"></script>
    <script>
$(document).ready(function() {
    $('#example').DataTable();
} );
</script>
<script>
//         $(".deleteRecord").click(function(e) {
// var e_id = $(this).data("id");


// $.ajax({
//         url: "new-action.php",
//         type: 'post',
//         data: { 'e_id':e_id },
//          success: function(response) {
//             //  console.log(response);
//               if(response == 1) {
//                  alert(\"Deleted Successfully!.\")
//     location.href='index.php';
//                 //   $('#mytablerow').remove();
           
             
//          }else if(response == 0){
//             //  swal("Great","Item added To your Cart", "success");
         
//          }
//          }
//       });
// });
      </script>


  </body>
 
</html>

<?php
}
else {
  header("location:login.php");
}
?>