• PHP Help

  • Notice: Undefined offset: 0 in line ':order_item_tax1_rate' =>

$order_item_tax1_rate = 0;
$order_item_tax1_amount = 0;
$order_item_tax2_rate = 0;
$order_item_tax2_amount = 0;
$order_item_hc = 0;
$order_item_final_amount = 0;

$statement = $connect->prepare("
  INSERT INTO tbl_order 
    (order_no, order_date, order_receiver_name, order_receiver_gstin, order_item_tax1_rate, order_item_tax1_amount, order_item_tax2_rate, order_item_tax2_amount, order_item_hc_,  order_item_final_amount, order_datetime)
    VALUES (:order_no, :order_date, :order_receiver_name, :order_receiver_gstin, :order_item_tax1_rate, :order_item_tax1_amount, :order_item_tax2_rate, :order_item_tax2_amount, :order_item_hc, order_item_final_amount,  :order_datetime)
");
$statement->execute(
  array(
      ':order_no'               =>  trim($_POST["order_no"]),
      ':order_date'             =>  trim($_POST["order_date"]),
      ':order_receiver_name'          =>  trim($_POST["order_receiver_name"]),
      ':order_receiver_gstin'       =>  trim($_POST["order_receiver_gstin"]),
      ':order_item_tax1_rate'           =>  trim($_POST["$order_item_tax1_rate"]),
      ':order_item_tax1_amount'           =>  trim($_POST["$order_item_tax1_amount"]),
      ':order_item_tax2_rate'           =>  trim($_POST["$order_item_tax2_rate"]),
	  ':order_item_tax2_amount'           =>  trim($_POST["$order_item_tax2_amount"]),
      ':order_item_hc'           =>  trim($_POST["$order_item_hc"]),
	  ':order_item_final_amount'		=> trim($_POST["$order_item_final_amount"]),
      ':order_datetime'           =>  date("Y-m-d")
  )

    Well, why did you write $_POST["$order_item_tax1_rate"] instead of say, $_POST["order_item_tax1_rate"]?

    Write a Reply...