訂單(查詢)+ 訂單明細
<?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>
留言列表
