<?php
require_once 'db.php';

if (isset($_POST['product_name'], $_POST['image'], $_POST['packing'], $_POST['general_description'], $_POST['application_usage'], $_POST['market'], $_POST['application'])) {

    $product_name = mysqli_real_escape_string($link, $_POST['product_name']);
    $image = mysqli_real_escape_string($link, $_POST['image']);  // Image filename from the upload
    $packing = mysqli_real_escape_string($link, $_POST['packing']);
    $general_description = mysqli_real_escape_string($link, $_POST['general_description']);
    $application_usage = mysqli_real_escape_string($link, $_POST['application_usage']);
    $market = mysqli_real_escape_string($link, $_POST['market']);
    $application = mysqli_real_escape_string($link, $_POST['application']);
    $related_products = isset($_POST['related_products']) ? implode(',', $_POST['related_products']) : '';

    date_default_timezone_set("Asia/Calcutta");
    $datetime = new DateTime();
    $last_updated = date('Y-m-d G:i:s');

    // Insert into the database
    $sql = "INSERT INTO products (product_name, brochures, packing, general_description, application_usage, market, application, related_products, last_updated)
            VALUES ('$product_name', '$image', '$packing', '$general_description', '$application_usage', '$market', '$application', '$related_products', '$last_updated')";

    if (mysqli_query($link, $sql)) {
        echo json_encode(['error_flag' => 0, 'message' => 'Product Added Successfully!']);
    } else {
        echo json_encode(['error_flag' => 1, 'message' => 'Failed to add Product details: ' . mysqli_error($link)]);
    }
} else {
    echo json_encode(['error_flag' => 1, 'message' => 'Missing required parameters']);
}
?>