<?php
require_once('db.php');
$product_name = str_replace("'", "\'",  $_POST['product_name']);
$mrp_price = $_POST['mrp'];
$sale_price = $_POST['sale_price'];
$product_description = str_replace("'", "\'",  $_POST['product_description']);
$product_remark = $_POST['product_remark'];
$category = $_POST['category'];
$subcategory = $_POST['subcategory'];

$featured = $_POST['featured'];
$status = $_POST['status'];
$img1 = $_POST['img1'];
$img2 = $_POST['img2'];
$img3 = $_POST['img3'];
$img4 = $_POST['img4'];
$img5 = $_POST['img5'];
$return['message'] = '';

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',
'$subcategory',
'Simple',
'" . $product_name . "',
'" . $img1 . "',
'" . $img2 . "',
'" . $img3 . "',
'" . $img4 . "',
'" . $img5 . "',
'" . $product_description . "',
'" . $product_remark . "',
'".$featured."',
'".$status."',
'$created_at')";

if (mysqli_query($link, $sql)) {
    $pid = $link->insert_id;

    $sql3 = "INSERT INTO product_attributes(attribute_id,product_id,size_id,color_id,MRP_price,sale_price,created_at)
    VALUES('', '$pid',0,0,'" . $mrp_price . "','" . $sale_price . "','$created_at')";
    if (mysqli_query($link, $sql3)) {
        $return['message'] = 'prouduct inserted successfully';
        $return['error_flag'] = 0;
    } else {
        $return['message'] = 'Error inserting attribute';
        $return['error_flag'] = 1;
        $return['error'] = $link->error;
    }
} else {
    $return['message'] = 'Error inserting initial product';
    $return['error_flag'] = 1;
    $return['error'] = $link->error;
}
echo json_encode($return);
$link->close();
?>