
20141021 orders_detail_ins.php
<?php require_once('../../../Connections/allianz.php'); ?>
<?php
/*
點產品編號 帶p_id 查詢 orders_detail01的 產品編號,數量 products01 ,規格,單價 點數量坐新增
查詢 orders_detail01 o_id, p_id, p_cnts
主訂單編號,產品編號,數量
查詢 products01 p_id p_name p_spec p_prices
產品編號, 產品名稱,規格,單價
*/
$varp_id = ""; if (isset($_REQUEST["p_id"]) ){ $varp_id =$_REQUEST["p_id"];}
//echo " c_id = " . $varc_id . "<br>";
$varo_id = ""; if (isset($_REQUEST["o_id"]) ){ $varo_id =$_REQUEST["o_id"];}
$varp_cnts="";if (isset($_POST["p_cnts"]) ){ $varp_cnts =$_POST["p_cnts"];}
$varMM_form = ""; if (isset($_POST["mm_form"]) ){ $varMM_form =$_POST["mm_form"];}
//echo "mm_form=" .$varMM_form ."<br>";
if( $varMM_form == "form1"){
// 新增至主訂單 orders01
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$ins = " insert into orders_detail01 ( ";
//$ins.= " p_cnts, ";
$ins.= " o_id, p_id, p_cnts, ";
$ins = substr($ins, 0 , strlen($ins) -2);
$ins.= " )value(";
$ins.= " ".$varo_id.", ";
$ins.= " ".$varp_id.", ";
$ins.= " ".$varp_cnts.", ";
$ins = substr($ins, 0 , strlen($ins) -2);
$ins.= " )";
//echo "ins =". $ins . "<br>";
//exit();
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$Result1 = mysql_query($ins, $allianz) or die(mysql_error()); // 執行新增或修改或刪除的SQL語法
//exit();
header(sprintf("Location: %s", "orders_detail_qry.php?o_id=" . $varo_id ));
}