訂單+訂單明細 (新增)
orders_detail_ins.php
<?php require_once('../../../Connections/allianz.php'); ?>
<?php /* o_id 沒抓到 */
$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"]; }
//echo " o_id = " .$varo_id . "<br>";
$varp_cnts="";if (isset($_POST["p_cnts"]) ){ $varp_cnts =$_POST["p_cnts"]; }
//echo " cnts = " . $varp_cnts . "<br>";
$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.= " 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 ."" ));
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script src="../../../js/jquery-ui-1.11.1.custom/jquery.js"></script>
<script src="../../../js/jquery-ui-1.11.1.custom/jquery-ui.js"></script>
<link rel="stylesheet" href="../../../js/jquery-ui-1.11.1.custom/jquery-ui.structure.css">
<link rel="stylesheet" href="../../../js/jquery-ui-1.11.1.custom/jquery-ui.theme.css">
<script>
<!--
function idkey(){
var sUrl = "orders_detail_ins.php?";
sUrl += "&p_id=" + $("#p_id").val();
sUrl += "&o_id=" + $("#o_id").val();
alert( sUrl );
location.href = sUrl;
}
-->
</script>
</head>
<body>
<div id="dialog" title="基本訊息"></div>
<form method="post" name="form1" id="form1" action="">
<table border="1">
<tr>
<td colspan="11">新增表</td>
</tr>
<tr>
<td>產品名稱</td>
<td>
<?php
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql = " select * from products01 where 1=1 "; // 準備要查詢的SQL指令
//echo "sql = " .$sql . "<br>";
$Recordset = mysql_query($sql, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset = mysql_fetch_assoc($Recordset); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset = mysql_num_rows($Recordset); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1
?>
<select id="p_id" name="p_id" onchange="idkey()">
<option value="">請選擇</option>
<?php do{ ?>
<option value="<?php echo $row_Recordset["p_id"];?>" <?php if ($varp_id==$row_Recordset["p_id"]){echo "selected";} ?>><?php echo $row_Recordset["p_name"];?></option>
<?php }while( $row_Recordset = mysql_fetch_assoc($Recordset) ); ?>
</select>
</td>
</tr>
<tr>
<?php
if( strlen($varp_id>0) ){
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql2 = " select * from products01 where 1=1 "; // 準備要查詢的SQL指令
$sql2 .= " and p_id = ".$varp_id." ";
//echo "sql2 = " .$sql2 . "<br>";
$Recordset2 = mysql_query($sql2, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset2 = mysql_fetch_assoc($Recordset2); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset2 = mysql_num_rows($Recordset2); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1
?>
<td>數量</td>
<td>
<select id="p_cnts" name="p_cnts" >
<option value="">請選擇</option>
<?php for($i=1;$i<=10;$i++){?>
<option value="<?php echo $i;?>" <?php if ($varp_cnts>0){echo "selected"; }?>><?php echo $i;?>個</option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<td>規格</td>
<td><?php echo $row_Recordset2["p_spec"];?></td>
</tr>
<tr>
<td>單價</td>
<td><?php echo $row_Recordset2["p_prices"];?></td>
</tr>
<?php } ?>
</table>
<input type="submit" value="新增">
<input type="hidden" id="o_id" name="o_id" value="<?php echo $varo_id;?>">
<input type="hidden" name="mm_form" value="form1">
</form>
</body>
</html>
