作者AJ0310 (AJ)
看板PHP
标题[请益] 请各位帮帮忙吧....SOS
时间Sun Jul 2 23:07:36 2006
我想请问一下资料的传递问题...
我所执行的页面是
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