晚上11:25
禹傑
<?php require_once('../../Connections/allianz.php'); ?>
<?php
$varc_id = ""; if (isset($_REQUEST["c_id"]) ){ $varc_id =$_REQUEST["c_id"];}
//echo " c_id = " . $varc_id . "<br>";
$varo_id = ""; if (isset($_REQUEST["o_id"]) ){ $varc_num =$_REQUEST["o_id"];}
$varMM_form = ""; if (isset($_POST["mm_form"]) ){ $varMM_form =$_POST["mm_form"];}
//echo "mm_form=" .$varMM_form ."<br>";
if( $varMM_form == "form1"){
// 新增至主訂單 orders01
$varc_addr = ""; if (isset($_POST["c_addr"]) ){ $varc_addr =$_POST["c_addr"];}
//echo " c_addr = " . $varc_addr . "<br>";
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$ins = " insert into orders01 ( ";
$ins.= " c_id, c_addr, ";
$ins = substr($ins, 0 , strlen($ins) -2);
$ins.= " )value(";
$ins.= " ".$varc_id." , ";
$ins.= " '".$varc_addr."' , ";
$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語法
header(sprintf("Location: %s", "orders_qry.php" ));
}
?>
<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">
<style>
.inputbox_size{
width:100%;
}
</style>
<script>
<!--
function idkey(){
var sUrl = "orders_ins.php?";
sUrl += "&c_id=" + $("#c_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); // 連線資料庫
$sql2 = " select * from customers01 where 1=1 "; // 準備要查詢的SQL指令
//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
?>
<select id="c_id" name="c_id" onchange="idkey()">
<option value="">請選擇</option>
<?php do{ ?>
<option value="<?php echo $row_Recordset2["c_id"];?>" <?php if ($varc_id==$row_Recordset2["c_id"]){echo "selected";} ?>><?php echo $row_Recordset2["c_name"];?></option>
<?php }while( $row_Recordset2 = mysql_fetch_assoc($Recordset2) ); ?>
</select>
</td>
</tr>
<?php
if( strlen($varc_id)){
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql3 = " select * from customers01 where 1=1 "; // 準備要查詢的SQL指令
//echo "sql3 = " .$sql3 . "<br>";
$Recordset3 = mysql_query($sql3, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset3 = mysql_fetch_assoc($Recordset3); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset3 = mysql_num_rows($Recordset3); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1
?>
<tr>
<td>外送住址</td>
<td>
<input type="text" name="c_addr" value="">
</td>
</tr>
<tr>
<td>統一編號</td>
<td><?php echo $row_Recordset3["c_num"];?></td>
</tr>
<tr>
<td>客戶住址</td>
<td><?php echo $row_Recordset3["c_addr"];?></td>
</tr>
<tr>
<td>手機</td>
<td><?php echo $row_Recordset3["c_phone"];?></td>
</tr>
<tr>
<td>傳真</td>
<td><?php echo $row_Recordset3["c_fax"];?></td>
</tr>
<?php } ?>
</table>
<input type="submit" value="新增">
<input type="hidden" name="mm_form" value="form1">
</form>
</body>
</html>
<?php
$varc_id = ""; if (isset($_REQUEST["c_id"]) ){ $varc_id =$_REQUEST["c_id"];}
//echo " c_id = " . $varc_id . "<br>";
$varo_id = ""; if (isset($_REQUEST["o_id"]) ){ $varc_num =$_REQUEST["o_id"];}
$varMM_form = ""; if (isset($_POST["mm_form"]) ){ $varMM_form =$_POST["mm_form"];}
//echo "mm_form=" .$varMM_form ."<br>";
if( $varMM_form == "form1"){
// 新增至主訂單 orders01
$varc_addr = ""; if (isset($_POST["c_addr"]) ){ $varc_addr =$_POST["c_addr"];}
//echo " c_addr = " . $varc_addr . "<br>";
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$ins = " insert into orders01 ( ";
$ins.= " c_id, c_addr, ";
$ins = substr($ins, 0 , strlen($ins) -2);
$ins.= " )value(";
$ins.= " ".$varc_id." , ";
$ins.= " '".$varc_addr."' , ";
$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語法
header(sprintf("Location: %s", "orders_qry.php" ));
}
?>
<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">
<style>
.inputbox_size{
width:100%;
}
</style>
<script>
<!--
function idkey(){
var sUrl = "orders_ins.php?";
sUrl += "&c_id=" + $("#c_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); // 連線資料庫
$sql2 = " select * from customers01 where 1=1 "; // 準備要查詢的SQL指令
//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
?>
<select id="c_id" name="c_id" onchange="idkey()">
<option value="">請選擇</option>
<?php do{ ?>
<option value="<?php echo $row_Recordset2["c_id"];?>" <?php if ($varc_id==$row_Recordset2["c_id"]){echo "selected";} ?>><?php echo $row_Recordset2["c_name"];?></option>
<?php }while( $row_Recordset2 = mysql_fetch_assoc($Recordset2) ); ?>
</select>
</td>
</tr>
<?php
if( strlen($varc_id)){
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql3 = " select * from customers01 where 1=1 "; // 準備要查詢的SQL指令
//echo "sql3 = " .$sql3 . "<br>";
$Recordset3 = mysql_query($sql3, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset3 = mysql_fetch_assoc($Recordset3); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset3 = mysql_num_rows($Recordset3); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1
?>
<tr>
<td>外送住址</td>
<td>
<input type="text" name="c_addr" value="">
</td>
</tr>
<tr>
<td>統一編號</td>
<td><?php echo $row_Recordset3["c_num"];?></td>
</tr>
<tr>
<td>客戶住址</td>
<td><?php echo $row_Recordset3["c_addr"];?></td>
</tr>
<tr>
<td>手機</td>
<td><?php echo $row_Recordset3["c_phone"];?></td>
</tr>
<tr>
<td>傳真</td>
<td><?php echo $row_Recordset3["c_fax"];?></td>
</tr>
<?php } ?>
</table>
<input type="submit" value="新增">
<input type="hidden" name="mm_form" value="form1">
</form>
</body>
</html>
Posted in
0 意見 :
張貼留言