This is featured post 1 title

Replace these every slider sentences with your featured post descriptions.Go to Blogger edit html and find these sentences.Now replace these with your own descriptions.This theme is Bloggerized by Lasantha - Premiumbloggertemplates.com.

This is featured post 2 title

Replace these every slider sentences with your featured post descriptions.Go to Blogger edit html and find these sentences.Now replace these with your own descriptions.This theme is Bloggerized by Lasantha - Premiumbloggertemplates.com.

This is featured post 3 title

Replace these every slider sentences with your featured post descriptions.Go to Blogger edit html and find these sentences.Now replace these with your own descriptions.This theme is Bloggerized by Lasantha - Premiumbloggertemplates.com.

This is featured post 4 title

Replace these every slider sentences with your featured post descriptions.Go to Blogger edit html and find these sentences.Now replace these with your own descriptions.This theme is Bloggerized by Lasantha - Premiumbloggertemplates.com.

This is featured post 5 title

Replace these every slider sentences with your featured post descriptions.Go to Blogger edit html and find these sentences.Now replace these with your own descriptions.This theme is Bloggerized by Lasantha - Premiumbloggertemplates.com.

2014年12月17日 星期三

Kelly于文文 Want you back

上午8:15 禹傑
Read More

Kelly于文文 Want you back

上午8:15 禹傑
Read More

Kelly于文文-小蘋果R&B氣質版

上午8:10 禹傑
Read More

Kelly 于文文 - Want You Back【跟馬叔叔一起搖滾學電吉他211】

上午8:02 禹傑
Read More

2014年10月22日 星期三

訂單+訂單明細 (刪除)

晚上11:53 禹傑
訂單+訂單明細 (刪除)
orders_detail_del.php
<?php require_once('../../../Connections/allianz.php'); ?>
<?php
$varo_id = ""; if (isset($_REQUEST["o_id"]) ){ $varo_id =$_REQUEST["o_id"]; }
$varod_id = ""; if (isset($_REQUEST["od_id"]) ){ $varod_id =$_REQUEST["od_id"]; }
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$del  = " delete  ";
$del .= " from orders_detail01 ";
$del .= " where 1=1 ";
$del .= " and od_id = ".$varod_id." ";
//echo " del = ".$del."<br>";

$Recordset1 = mysql_query($del, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset1 = mysql_fetch_assoc($Recordset1); // 把查詢的結果帶到$row_Recordset1[]陣列中
header(sprintf("Location: %s", "orders_detail_qry.php?o_id=" .$varo_id. "" ));

?>




Read More

訂單+訂單明細 (修改)

晚上11:50 禹傑
訂單+訂單明細 (修改)
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>
Read More

訂單+訂單明細 (新增)

晚上11:46 禹傑
訂單+訂單明細 (新增)
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>
Read More

訂單+訂單明細 (查詢)

晚上11:41 禹傑
訂單+訂單明細 (查詢)
orders_detail_qry.php
<?php require_once('../../../Connections/allianz.php'); ?>
<?php

$varo_id = ""; if (
isset($_REQUEST["o_id"]) ){ $varo_id =$_REQUEST["o_id"];
}

mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql = " select  ";
$sql .= " a.od_id, a.o_id, a.p_id, a.p_cnts, ";
$sql .= " b.p_name, b.p_prices, b.p_name ";
$sql.= " from ";
$sql.= " orders_detail01 a ";
$sql.= " left join ";
$sql.= " products01 b ";
$sql.= " on b.p_id = a.p_id ";
$sql.= " where 1=1 ";
//echo  " sql = " . $sql . "<br>";
//exit();
$Recordset1 = mysql_query($sql, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset1 = mysql_fetch_assoc($Recordset1); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset1 = mysql_num_rows($Recordset1); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<a href="orders_detail_ins.php?o_id=<?php echo $varo_id;?>">新增訂單</a>
<table border="1">
<tr>
 <td>訂單明細編號</td>
<td>主訂單編號</td>
<td>產品編號</td>
<td>產品名稱</td>
<td>數量</td>
<td>修改</td>
<td>刪除</td>
</tr>

<?php if($totalRow_Recordset1>0){  ?>
<? do{   ?>
<tr>
<td><?php  echo $row_Recordset1["od_id"];?></td>
<td><?php  echo $row_Recordset1["o_id"];?></td>
<td><?php  echo $row_Recordset1["p_id"];?></td>
<td><?php  echo $row_Recordset1["p_name"];?></td>
<td><?php  echo $row_Recordset1["p_cnts"];?></td>
<td><input type="button" name="btn_upd" value="修改"
onclick="location.href='orders_detail_upd.php?od_id=<?php  echo $row_Recordset1["od_id"];?>&o_id=<?php echo $varo_id;?>';"
style="height:100%;">
</td>
<td><input type="button" name="btn_upd" value="刪除"
onclick="location.href='orders_detail_del.php?od_id=<?php  echo $row_Recordset1["od_id"];?>&o_id=<?php echo $varo_id;?>';"
style="height:100%;">
</td>
</tr>
<?php }while( $row_Recordset1 = mysql_fetch_assoc($Recordset1)  ); ?>
<?php }else{ ?>
<tr>
<td colspan="6">目前尚無資料</td>
</tr>

<?php }  ?>
</table>
</body>


</html>
Read More

訂單(刪除)+訂單明細

晚上11:36 禹傑




訂單(刪除)+訂單明細
orders_del.php
<?php require_once('../../Connections/allianz.php'); ?>
<?php
$varo_id = ""; if (isset($_REQUEST["o_id"]) ){ $varo_id =$_REQUEST["o_id"];}
//echo " o_id = " . $varo_id . "<br>";

$del = "delete from orders01 where 1=1 and o_id= ".$varo_id." "; // 準備 新增或修改或刪除的SQL語法
//echo "del=" . $del . "<br>";
//exit();
mysql_select_db($database_allianz, $allianz);  // 連線資料庫
$Result1 = mysql_query($del, $allianz) or die(mysql_error()); // 執行新增或修改或刪除的SQL語法
header(sprintf("Location: %s", "orders_qry.php" ));

?>
Read More

訂單(修改)+訂單明細

晚上11:33 禹傑
訂單(修改)+訂單明細 
order_upd.php

<?php require_once('../../Connections/allianz.php'); ?>
<?php

 /*
1.查詢下拉選單表   客戶表
2.選擇下拉選單 帶KEY值
key 帶出客戶表的全部欄位
3.KEY值用 javascript 抓網址列
4.做新增動作  主訂單

 5.查詢下拉選單表   產品 表
6.選擇下拉選單 帶KEY值
key 帶出產品 表的全部欄位
7.KEY值用 javascript 抓網址列
8.做新增動作   次訂單

 */
$varo_id = ""; if (isset($_REQUEST["o_id"]) ){ $varo_id =$_REQUEST["o_id"];}
//echo " o_id = " . $varo_id . "<br>";
$varc_id = ""; if (isset($_REQUEST["c_id"]) ){ $varc_id =$_REQUEST["c_id"];}
//echo " c_id = " . $varc_id . "<br>";
$varp_id = ""; if (isset($_REQUEST["p_id"]) ){ $varp_id =$_REQUEST["p_id"];}
//echo " p_id = " . $varp_id . "<br>";
$varp_cnts = ""; if (isset($_REQUEST["p_cnts"]) ){ $varp_cnts =$_REQUEST["p_cnts"];}
//echo " p_cnts = " . $varp_cnts . "<br>";
$varMM_form = ""; if (isset($_POST["mm_form"]) ){ $varMM_form =$_POST["mm_form"];}
//echo "mm_form=" .$varMM_form ."<br>";
// 查到o_id
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql3 = " select max(o_id) o_id from orders01 where 1=1  ";    // 準備要查詢的SQL指令
$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
$o_id = $row_Recordset3["o_id"];
$varp_cnts = ""; if (isset($_POST["p_cnts"]) ){ $varp_cnts =$_POST["p_cnts"];}
// 新增至次訂單 orders01
if( $varMM_form == "form1"){
$varc_num = ""; if (isset($_POST["c_num"]) ){ $varc_num =$_POST["c_num"];}
$varc_name = ""; if (isset($_POST["c_name"]) ){ $varc_name =$_POST["c_name"];}
$varc_addr = ""; if (isset($_POST["c_addr"]) ){ $varc_addr =$_POST["c_addr"];}
$varc_phone = ""; if (isset($_POST["c_phone"]) ){ $varc_phone =$_POST["c_phone"];}
$varc_fax = ""; if (isset($_POST["c_fax"]) ){ $varc_fax =$_POST["c_fax"];}
 mysql_select_db($database_allianz, $allianz); // 連線資料庫
$upd=" update orders01 set ";
$upd.=" c_id = ".$varc_id.", ";
$upd.=" c_addr = '".$varc_addr."', ";
$upd = substr($upd, 0 , strlen($upd) -2);
$upd.=" where 1=1 ";
$upd.=" and o_id= ".$varo_id." ";
//echo " upd = ".$upd."<br>";
//exit();
$Recordset1 = mysql_query($upd, $allianz) or die(mysql_error()); // 執行查詢語法
//exit();
header(sprintf("Location: %s", "orders_qry.php" ));
}

 ?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script src="http://code.jquery.com/jquery-1.10.2.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_upd.php?";
sUrl += "&c_id=" + $("#c_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); // 連線資料庫
$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="<?php echo $row_Recordset3["c_addr"];?>">
</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="hidden" name="o_id" id="o_id" value="<?php echo $_REQUEST["o_id"];?>">
<input type="submit" value="修改">
<input type="hidden" name="mm_form" value="form1">
</form>
</body>


</html>
Read More

訂單(新增)+訂單明細

晚上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>
Read More

訂單(查詢)+訂單明細

晚上11:23 禹傑
訂單(查詢)+  訂單明細
 <?php require_once('../../Connections/allianz.php'); ?>
<?php

mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql  = " select  ";
$sql .= " a.o_id, a.c_addr, ";
$sql .= " b.c_name, b.c_addr b_c_addr, b.c_phone, b.c_fax ";
$sql .= " from ";
$sql .= " orders01 a ";
$sql .= " left join ";
$sql .= " customers01 b ";
$sql .= " on a.c_id = b.c_id ";
$sql .= " where 1=1  ";    // 準備要查詢的SQL指令
//echo  " sql = " . $sql . "<br>";
//exit();
$Recordset1 = mysql_query($sql, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset1 = mysql_fetch_assoc($Recordset1); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset1 = mysql_num_rows($Recordset1); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1


mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql2 = " select ";
$sql2.= " c_addr ";
$sql2.= " from ";
$sql2.= " orders01 ";
$sql2.= " where 1=1 ";
$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
?>
<html>
<body>
<a href="orders_ins.php">新增訂單</a>
<table border="1">
<tr>
<td>訂單編號</td>
<td>客戶名稱</td>
<td>客戶地址</td>
<td>電話</td>
<td>傳真</td>
<td>外送地址</td>
<td>修改</td>
<td>刪除</td>
<td>維謢明細</td>
</tr>
<?php if ( $totalRow_Recordset1>0 ) {?>
<?php do{   ?>
<tr>
<td><?php  echo $row_Recordset1["o_id"];?></td>
<td><?php  echo $row_Recordset1["c_name"];?></td>
<td><?php  echo $row_Recordset1["b_c_addr"];?></td>
<td><?php  echo $row_Recordset1["c_phone"];?></td>
<td><?php  echo $row_Recordset1["c_fax"];?></td>
<td><?php  echo $row_Recordset1["c_addr"];?></td>

<td>
<input type="button" name="btn_upd" value="修改"
onclick="location.href='orders_upd.php?o_id=<?php  echo $row_Recordset1["o_id"];?>';"
style="height:100%;">
</td>
<td>
<input type="button" name="btn_del" value="刪除"
onclick="location.href='orders_del.php?o_id=<?php  echo $row_Recordset1["o_id"];?>';"
style="height:100%;">
</td>
<td>
<input type="button" name="btn_detail" value="維謢明細"
onclick="location.href='orders_detail/orders_detail_qry.php?o_id=<?php  echo $row_Recordset1["o_id"];?>';"
style="height:100%;">
</td>
</tr>
<?php }while( $row_Recordset1 = mysql_fetch_assoc($Recordset1)   );?>

<?php }else{ ?>

<tr>

<td colspan="6">目前尚無資料</td>

</tr>

<?php }  ?>

</table>
<hr>

</body>
</html>

Read More
訂閱： 文章 ( Atom )
Twitter Delicious Facebook Digg Stumbleupon Favorites More
RSS Feed Subscribe to Our RSS feed!
Follow Us on Twitter! Follow Us on Twitter!

我的粉絲團

Popular Posts

  • 玻璃心酸民台下吐槽，被喜劇藝人的精闢回應狠狠打臉 (中文字幕)放大
    1050401 單口喜劇藝人表演時，遇到台下觀眾鬧場或吐槽是家常便飯，有時候也因此激發出經典的笑話或段子。喜劇藝人Steve Hofstetter被一名覺得被酸到的玻璃心觀眾嗆，他用中肯又爆笑的回應完美反擊 http://vlog.xuite.net/play/MlEzbXB...
  • 別讓我的滑鼠沒氣質
    20141001書名:別讓我的滑鼠沒氣質 頁面設計 http://case.ntu.edu.tw/CASTUDIO/           logo設計 http://vr.theatre.ntu.edu.tw/hlee/course/th7_530/index.html#...
  • 20160126 一中街 某B1餐廳 吃義大利麵
    20160126 一中街 某B1餐廳 吃義大利麵
  • Div+CSS網頁版面設計 : 輕鬆做網頁排版 隨手做SEO
    書名: Div+CSS網頁版面設計 : 輕鬆做網頁排版 隨手做SEO 就是在HTML上，CSS對排版上的功能，和網頁版面上呈現的一些範例。
  • 1050402 我對該交通工具的看法
    1050402 我對該工具看法已經在路上看到那種交通工具好幾次了，短柚灰色衣服，短牛仔褲男生站的那個交通工具，能源 白天太陽能，晚上吃電，體積小，沒停車位問體，好維修(零件整個換)，修機車的工作，我覺得差在動力強弱了，我有看到座椅，所... 由 黃禹傑 貼上了  2016年4月3日
  • 訂單(修改)+訂單明細
    訂單(修改)+訂單明細  order_upd.php <?php require_once('../../Connections/allianz.php'); ?> <?php /* 1.查詢下拉選單表   客戶表 2.選擇下...
  • 訂單(新增)+訂單明細
    <?php require_once('../../Connections/allianz.php'); ?> <?php $varc_id = ""; if (isset($_REQUEST["c_id&qu...
  • 性別、留言板、驗證、喜好
    20141001  def    性別、留言板、驗證、喜好 def_qry.php <?php require_once('../Connections/allianz.php'); ?> <?php $v...
  • 訂單(刪除)+訂單明細
    訂單(刪除)+訂單明細 orders_del.php <?php require_once('../../Connections/allianz.php'); ?> <?php $varo_id = "...
  • 演藝圈喜事多　鄭元暢張鈞甯婚照曬幸福　網友喊想嫁
    演藝圈喜事多　鄭元暢張鈞甯婚照曬幸福　網友喊想嫁 近來演藝圈喜事頻傳，前有藍正龍、周幼婷戀情開花結果，接著辛隆、劉真這對才子佳人也低調現身戶政事務所，傳6月將辦海島婚禮，而鄭元暢更於社交網站instagram曬出與張鈞甯在偶像劇中的甜蜜婚照添喜氣，幸福滿滿讓網友看了直呼好...

Blogger templates

Blogger news

Blogroll