if(isset($_POST["update_invoice"]))
{
$order_item_hc = 0;
$order_id = $_POST["order_id"];
for($count=0; $count<$_POST["total_item"]; $count++)
{
$statement = $connect->prepare("
update tbl_order_item
SET
order_item_hsncode = :order_item_hsncode,
order_item_name = :order_item_name,
order_item_quantity = :order_item_quantity,
order_item_price = :order_item_price,
order_item_actual_amount = :order_item_actual_amount
WHERE order_id = :order_id
");
$statement->execute(
array(
':order_id' => $order_id,
':order_item_hsncode' => trim($_POST["order_item_hsncode"][$count]),
':order_item_name' => trim($_POST["order_item_name"][$count]),
':order_item_quantity' => trim($_POST["order_item_quantity"][$count]),
':order_item_price' => trim($_POST["order_item_price"][$count]),
':order_item_actual_amount' => trim($_POST["order_item_actual_amount"][$count])
)
);
}