addproduct_action.php

<?php
session_start();
if(isset($_SESSION['alogin'])){
	$mail=$_SESSION['alogin'];
?>



<?php
$con=mysqli_connect("localhost","root","","organic_shop_db")or die ("Couldnt connect");

$disp="SELECT  *from tbl_product ORDER BY name ASC";

$disp_result=mysqli_query($con,$disp);
$prodname="";

?>

<?php

if(isset($_POST["submit2"]))
{
$cat=$_POST["cat"];	
$name=$_POST["name"];
$price=$_POST["price"];
$des=$_POST["des"];
$qunty=$_POST["qunty"];
$image=$_POST["image"];
$Status=0;
$flag=0;
$prodc="";

$user="Select rid from tbl_registration WHERE email='$mail'";

$userid=mysqli_query($con,$user);
$rid_row=mysqli_fetch_array($userid);
$checknamep="Select * from tbl_product WHERE name='$name'";
$disp_presult=mysqli_query($con,$checknamep);
while($row=mysqli_fetch_array($disp_presult))
{
$prodc=$row['name'];


if((strcmp($prodc,$name) == 0))
  	{	
		$flag=$flag+1;
		echo "<script type='text/javascript'>alert('The category is already Existing'); 
		
		window.location='product.php';</script>";
		
		break;
	}
}



	
if($flag==0)

{	
	$rid=$rid_row['rid'];

	
	
	$q_ins1="insert into tbl_product(rid,product_category_id,name,price,des,qunty,image,picStatus) values ('$rid','$cat','$name','$price','$des',$qunty,'$image','$Status')";

	
	
	$ins=mysqli_query($con,$q_ins1);
		
if($ins==TRUE)
{
	
		echo "<script type='text/javascript'>
				
				alert('New category added successfully'); 
				window.location='product.php';
				</script>";
}
else
{
	
	echo "<script type='text/javascript'>
				
				alert('Not added'); 
				window.location='product.php';				
				</script>";
}

}
else
{
	echo "<script type='text/javascript'>
				
				alert('The category is already added '); 
				window.location='product.php';				
				</script>";
}

}

?>

<?php
}
else
{
	header('Location:login.php');
}
?>