ab1628 發表在 痞客邦 留言(0) 人氣()
ab1628 發表在 痞客邦 留言(0) 人氣()
orders_detail_upd.php
<?php require_once('../../../Connections/allianz.php'); ?>
<?php
$varod_id = ""; if (isset($_REQUEST["od_id"]) ){ $varod_id =$_REQUEST["od_id"];}
$varo_id = ""; if (isset($_REQUEST["o_id"]) ){ $varo_id =$_REQUEST["o_id"];}
$varp_id = ""; if (isset($_REQUEST["p_id"]) ){ $varp_id =$_REQUEST["p_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"){
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$upd = " update orders_detail01 set ";
$upd.= " o_id = " .$varo_id. ", ";
$upd.= " p_id = " .$varp_id. ", ";
$upd.= " p_cnts= ".$varp_cnts.", ";
$upd = substr($upd, 0 , strlen($upd) -2);
$upd.= "where 1=1 ";
$upd.= " and od_id =".$varod_id." ";
echo "upd=". $upd . "<br>";
//exit();
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$Result1 = mysql_query($upd, $allianz) or die(mysql_error()); // 執行新增或修改或刪除的SQL語法
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">
<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">
<style>
.inputbox_size{
width:100%;
}
</style>
<script>
<!--
function idkey(){
var sUrl = "orders_detail_upd.php?";
sUrl += "&p_id=" + $("#p_id").val();
sUrl += "&od_id=" + $("#od_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="" enctype="multipart/form-data">
<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>
<?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
?>
<tr>
<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==strval($i) ){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" name="od_id" id="od_id" value="<?php echo $varod_id;?>">
<input type="hidden" name="o_id" id="o_id" value="<?php echo $varo_id;?>">
<input type="hidden" name="mm_form" value="form1">
</form>
</body>
</html>
ab1628 發表在 痞客邦 留言(0) 人氣()
訂單+訂單明細 (新增)
orders_detail_ins.php
ab1628 發表在 痞客邦 留言(0) 人氣()
orders_detail_qry.php
ab1628 發表在 痞客邦 留言(0) 人氣()
ab1628 發表在 痞客邦 留言(0) 人氣()
訂單(修改)+訂單明細
orders_upd.php
ab1628 發表在 痞客邦 留言(0) 人氣()
ab1628 發表在 痞客邦 留言(0) 人氣()
訂單(查詢)+ 訂單明細
<?php require_once('../../Connections/allianz.php'); ?>
ab1628 發表在 痞客邦 留言(0) 人氣()
20141021 orders_detail_del.php
<?php require_once('../../../Connections/allianz.php'); ?>
ab1628 發表在 痞客邦 留言(0) 人氣()
