/home/globalproven/public_html/admin/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>
<!-- Tell the browser to be responsive to screen width -->
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Font Awesome -->
<link rel="stylesheet" href="plugins/fontawesome-free/css/all.min.css">
<!-- Ionicons -->
<link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
<!-- Theme style -->
<link rel="stylesheet" href="dist/css/adminlte.min.css">
<!-- Google Font: Source Sans Pro -->
<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">
<!-- Navbar -->
<?php include("include/header.php");?>
<!-- /.navbar -->
<!-- Main Sidebar Container -->
<?php include("include/sidebar.php");?>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<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><!-- /.container-fluid -->
</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">×</button>
<?php echo $_SESSION['msg']; unset($_SESSION['msg']); unset($_SESSION['msg_type']);?>
</div>
<?php
}
?>
<!-- Main content -->
<section class="content">
<div class="container-fluid">
<div class="row">
<!-- left column -->
<div class="col-md-12">
<!-- general form elements -->
<div class="card card-primary">
<div class="card-header">
<h3 class="card-title">Add Product</h3>
</div>
<!-- /.card-header -->
<!-- form start -->
<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>
<!-- /.card-body -->
<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>
<!-- /.card -->
</div>
<!--/.col (left) -->
</div>
<!-- /.row -->
</div><!-- /.container-fluid -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<?php include("include/footer.php");?>
</div>
<!-- ./wrapper -->
<!-- jQuery -->
<script src="plugins/jquery/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- bs-custom-file-input -->
<script src="plugins/bs-custom-file-input/bs-custom-file-input.min.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<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>