<?php
include_once("session.php");
include_once("settings.php");
foreach ($_REQUEST as $key => $value)
{
        $$key = $value;
}

  $Species_Id=addslashes($_POST['Species_Id']);
  $Category_Id=addslashes($_POST['Category_Id']);
  $product_id=addslashes($_POST['product_id']);
  $nutritional_information_approx_value = addslashes($_POST['nutritional_information_approx_value']);
  $nutritional_information_name=$_POST['nutritional_information_key'];

  $nutritional_information_value=$_POST['nutritional_information_value'];
  
if($_REQUEST['mode']=="Edit")
{	

    if($nutritional_information_name && $nutritional_information_value)
	{
	   $nutritional_information_name_arr = array();
	   foreach($nutritional_information_name as $key=>$val)
	   {
		   $nutritional_information_name_arr[] = array(
										$val =>$nutritional_information_value[$key]                          
										);
	   }
	   
	   $nutritional_information = json_encode($nutritional_information_name_arr);

	   if($nutritional_information)
	   {
		   $nutritional_information_details = $nutritional_information;
	   }else{
		   $nutritional_information_details = "";
	   }
	} 

	$sql="UPDATE `tblNutritionalInformation` SET  `Species_Id`='$Species_Id',`Category_Id`='$Category_Id',
              `Product_Id`='$product_id',`nutritional_information_approx_value`='$nutritional_information_approx_value',`nutritional_information`='$nutritional_information_details'               WHERE `id`='".$_POST['id']."'";
   mysql_query($sql);
		
}
else
{
	if($nutritional_information_name && $nutritional_information_value)
	{
	   $nutritional_information_name_arr = array();
	   foreach($nutritional_information_name as $key=>$val)
	   {
		   $nutritional_information_name_arr[] = array(
										$val =>$nutritional_information_value[$key]                          
										);
	   }
	   
	   $nutritional_information = json_encode($nutritional_information_name_arr);
	   
	   if($nutritional_information)
	   {
		   $nutritional_information_details = $nutritional_information;
	   }else{
		   $nutritional_information_details = "";
	   }
	   
	} 
	   
	mysql_query("INSERT INTO `tblNutritionalInformation` (`id`,`Species_Id`,`Category_Id`,`Product_Id`,`nutritional_information_approx_value`,`nutritional_information`) 
	            values 
			   ('','$Species_Id','$Category_Id','$product_id','$nutritional_information_approx_value','$nutritional_information_details')");
}
?>
<script>
document.location="productsNutritionalInformationList.php?page=productsNutritionalInformation";
</script>