[請益] 請各位幫幫忙吧....SOS
我想請問一下資料的傳遞問題...
我所執行的頁面是http://ss24.mcu.edu.tw/~s2130080/shop.php
我已經把檔案放在http://ss24.mcu.edu.tw/~s2130080/sos.rar
問題:
進去到結帳想顯示出我全部選購的東西時...
無法顯示出來...
請問我那個地方寫錯了嗎???
請各位大大幫幫忙吧....><"
下面是選擇物品的頁面(http://ss24.mcu.edu.tw/~s2130080/shop1.php)
<?
$link_ID=mysql_connect("xxxxx","xxxxx","xxxxx");
mysql_query("set names big5;");
?>
<?php
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];
$maxRows_rsTb1 = 10;
$pageNum_rsTb1 = 0;
if (isset($HTTP_GET_VARS['pageNum_rsTb1'])) {
$pageNum_rsTb1 = $HTTP_GET_VARS['pageNum_rsTb1'];
}
$startRow_rsTb1 = $pageNum_rsTb1 * $maxRows_rsTb1;
$link_ID=mysql_connect("xxxxx","xxxxx","xxxxx");
mysql_query("set names big5;");
mysql_select_db("xxxxx");
$query_rsTb1 = "SELECT * FROM MENU";
$query_limit_rsTb1 = sprintf("%s LIMIT %d, %d", $query_rsTb1, $startRow_rsTb1, $maxRows_rsTb1);
$rsTb1 = mysql_query($query_limit_rsTb1, $link_ID) or die(mysql_error());
$row_rsTb1 = mysql_fetch_assoc($rsTb1);
if (isset($HTTP_GET_VARS['totalRows_rsTb1'])) {
$totalRows_rsTb1 = $HTTP_GET_VARS['totalRows_rsTb1'];
} else {
$all_rsTb1 = mysql_query($query_rsTb1);
$totalRows_rsTb1 = mysql_num_rows($all_rsTb1);
}
$totalPages_rsTb1 = ceil($totalRows_rsTb1/$maxRows_rsTb1)-1;
$queryString_rsTb1 = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
$params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_rsTb1") == false &&
stristr($param, "totalRows_rsTb1") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsTb1 = "&" . implode("&", $newParams);
}
}
$queryString_rsTb1 = sprintf("&totalRows_rsTb1=%d%s", $totalRows_rsTb1, $queryString_rsTb1);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<title>選擇商品</title>
</head>
<body>
<table border="0" cellpadding="1" cellspacing="1">
<tr bgcolor="#CCCCFF">
<td height="19">NO.</td>
<td>名稱</td>
<td>價格</td>
<td>商店</td>
<td>類別</td>
<td>其他</td>
<td> </td>
</tr>
<? $i = 0 ?>
<?php do {
$i+=1;
if ($i % 2 == 0){
$P="CCFFCC";
}else{
$P="CCFFFF";
}
?>
<tr bgcolor="#<?php echo $P; ?>">
<td><?php echo $row_rsTb1['F_No']; ?></td>
<td><?php echo $row_rsTb1['F_Name']; ?></td>
<td><?php echo $row_rsTb1['F_Price']; ?></td>
<td><?php echo $row_rsTb1['S_No']; ?></td>
<td><?php echo $row_rsTb1['Type_No']; ?></td>
<td><?php echo $row_rsTb1['F_Name']; ?></td>
<td width="90"><a href="sebuy.php?F_No=<? echo $row_rsTb1['F_No'];?>&F_Name=<? echo $row_rsTb1['F_Name'];?>">放入購物車</a></td>
</tr>
<?php } while ($row_rsTb1 = mysql_fetch_assoc($rsTb1)); ?>
</table>
<p> 商品<?php echo ($startRow_rsTb1 + 1) ?> 到 <?php echo min($startRow_rsTb1 + $maxRows_rsTb1, $totalRows_rsTb1) ?>
共 <?php echo $totalRows_rsTb1 ?> 種產品
<form name="form2" method="post" action="shopcar.php">
<input type="submit" name="Submit" value="結帳">
</form>
<table border="0" width="50%" align="center">
<tr>
<td width="23%" align="center">
<?php if ($pageNum_rsTb1 > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsTb1=%d%s", $currentPage, 0, $queryString_rsTb1); ?>">第一頁</a>
<?php } // Show if not first page ?>
</td>
<td width="31%" align="center">
<?php if ($pageNum_rsTb1 > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsTb1=%d%s", $currentPage, max(0, $pageNum_rsTb1 - 1), $queryString_rsTb1); ?>">上一頁</a>
<?php } // Show if not first page ?>
</td>
<td width="23%" align="center">
<?php if ($pageNum_rsTb1 < $totalPages_rsTb1) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsTb1=%d%s", $currentPage, min($totalPages_rsTb1, $pageNum_rsTb1 + 1), $queryString_rsTb1); ?>">下一頁</a>
<?php } // Show if not last page ?>
</td>
<td width="23%" align="center">
<?php if ($pageNum_rsTb1 < $totalPages_rsTb1) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsTb1=%d%s", $currentPage, $totalPages_rsTb1, $queryString_rsTb1); ?>">最後一頁</a>
<?php } // Show if not last page ?>
</td>
</tr>
</table></p>
</body>
</html>
<?php
mysql_free_result($rsTb1);
?>
然後我把它"放入購物車"後...
它會藉由echo $_GET["F_No"];
顯示是我當時丟進的是什麼東西...
<HTML><HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
</HEAD><BODY>
<?
echo $_GET["F_No"];
echo $_GET["F_Name"];
?>
<P>請輸入您購買的數量</P>
<P><font color="#800000">如果只購買一件產品請直接按確定</font></P>
<P><font color="#FF0000">如果不小心將沒有要購買的產品放入購物車</font></P>
<form name="form2" method="post" action="shop1.php">→→→→請按這裡消除記錄→→→→
<input type="submit" name="Submit2" value="我放錯產品到購物車了，我要把產品放回架上去">
</form>
<HR>
<form method="post" name="form1" action="sebuy2.php?F_No=<?echo $_GET["F_No"];?>&F_Name=<?echo $_GET["F_No"];?>">您想要丟幾件產品進購物車？
<input name="mabq" type="text" id="mabq" maxlength="4" size="4" value="1">
<input name="F_No" type="hidden" id="F_No" value="<? echo $_GET["F_No"]; ?>">
<input name="F_Name" type="hidden" id="F_Name" value="<? echo $_GET["F_Name"]; ?>">
<input type="submit" name="Submit" value="數量確定了，我要把購物車推回去繼續購買產品">
</form>
</BODY>
</HTML>
<<sebuy2.php>>
<?php
session_start();
if(!isset($Stk))
$Stk=0;
$Sbb[$Stk]=$F_No;
$Snn[$Stk]=$F_Name;
$Sbq[$Stk]=$mabq;
$Stk=$Stk+1;
session_register("Sbb","Sbq","Stk","Snn");
header("Location:shop1.php");
exit;
?>
可是當我回到http://ss24.mcu.edu.tw/~s2130080/shop1.php時...
進去到結帳想顯示出我全部選購的東西時...
無法顯示出來...
請問我那個地方寫錯了嗎???
<?php session_start();?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<title>購物車</title>
</head>
<body>
<form method="POST" action="changen.php">
<table border="1" cellpadding="0" cellspacing="1">
<tr>
<td height="19">NO.</td>
<td>種類</td>
<td>名稱</td>
<td>其他</td>
<td>單價</td>
<td>數量</td>
<td>總計</td>
<td>附註</td>
</tr>
<?
echo $_GET["F_No"];
echo $_GET["F_Name"];
?>
<?php
function output($result,$i)
{
echo $_GET["F_No"];
echo $_GET["F_Name"];
global $Sbq;
$gha=$Sbq[$i];
$ghb=$result[F_price];
$ghc=$gha * $ghb;
echo " <tr>\n";
echo " <td width=\"30\" bgcolor=\"#FFFFFF\" align=\"center\" height=\"25\"><font color=\"#000000\">$result[F_No]</font></td>\n";
echo " <td width=\"80\" bgcolor=\"#FFFFFF\" align=\"center\" height=\"25\"><font color=\"#000000\">$result[S_No]</font></td>\n";
echo " <td width=\"200\" bgcolor=\"#FFFFFF\" align=\"center\" height=\"25\"><font color=\"#000000\">$result[F_Name]</font></td>\n";
echo " <td width=\"200\" bgcolor=\"#FFFFFF\" align=\"center\" height=\"25\"><font color=\"#000000\">$result[F_price]</font></td>\n";
echo " <td width=\"80\" bgcolor=\"#FFFFFF\" align=\"center\" height=\"25\"><font color=\"#000000\">$result[F_price]</font></td>\n";
echo " <td width=\"45\" bgcolor=\"#FFFFFF\" align=\"center\" height=\"25\"><font color=\"#000000\"><input type=\"text\" name=\"fm_bt$i\" size=\"3\" value=\"$Sbq[$i]\"></font></td>\n";
echo " <td width=\"80\" bgcolor=\"#FFFFFF\" align=\"center\" height=\"25\"><font color=\"#000000\">$ghc</font></td>\n";
echo " <td width=\"40\" bgcolor=\"#FFFFFF\" align=\"center\" height=\"25\"><font color=\"#00CCCC\">無</font></td>\n";
echo " </tr>\n";
global $ghd;
$ghd=$ghc+$ghd;
}
// 連線MySQL
if(!mysql_pconnect("xxxxx","xxxxx","xxxxx"))
{
echo "<p>MySQL資料庫連線錯誤,請稍後再試</p>";
exit();
}
for($i=0;$i<$Stk;$i++)
{
if($Sbb[$i]!="")
{
$query=mysql_db_query("s2130080","SELECT * FROM MENU WHERE F_No=$Sbb[$i]");
$result=mysql_fetch_array($query);
output($result,$i);
}
}
?>
</table>
<input type="submit" value="付款" name="B2">
您所訂購的產品合計 ：<font color=blue>
<?php
global $ghd;
echo $ghd;
?> </font>元
</form>
</body>
</html>
<<shopcar2.php>>
<?php session_start();?>
<?
$link_ID=mysql_connect("xxxxx","xxxxx","xxxxx");
mysql_query("set names big5;");
mysql_select_db("s2130080");
?>
<?php
global $Sbq;
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];
$maxRows_rsTb1 = 10;
$pageNum_rsTb1 = 0;
if (isset($HTTP_GET_VARS['pageNum_rsTb1'])) {
$pageNum_rsTb1 = $HTTP_GET_VARS['pageNum_rsTb1'];
}
$startRow_rsTb1 = $pageNum_rsTb1 * $maxRows_rsTb1;
$link_ID=mysql_connect("140.131.50.205","s2130080","mrpaba6");
mysql_query("set names big5;");
mysql_select_db("s2130080");
$query_rsTb1 = "SELECT * FROM MENU WHERE F_No=$Sbb[$i]";
$query_limit_rsTb1 = sprintf("%s LIMIT %d, %d", $query_rsTb1, $startRow_rsTb1, $maxRows_rsTb1);
$rsTb1 = mysql_query($query_limit_rsTb1, $link_ID) or die(mysql_error());
$row_rsTb1 = mysql_fetch_assoc($rsTb1);
if (isset($HTTP_GET_VARS['totalRows_rsTb1'])) {
$totalRows_rsTb1 = $HTTP_GET_VARS['totalRows_rsTb1'];
} else {
$all_rsTb1 = mysql_query($query_rsTb1);
$totalRows_rsTb1 = mysql_num_rows($all_rsTb1);
}
$totalPages_rsTb1 = ceil($totalRows_rsTb1/$maxRows_rsTb1)-1;
$queryString_rsTb1 = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
$params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_rsTb1") == false &&
stristr($param, "totalRows_rsTb1") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsTb1 = "&" . implode("&", $newParams);
}
}
$queryString_rsTb1 = sprintf("&totalRows_rsTb1=%d%s", $totalRows_rsTb1, $queryString_rsTb1);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<title>選擇商品</title>
</head>
<body>
<table border="1" cellpadding="0" cellspacing="1">
<tr>
<td height="19">NO.</td>
<td>名稱</td>
<td>價格</td>
<td>庫存</td>
<td>類別</td>
<td>其他</td>
<td>數量</td>
<td>刪除</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_rsTb1['F_No']; ?></td>
<td><?php echo $row_rsTb1['F_Name']; ?></td>
<td><?php echo $row_rsTb1['F_Price']; ?></td>
<td><?php echo $row_rsTb1['F_Price']; ?></td>
<td><?php echo $row_rsTb1['F_Price']; ?></td>
<td><?php echo $row_rsTb1['F_Price']; ?></td>
<td><input name="textfield" type="text" size="4"></td>
<td width="90">刪</td>
</tr>
<?php } while ($row_rsTb1 = mysql_fetch_assoc($rsTb1)); ?>
</table>
<p> 購物車中<?php echo ($startRow_rsTb1 + 1) ?> 到 <?php echo min($startRow_rsTb1 + $maxRows_rsTb1, $totalRows_rsTb1) ?>
共 <?php echo $totalRows_rsTb1 ?> 種產品
<form name="form2" method="post" action="shopcar.php">
<input type="submit" name="Submit" value="付款">
</form>
<table border="0" width="50%" align="center">
<tr>
<td width="23%" align="center">
<?php if ($pageNum_rsTb1 > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsTb1=%d%s", $currentPage, 0, $queryString_rsTb1); ?>">第一頁</a>
<?php } // Show if not first page ?>
</td>
<td width="31%" align="center">
<?php if ($pageNum_rsTb1 > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsTb1=%d%s", $currentPage, max(0, $pageNum_rsTb1 - 1), $queryString_rsTb1); ?>">上一頁</a>
<?php } // Show if not first page ?>
</td>
<td width="23%" align="center">
<?php if ($pageNum_rsTb1 < $totalPages_rsTb1) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsTb1=%d%s", $currentPage, min($totalPages_rsTb1, $pageNum_rsTb1 + 1), $queryString_rsTb1); ?>">下一頁</a>
<?php } // Show if not last page ?>
</td>
<td width="23%" align="center">
<?php if ($pageNum_rsTb1 < $totalPages_rsTb1) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsTb1=%d%s", $currentPage, $totalPages_rsTb1, $queryString_rsTb1); ?>">最後一頁</a>
<?php } // Show if not last page ?>
</td>
</tr>
</table></p>
</body>
</html>
<?php
mysql_free_result($rsTb1);
?>
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.223.7.22
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
