Inside Admin_area folder ,Make one page - insert_product.php and make folder includes then store page - db.php
<!Doctype HTML>
<head><script src="//cdn.tinymce.com/4/tinymce.min.js"></script>
<script>tinymce.init({ selector:'textarea' });</script></head>
<body bgcolor="#999999">
<?php include("includes/db.php");?>
<form method="post" action="insert_product.php" enctype="multipart/form-data">
<table width="700" align="center" border="1" bgcolor="#3399CC">
<tr align="center"><td colspan="2"><h1>Insert New Product:</h1></td></tr>
<tr><td><td align="right"><b>Product Title</b></td><input type="text" name="product_title" size="50"/></td></tr>
<tr><td><td align="right"><b>Product Category</b></td>
<select name="product_cart">
<option>Select a category</option><?php
$get_cats="select * from categories";
$run_cats=mysqli_query($con,$get_cats);
while($row_cats=mysqli_fetch_array($run_cats)){
$cat_id=$row_cats['cat_id'];
$cat_title=$row_cats['cat_title'];
echo"<option value='$cat_id'>$cat_title</option>";
} ?></td></tr>
<tr><td><td><b>Product Brand</b></td><select name="product_brand"><option>Select Brand</option><?php
$get_brands="select * from brands";
$run_brands=mysqli_query($con,$get_brands);
while($row_brands=mysqli_fetch_array($run_brands)){
$brand_id=$row_brands['brand_id'];
$brand_title=$row_brands['brand_title'];
echo"<option value='$brand_id'>$brand_title</option>";
} ?>
</td></tr>
<tr><td><td align="right"><b>Product Image1</b></td><input type="file" name="product_img1"/></td></tr>
<tr><td><td align="right"><b>Product Image2</b></td><input type="file" name="product_img2"/></td></tr>
<tr><td><td align="right"><b>Product Image3</b></td><input type="file" name="product_img3"/></td></tr>
<tr><td><td align="right"><b>Product Description</b></td><textarea name="product_desc" cols="35" rows="10"/></textarea></td></tr>
<tr><td><td align="right"><b>Product Keywords</b></td><input type="text" name="product_keywords"size="50"/></td></tr>
<tr><td><td align="right"><b>Product Price</b></td><input type="text" name="product_price"/></td></tr>
<tr align="center"><td colspan="2"><input type="submit" name="insert_product" value="insert product"/></td></tr>
</table>
</form>
</body>
</html>
<?php
if(isset($_POST['insert_product'])){
//text data variables
$product_title=$_POST['product_title'];
$product_cat=$_POST['product_cat'];
$product_brand=$_POST['product_brand'];
$product_price=$_POST['product_price'];
$product_desc=$_POST['product_desc'];
$status='on';
$product_keywords=$_POST['product_keywords'];
//image names
$product_img1=$_FILES['product_img1']['name'];
$product_img2=$_FILES['product_img2']['name'];
$product_img3=$_FILES['product_img3']['name'];
//Image Temp names
$temp_name1=$_FILES['product_img1']['tmp_name'];
$temp_name2=$_FILES['product_img2']['tmp_name'];
$temp_name3=$_FILES['product_img3']['tmp_name'];
if($product_title=='' OR $product_cat=='' OR $product_brand=='' OR $product_desc=='' OR $product_keywords OR $product_img1){
echo"<script>alert('please fill all the fields')</script>";
exit();
}
else{
//uploading images to its folder
move_uploaded_file($temp_name1,"product_images/$product_img1");
move_uploaded_file($temp_name2,"product_images/$product_img2");
move_uploaded_file($temp_name3,"product_images/$product_img3");
$insert_product="insert into products (cat_id,brand_id,date,product_title,product_img1,product_img2,product_img3,product_price,product_desc,product_status) values('$product_cat','$product_brand',NOW(),'$product_title','$product_img1','$product_img2','$product_img3','$product_price','$product_desc','$status')";
$run_product=mysqli_query($con,$insert_product);
if($run_product){
echo"<script>('Product Inserted Successfully')</script>";
}
}
}
?>
<!Doctype HTML>
<head><script src="//cdn.tinymce.com/4/tinymce.min.js"></script>
<script>tinymce.init({ selector:'textarea' });</script></head>
<body bgcolor="#999999">
<?php include("includes/db.php");?>
<form method="post" action="insert_product.php" enctype="multipart/form-data">
<table width="700" align="center" border="1" bgcolor="#3399CC">
<tr align="center"><td colspan="2"><h1>Insert New Product:</h1></td></tr>
<tr><td><td align="right"><b>Product Title</b></td><input type="text" name="product_title" size="50"/></td></tr>
<tr><td><td align="right"><b>Product Category</b></td>
<select name="product_cart">
<option>Select a category</option><?php
$get_cats="select * from categories";
$run_cats=mysqli_query($con,$get_cats);
while($row_cats=mysqli_fetch_array($run_cats)){
$cat_id=$row_cats['cat_id'];
$cat_title=$row_cats['cat_title'];
echo"<option value='$cat_id'>$cat_title</option>";
} ?></td></tr>
<tr><td><td><b>Product Brand</b></td><select name="product_brand"><option>Select Brand</option><?php
$get_brands="select * from brands";
$run_brands=mysqli_query($con,$get_brands);
while($row_brands=mysqli_fetch_array($run_brands)){
$brand_id=$row_brands['brand_id'];
$brand_title=$row_brands['brand_title'];
echo"<option value='$brand_id'>$brand_title</option>";
} ?>
</td></tr>
<tr><td><td align="right"><b>Product Image1</b></td><input type="file" name="product_img1"/></td></tr>
<tr><td><td align="right"><b>Product Image2</b></td><input type="file" name="product_img2"/></td></tr>
<tr><td><td align="right"><b>Product Image3</b></td><input type="file" name="product_img3"/></td></tr>
<tr><td><td align="right"><b>Product Description</b></td><textarea name="product_desc" cols="35" rows="10"/></textarea></td></tr>
<tr><td><td align="right"><b>Product Keywords</b></td><input type="text" name="product_keywords"size="50"/></td></tr>
<tr><td><td align="right"><b>Product Price</b></td><input type="text" name="product_price"/></td></tr>
<tr align="center"><td colspan="2"><input type="submit" name="insert_product" value="insert product"/></td></tr>
</table>
</form>
</body>
</html>
<?php
if(isset($_POST['insert_product'])){
//text data variables
$product_title=$_POST['product_title'];
$product_cat=$_POST['product_cat'];
$product_brand=$_POST['product_brand'];
$product_price=$_POST['product_price'];
$product_desc=$_POST['product_desc'];
$status='on';
$product_keywords=$_POST['product_keywords'];
//image names
$product_img1=$_FILES['product_img1']['name'];
$product_img2=$_FILES['product_img2']['name'];
$product_img3=$_FILES['product_img3']['name'];
//Image Temp names
$temp_name1=$_FILES['product_img1']['tmp_name'];
$temp_name2=$_FILES['product_img2']['tmp_name'];
$temp_name3=$_FILES['product_img3']['tmp_name'];
if($product_title=='' OR $product_cat=='' OR $product_brand=='' OR $product_desc=='' OR $product_keywords OR $product_img1){
echo"<script>alert('please fill all the fields')</script>";
exit();
}
else{
//uploading images to its folder
move_uploaded_file($temp_name1,"product_images/$product_img1");
move_uploaded_file($temp_name2,"product_images/$product_img2");
move_uploaded_file($temp_name3,"product_images/$product_img3");
$insert_product="insert into products (cat_id,brand_id,date,product_title,product_img1,product_img2,product_img3,product_price,product_desc,product_status) values('$product_cat','$product_brand',NOW(),'$product_title','$product_img1','$product_img2','$product_img3','$product_price','$product_desc','$status')";
$run_product=mysqli_query($con,$insert_product);
if($run_product){
echo"<script>('Product Inserted Successfully')</script>";
}
}
}
?>