bnmbertsu,yu,yu,yu,uy,ltdfg

<?php
session_start();
include('../Mplusedata&base/config.php');
if(strlen($_SESSION['alogin'])==0)
	{	
header('location:index.php');
}
else{
	
if(isset($_POST['submit']))
{

$category=$_POST['category'];
	$subcat=$_POST['subcategory'];
	$productname=$_POST['productName'];
	$productNamee=$_POST['productNamee']; 
$sku=$_POST['sku'];	
	$productcompany=$_POST['productCompany'];
	$productCompanye=$_POST['productCompanye'];

$productprice=$_POST['productprice'];
	$productpricebd=$_POST['productpricebd'];
	$productdescription=$_POST['productDescription'];
$productDescriptione=$_POST['productDescriptione'];	
$shore_desc=$_POST['shore_desc'];
	$shore_desc_e=$_POST['shore_desc_e'];
$productimage1=$_FILES["productimage1"]["name"];
	$productimage2=$_FILES["productimage2"]["name"];
	$productimage3=$_FILES["productimage3"]["name"];
	$productimage4=$_FILES["productimage4"]["name"];
	$productimage5=$_FILES["productimage5"]["name"];
	$productimage6=$_FILES["productimage6"]["name"];
//for getting product id
$query=mysqli_query($con,"select max(id) as pid from products");
	$result=mysqli_fetch_array($query);
	$productid=$result['pid']+1;
	$dir="productimages/$productid";
	mkdir($dir);// directory creation for product images
	move_uploaded_file($_FILES["productimage1"]["tmp_name"],"productimages/$productid/".$_FILES["productimage1"]["name"]);
	move_uploaded_file($_FILES["productimage2"]["tmp_name"],"productimages/$productid/".$_FILES["productimage2"]["name"]);
	move_uploaded_file($_FILES["productimage3"]["tmp_name"],"productimages/$productid/".$_FILES["productimage3"]["name"]);
	move_uploaded_file($_FILES["productimage4"]["tmp_name"],"productimages/$productid/".$_FILES["productimage4"]["name"]);
	move_uploaded_file($_FILES["productimage5"]["tmp_name"],"productimages/$productid/".$_FILES["productimage5"]["name"]);
	move_uploaded_file($_FILES["productimage6"]["tmp_name"],"productimages/$productid/".$_FILES["productimage6"]["name"]);
//$productscharge=$_POST['productShippingcharge'];
	$productavailability='In Stock';//$_POST['productAvailability'];
	$vedio=$_POST['vedio'];
	$offer=$_POST['offer'];
	$campaign=$_POST['campaign'];

$sql=mysqli_query($con,"insert into products
	(category,subCategory,productName,productNamee,sku,productCompany,productCompanye,productPrice,productPriceBeforeDiscount,productDescription,
productDescriptione,productImage1,productImage2,productImage3,productImage4,productImage5,productImage6,productavailability,vedio,offer,campaign) 
values('$category','$subcat','$productname','$productNamee','$sku','$productcompany','$productCompanye','$productprice','$productpricebd','$productdescription',
'$productDescriptione','$productimage1','$productimage2','$productimage3','$productimage4','$productimage5','$productimage6','$productavailability','$vedio','$offer','$campaign'
,shore_desc='$shore_desc',shore_desc_e='$shore_desc_e')");
$_SESSION['msg']="Product Inserted Successfully !!";

}
/*,
',   */

<!DOCTYPE html>
<html lang="en">
	<head>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<head>
<script type="text/javascript" language="JavaScript1.2" src="../stmenu.js"></script>
<script src="https://cdn.ckeditor.com/ckeditor5/11.0.1/classic/ckeditor.js"></script>

<body class="no-skin">
		<?php include("topheader.php");?>
		<div class="main-container ace-save-state" id="main-container">
			<script type="text/javascript">
				try{ace.settings.loadState('main-container')}catch(e){}
			</script>
			<?php include("leftheader.php");?>
	
			<div class="main-content">
				<div class="main-content-inner">
			<div class="page-content">
			
					     <div class="row">
							<div class="col-xs-12">
								
								<div class="hr hr-18 dotted hr-double"></div>
								<div class="row">
									<div class="col-xs-12">
									<div class="module-head">
								<h3><span class="widget-toolbar">
											<?php if(isset($_POST['submit']))
{?>
									<div class="alert alert-success">
										<button type="button" class="close" data-dismiss="alert">�</button>
									<strong>Well done!</strong>	<?php echo htmlentities($_SESSION['msg']);?><?php echo htmlentities($_SESSION['msg']="");?>
									</div>
<?php } ?>

<?php if(isset($_GET['del']))
{?>
									<div class="alert alert-error">
										<button type="button" class="close" data-dismiss="alert">�</button>
									<strong>Oh snap!</strong> 	<?php echo htmlentities($_SESSION['delmsg']);?><?php echo htmlentities($_SESSION['delmsg']="");?>
									</div>
<?php } ?>
													</span></h3>
							</div>

<div class="row">
							<div class="col-xs">
										<div class="col-xs-12 ">
											<div class="widget-box">
											<div class="table-header">
											Insert Product
										</div>
										
											
		
												<div class="widget-body">
												
													<div class="widget-main">
	<form class="form-horizontal row-fluid" name="insertproduct" method="post" style="padding:30px;font-size:18px;line-height:35px" enctype="multipart/form-data">
														<div>
								<label for="form-field-select-1">Category</label>
<select name="category" class="form-control" id="form-field-select-1"  onChange="getSubcat(this.value);"  required>
<option value="">Select Category</option> 
<?php $query=mysqli_query($con,"select * from category");
while($row=mysqli_fetch_array($query))
{?>

<option value="<?php echo $row['id'];?>"><?php echo $row['categoryName'];?> / <?php echo $row['categoryDescription'];?></option>
<?php } ?>
</select>										
														</div>
														<div>
														 <script>
function getSubcat(val) {
	$.ajax({
	type: "POST",
	url: "get_subcat.php",
	data:'cat_id='+val,
	success: function(data){
		$("#subcategory").html(data);
	}
	});
}
function selectCountry(val) {
$("#search-box").val(val);
$("#suggesstion-box").hide();
}
</script>
	<label for="form-field-select-1">Sub Category</label>
<select   name="subcategory"  id="subcategory" class="form-control"  required>
</select>										
														</div>
														
														
				<div>
															<label for="form-field-select-1">
															Product Name (arabic)
															</label>
<input type="text"    name="productName"  placeholder="Enter Product Name" class="form-control" required>

</div>
			<div>
															<label for="form-field-select-1">
															Product Name (Englsih)
															</label>
<input type="text"    name="productNamee"  placeholder="Enter Product Name" class="form-control" required>

</div>
				<div>
															<label for="form-field-select-1">
															Width (CM)
															</label>
<input type="text"    name="sku"  placeholder="Enter Product Name" class="form-control" value="0" >

</div>

<div>
															<label for="form-field-select-1">
Length (CM)</label>

<div>
															<label for="form-field-select-1">
Product Price <mark>Before Discount</mark>
</label>

<input type="text"    name="productpricebd"  placeholder="Enter Product Price" class="form-control" required>
</div>
<div>
															<label for="form-field-select-1">
Product Price <mark>After Discount(Selling Price)</mark>

</label>

<input type="text"    name="productprice"  placeholder="Enter Product Price" class="form-control" value="0" required>
</div>
<div>
															<label for="form-field-select-1">
Brief desc (arabic)
</label>

</div>
 <div>
															<label for="form-field-select-1">
Brief desc (�Engklish)
</label>

</div>
<div>
															<label for="form-field-select-1">
Product Description(����)
</label>

<textarea  id="editor2" name="productDescription"  placeholder="Enter Product Description" rows="6" class="form-control">
</textarea>  
 </div>
 
 <div>
															<label for="form-field-select-1">
Product Description(Englsih)
</label>

<div>
															<label for="form-field-select-1">
Product Availability</label>

<select   name="productAvailability"  id="productAvailability" class="form-control" required>
<option value="">Select</option>
<option value="In Stock" selected>In Stock</option>
<option value="Out of Stock">Out of Stock</option>
</select>
</div>

<div>
															<label for="form-field-select-1">
 Add offer</label>

<select   name="offer"  id="offer" class="form-control" required>
<option value="">Select</option>
<option value="yes">Yes</option>
<option value="no" selected>No</option>
</select>
</div>
<div>
															<label for="form-field-select-1">
 New Collection</label>

<select   name="campaign"  id="campaign" class="form-control" required>
<option value="">Select</option>
<option value="yes">Yes</option>
<option value="no" selected >No</option>
</select>
</div>

<div>
<label for="form-field-select-1">
Vedio Link</label>

</div>
<div>
<label for="form-field-select-1">
Product Image1
</label>
<input type="file" name="productimage1" id="productimage1" value="" class="form-control" >

</div>
<div>
<label for="form-field-select-1">
															Product Image2
</label>
<input type="file" name="productimage2"  class="form-control" >

</div>
<div>
<label for="form-field-select-1">

Product Image3
</label>
<input type="file" name="productimage3"  class="form-control" >
<label for="form-field-select-1">

Product Image4
</label>
<input type="file" name="productimage4"  class="form-control" >
<label for="form-field-select-1">

Product Image5
</label>
<input type="file" name="productimage5"  class="form-control" >
<label for="form-field-select-1">

Product Image6
</label>
<input type="file" name="productimage6"  class="form-control" >
</div>

</div>
												</div>
											</div>
												<div class="clearfix form-actions">
										<div class="col-md-offset col-md-12">
											<button type="submit" name="submit" class="btn form-control">Insert</button>
											
									</form>

</div>
									</div>
										</div>
									</div>

</div>