<?php
include 'db.php';
$return['message'] = '';
$category =  $_POST['category'];
$sub_category =  $_POST['sub_category'];
$product_name = str_replace("'", "\'",  $_POST['product_name']);
$product_description = str_replace("'", "\'",  $_POST['product_description']);

$product_remark =  $_POST['product_remark'];

$product_image_1 = $_POST['product_image_1'];
$product_image_2 = $_POST['product_image_2'];
$product_image_3 = $_POST['product_image_3'];
$product_image_4 = $_POST['product_image_4'];
$product_image_5 = $_POST['product_image_5'];
$featured = $_POST['featured'];
date_default_timezone_set("Asia/Calcutta");
$datetime   = new DateTime();
$created_at = date('Y-m-d G:i:s');
$sql = "insert into products
(product_id,
category_id,
sub_category_id,
product_type,
product_name,
product_image_1,
product_image_2,
product_image_3,
product_image_4,
product_image_5,
product_description,
product_remark,
featured_product,
product_status,
created_at)
values
('',
'$category',
'$sub_category',
'Attribute_product',
'" . $product_name . "',
'" . $product_image_1 . "',
'" . $product_image_2 . "',
'" . $product_image_3 . "',
'" . $product_image_4 . "',
'" . $product_image_5 . "',
'" . $product_description . "',
'" . $product_remark . "',
'".$featured."',
'Active',
'$created_at')";
if (mysqli_query($link, $sql)) {
    $insert_id = $link->insert_id;
    $return['message'] = 'product inserted successfully';
    $return['error_flag'] = 0;
    $return['product_id'] = $insert_id;
} else {
    $return['message'] = 'There is an error inserting the product';
    $return['error_flag'] = 1;
    $return['error_message'] = $link->error;
}
  echo json_encode($return);