Sid Gifari File Manager

📝 Editing: add-product.php

<?php
include('../library/raso_function.php');
check_admin();

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

$category_id=addslashes($_POST['category_id']);
  $sub_id=addslashes($_POST['sub_id']);
  $description=addslashes($_POST['description']);
  $specification=addslashes($_POST['specification']);
  $name=addslashes($_POST['name']);
  $team_name=addslashes($_POST['team_name']);
  $year=addslashes($_POST['year']);
  $player_name=addslashes($_POST['player_name']);
  $price=addslashes($_POST['price']);
  $mrp=addslashes($_POST['mrp']);
  $status=addslashes($_POST['status']);
  $date=addslashes(date('Y-m-d'));
  $hid_id=($_POST['hid_id']!='')?addslashes($_POST['hid_id']):false;
  
  $qry_last=exeQuery("select product_id from ".TABLE_PRODUCT." order by product_id desc");
  $res_last = fetchAssoc($qry_last);
  $product_id= $res_last['product_id']+1;
  $product_code="c2c".$hid_id;
  $product_code1="c2c".$product_id;

if(@$_FILES['image']['tmp_name']!="")
  {
    $image_name=time().$_FILES['image']['name'];
    if($_FILES['image']['type']=="image/png" or $_FILES['image']['type']=="image/jpeg" or $_FILES['image']['type']=="image/gif")
    {
      $file_move=move_uploaded_file($_FILES['image']['tmp_name'],"../upload/product/".$image_name);
      if(!$file_move)
      {
        $_SESSION['msg']="Image failed to upload!!!";
        $_SESSION['msg_type']="alert-danger";
        header("Location:".$_SERVER[REQUEST_URI]);
        exit();
      }
      else
      {
        $set.=" , product_image='".$image_name."'";
      }
    }
  }

if($name=="")
  {
    $_SESSION['msg']="Name is empty";
    
  }else{

if($hid_id==false)
    {

$insert=exeQuery("insert into ".TABLE_PRODUCT." set product_name='".$name."',status='".$status."',product_description='".$description."',created_date='".$date."' $set,team_name='".$team_name."',price='".$price."',mrp='".$mrp."',category_id='".$category_id."',sub_id='".$sub_id."',created_by='".$_SESSION['admin_id']."',specification='".$specification."',year='".$year."',player_name='".$player_name."',product_code='".$product_code1."' ");

if($insert)
      {
       $_SESSION['msg']="Product inserted successfully";
     }else{
       $_SESSION['msg']="something went wrong";
     }

}else{

if($file_move)
    {
      $qry_event_image=exeQuery("select * from ".TABLE_PRODUCT." where product_id='".$hid_id."'");
      $res_image=fetchAssoc($qry_event_image);
      if($res_image['product_image']!="")
      {
        unlink("../upload/product/".$res_image['product_image']);
      }
    }

$insert=exeQuery("update ".TABLE_PRODUCT." set product_name='".$name."',status='".$status."',product_description='".$description."',created_date='".$date."' $set,team_name='".$team_name."',price='".$price."',mrp='".$mrp."',category_id='".$category_id."',sub_id='".$sub_id."',created_by='".$_SESSION['admin_id']."',specification='".$specification."',year='".$year."',player_name='".$player_name."',product_code='".$product_code."' where product_id='".$hid_id."' ");

if($insert)
    {
     $_SESSION['msg']="Product updated successfully";
   }else{
     $_SESSION['msg']="something went wrong";
   }
 }
}
}

if(@$_REQUEST['id']!="")
{
  $id=$_REQUEST['id'];
  $qry_edit=exeQuery("select * from ".TABLE_PRODUCT." where product_id='".$id."'");
  $res_product=fetchAssoc($qry_edit);
}

$select_category = exeQuery("select * from ".TABLE_CATEGORY." where status=1 ");

?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title><?=SITENAME;?></title>
  
  <meta name="viewport" content="width=device-width, initial-scale=1">

<link rel="stylesheet" href="plugins/fontawesome-free/css/all.min.css">
  
  <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
  
  <link rel="stylesheet" href="dist/css/adminlte.min.css">
  
  <link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
  <link rel="stylesheet" href="plugins/summernote/summernote-bs4.css">
</head>
<body class="hold-transition sidebar-mini">
  <div class="wrapper">
    
    <?php include("include/header.php");?>

<?php include("include/sidebar.php");?>

<div class="content-wrapper">
      
      <section class="content-header">
        <div class="container-fluid">
          <div class="row mb-2">
            <div class="col-sm-6">
              <h1>Add Product</h1>
            </div>
            <div class="col-sm-6">
              <ol class="breadcrumb float-sm-right">
                <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                <li class="breadcrumb-item active">Product</li>
              </ol>
            </div>
          </div>
        </div>
      </section>
      <?php
      if($_SESSION['msg']!="")
      {
        $class=(@$_SESSION['msg_type']!="")?$_SESSION['msg_type']:"alert-info";
        ?>
        <div class="alert <?=$class;?> alert-dismissible">
          <button type="button" class="close" data-dismiss="alert">&times;</button>
          <?php echo $_SESSION['msg']; unset($_SESSION['msg']); unset($_SESSION['msg_type']);?>
        </div>
        <?php
      }
      ?>
      
      <section class="content">
        <div class="container-fluid">
          <div class="row">
            
            <div class="col-md-12">
              
              <div class="card card-primary">
                <div class="card-header">
                  <h3 class="card-title">Add Product</h3>
                </div>
                
                
                <form role="form" action="" method="post" enctype="multipart/form-data">
                  <div class="card-body">
                    <div class="row">
                      <div class="col-md-4">
                        <div class="form-group">
                          <label for="exampleInputEmail1"> Category Name</label>
                          <select name="category_id" class="form-control" id="category_id" onchange="get_sub()">
                            <?php
                            while($res_category = fetchAssoc($select_category))
                            {
                              ?>
                              <option value="<?=$res_category['category_id'];?>" <?php if($res_category['category_id']==$res_product['category_id']){echo 'selected';}?>><?=$res_category['category_name'];?></option> 
                              <?php
                            }
                            ?>
                          </select>
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label for="exampleInputEmail1">Sub Category Name</label>
                          <select name="sub_id" class="form-control" id="sub_id">
                            <option value="default">Sub Category Name</option>
                          </select>
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label for="exampleInputEmail1">Product Name</label>
                          <input type="text" name="name" class="form-control" placeholder="Product Name" value="<?=$res_product['product_name'];?>">
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label for="exampleInputEmail1">Product Price</label>
                          <input type="text" name="price" class="form-control" placeholder="Product Price" value="<?=$res_product['price'];?>">
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label for="exampleInputEmail1">Product Mrp Price</label>
                          <input type="text" name="mrp" class="form-control" placeholder="Product Mrp Price" value="<?=$res_product['mrp'];?>">
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label for="exampleInputEmail1">Player Name</label>
                          <input type="text" name="player_name" class="form-control" placeholder="Player Name" value="<?=$res_product['player_name'];?>">
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label for="exampleInputEmail1">Year</label>
                          <input type="text" name="year" class="form-control" placeholder="Year" value="<?=$res_product['year'];?>">
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label for="exampleInputEmail1">Team Name</label>
                          <input type="text" name="team_name" class="form-control" placeholder="Team Name" value="<?=$res_product['team_name'];?>">
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label for="exampleInputEmail1">Card Image</label>
                          <input type="file" class="form-control" id="exampleInputEmail1" name="image">
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                         <?php echo ($res_product['product_image']!="" and file_exists("../upload/product/".$res_product['product_image']))?"<img  src='../upload/product/".$res_product['product_image']."' height='100px;' class='img-fluid'>":"No Image";?>
                       </div>
                     </div>
                     <div class="col-md-12">
                      <div class="form-group">
                        <label for="exampleInputEmail1">Description</label>
                        <textarea class="textarea" placeholder="Place some text here"
                        style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;" name="description"><?=$res_product['product_description'];?></textarea>
                      </div>
                    </div>
                    <div class="col-md-12">
                      <div class="form-group">
                        <label for="exampleInputEmail1">Specification</label>
                        <textarea class="textarea" placeholder="Place some text here"
                        style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;" name="specification"><?=$res_product['specification'];?></textarea>
                      </div>
                    </div>
                    <div class="col-md-4">
                      <div class="form-group">
                        <label for="inputStatus">Status</label>
                        <select class="form-control custom-select" name="status">
                          <option selected disabled>Select one</option>
                          <option value="1"  <?php if($res_product['status']=='1'){echo "selected";} ?>>Activate</option>
                          <option value="0"  <?php if($res_product['status']=='0'){echo "selected";} ?>>Deactivate</option>
                        </select>
                      </div>
                    </div>
                  </div>
                </div>
                
                <div class="card-footer">
                 <button type="button" class="btn btn-danger">cancel</button>
                 <input type="hidden" name="hid_id" value="<?=$res_product['product_id'];?>">
                 <button type="submit" name="submit" class="btn btn-primary">Submit</button>
               </div>
             </form>
           </div>

</div>
         
       </div>
       
     </div>
   </section>
   
 </div>
 
 <?php include("include/footer.php");?>
</div>

<script src="plugins/jquery/jquery.min.js"></script>

<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>

<script src="plugins/bs-custom-file-input/bs-custom-file-input.min.js"></script>

<script src="dist/js/adminlte.min.js"></script>

<script src="dist/js/demo.js"></script>
<script src="plugins/summernote/summernote-bs4.min.js"></script>
<script>
  $(function () {
    // Summernote
    $('.textarea').summernote()
  })
</script>
<script type="text/javascript">
  $(document).ready(function () {
    bsCustomFileInput.init();
  });

$(document).ready(function(){
    <?php $preVal=($res_product['sub_id']!='')?addslashes($res_product['sub_id']):0;?>
    function get_sub(preVal)
    {
      var category_id=$("#category_id").val();
      $.ajax({
        method: "POST",
        url: "ajax.php",
        data: {'category_id':category_id,'preVal':preVal}
      })
      .done(function(res) {
        $("#sub_id").html(res);
      });
    }

$("#category_id").change(function(){
      get_sub('<?=$preVal?>');
    });
    get_sub('<?=$preVal?>');
  });
</script>
</body>
</html>