<?php
include 'db.php';
 $user_id = $_POST['user_id'];
$product_id = $_POST['product_id'];
$attribute_id = $_POST['attribute_id'];
$qty = $_POST['qty'];
$order_subtotal = $_POST['order_subtotal'];

$order_total_billing_amount = $_POST['order_total_billing_amount'];

$first_name = $_POST['first_name'];

$last_name = $_POST['last_name'];

$full_address = $_POST['full_address'];

$city = $_POST['city'];
$state = $_POST['state'];
$pincode = $_POST['pincode'];
$contactno = $_POST['contactno'];

$email_id = $_POST['email_id'];
 
date_default_timezone_set("Asia/Calcutta");
$datetime   = new DateTime();
$order_date = date('Y-m-d G:i:s');
 
 

    $sql3="INSERT INTO orders(
        order_id,
        user_id,
        product_id,
        attribute_id,
        order_date,
        qty,
        order_subtotal,
        order_total_billing_amount,
        payment_method,
        first_name,
        last_name,
        full_address,
        city,
        state,
        pincode,
        contactno,
        email_id,
        order_status)
    VALUES('','$user_id','$product_id','$attribute_id','$order_date',
    '".$qty."',
    '".$order_subtotal."',
    '".$order_total_billing_amount."',
    'COD',
    '".$first_name."',
    '".$last_name."',
    '".$full_address."',
    '".$city."',
    '".$state."',
    '".$pincode."',
    '".$contactno."',
    '".$email_id."',
    'Confirmed'
    )";

    if(mysqli_query($link,$sql3)) {
  
    $return["error_flag"] = 0;
    $return["message"] = "Inserted Successfully";
  
    }
 else {
    $return["error_flag"] = 1;
    $return["message"] = "Error !" . $link->error;

}

 


echo json_encode($return);
$link->close();