<?php  
include("connection.php");


if($_FILES["image"]["name"]==""){
      $im_empty = 'yes';  
    }else{
        $im_empty = 'no';
        
$target_path2 = "uploads/";  
$target_path2 = $target_path2.basename( $_FILES['image']['name']);   


$path_img2 = $base.'/admin/dist/include/uploads/';


  
if(move_uploaded_file($_FILES['image']['tmp_name'], $target_path2)) {  
    $path_img2 = $_FILES['image']['name']; 
} else{  
    echo "Sorry, file not uploaded, please try again!";  
} 
    }


$name = $_POST['name'];
$category = $_POST['category'];
$compo = $_POST['compo'];
$pack = $_POST['pack'];
$price = $_POST['price'];
$desc = $_POST['desc'];


if($category=='a'){
    $category = $_POST['cat'];
}

$idf = $_POST['idf'];


if($idf=='insert'){
    $query = "insert into products(`name`,`category`,`image`,`composition`,`packing`,`price`,`description`) VALUES ('".$name."','".$category."','".$path_img2."','".$compo."','".$pack."','".$price."','".$desc."')";
            $s = mysqli_query($con,$query);
            $a='Added';
}else{
    $uid = $_POST['id'];
    
    if($im_empty == 'no'){
        $s=mysqli_query($con,"UPDATE `products` SET `name`= '".$name."',`category`= '".$category."',`image`= '".$path_img2."',`composition`= '".$compo."',`packing`= '".$pack."',`price`= '".$price."',`description`= '".$desc."' WHERE `id` = '".$uid."'");
    }else{
        $s=mysqli_query($con,"UPDATE `products` SET `name`= '".$name."',`category`= '".$category."',`composition`= '".$compo."',`packing`= '".$pack."',`price`= '".$price."',`description`= '".$desc."' WHERE `id` = '".$uid."'");
    }
    
    
    $a='Updated';
}



            
            if($s){
                echo "<script>
alert('Product $a.');
window.location.href='$base/admin/dist/products.php';
</script>";
            }else
            {
                echo "<script>
alert('Error.');
window.location.href='$base/admin/dist/products.php';
</script>";
            }


?>