社区

京东店铺
淘宝店铺
当当店铺
拼多多店铺

APP下载

扫描下载官方APP

VIP会员

PHP图书答疑

+关注

已有40人关注

+发表新帖

所属版块： PHP答疑区

玖玖_mrkj

学分:0

+关注

私信

立即签到

版块推荐

【急】PHP项目开发全程实录之电子商务平台后台问题

发表在PHP图书答疑 2010-05-09

是否精华是否

版块置顶: 是否

在进行后台管理时遇到的如下问题。
问题1:在修改商品时，存不到数据库中
代码如下:

<?php
include("conn/conn.php");
$sql1=mysql_query("select * from tb_shangpin where id=".$_GET['id']."",$conn);
$info1=mysql_fetch_array($sql1);
?>
<body topmargin="0" leftmargin="0" bottommargin="0">
<table width="750" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="20" bgcolor="#FFCF60"><div align="center" class="style1">更改商品信息</div></td>
</tr>
<tr>
<td height="253" bgcolor="#666666"><table width="750" border="0" cellpadding="0" cellspacing="1">
<script language="javascript">
function chkinput(form)
{
if(form.mingcheng.value=="")
{
alert("请输入商品名称!");
form.mingcheng.select();
return(false);
}

if(form.huiyuanjia.value=="")
{
alert("请输入商品会员价!");
form.huiyuanjia.select();
return(false);
}

if(form.shichangjia.value=="")
{
alert("请输入商品市场价!");
form.shichangjia.select();
return(false);
}
if(form.dengji.value=="")
{
alert("请输入商品等级!");
form.dengji.select();
return(false);
}

if(form.pinpai.value=="")
{
alert("请输入商品品牌!");
form.pinpai.select();
return(false);
}

if(form.xinghao.value=="")
{
alert("请输入商品型号!");
form.xinghao.select();
return(false);
}
if(form.shuliang.value=="")
{
alert("请输入商品数量!");
form.shuliang.select();
return(false);
}
if(form.jianjie.value=="")
{
alert("请输入商品简介!");
form.jianjie.select();
return(false);
}
return(true);
}
</script>
<form name="form1" enctype="multipart/form-data" method="post" action="savechangegoods.php?id=<?php echo $_GET[id];?>" onSubmit="return chkinput(this)">
<tr>
<td width="129" height="25" bgcolor="#FFFFFF"><div align="center">商品名称：</div></td>
<td width="618" bgcolor="#FFFFFF"><div align="left">
<input type="text" name="mingcheng" size="25" class="inputcss" value="<?php echo $info1["mingcheng"];?>">
</div></td>
</tr>
<tr>
<td height="25" bgcolor="#FFFFFF"><div align="center">上市时间：</div></td>
<td height="25" bgcolor="#FFFFFF"><div align="left">
<select name="nian" class="inputcss">
<?php
for($i=1995;$i<=2050;$i++)
{
?>
<option <?php if(substr($info1['addtime'],0,4)==$i){echo "selected";}?>><?php echo $i;?></option>
<?php
}
?>
</select>
年
<select name="yue" class="inputcss">
<?php
for($i=1;$i<=12;$i++)
{
?>
<option <?php if(substr($info1['addtime'],5,1)==$i){echo "selected";} ?>><?php echo $i;?></option>
<?php
}
?>
</select>
月
<select name="ri" class="inputcss">
<?php
for($i=1;$i<=31;$i++)
{
?>
<option <?php if(substr($info1['addtime'],7,1)==$i){echo "selected";} ?>><?php echo $i;?></option>
<?php
}
?>
</select>
日</div></td>
</tr>
<tr>
<td height="25" bgcolor="#FFFFFF"><div align="center">价格：</div></td>
<td height="25" bgcolor="#FFFFFF"><div align="left">市场价：
<input type="text" name="shichangjia" size="10" class="inputcss" value="<?php echo $info1['shichangjia'];?>">
元  会员价：
<input type="text" name="huiyuanjia" size="10" class="inputcss" value="<?php echo $info1['huiyuanjia'];?>">
元</div></td>
</tr>
<tr>
<td height="25" bgcolor="#FFFFFF"><div align="center">商品类型：</div></td>
<td height="25" bgcolor="#FFFFFF"><div align="left">
<?php
$sql=mysql_query("select * from tb_type order by id desc",$conn);
$info=mysql_fetch_array($sql);
if($info==false)
{
echo "请先添加商品类型!";
}
else
{
?>
<select name="typeid" class="inputcss">
<?php
do
{
?>
<option value=<?php echo $info['id'];?> <?php if($info1['typeid']==$info['id']) {echo "selected";}?>><?php echo $info['typename'];?></option>
<?php
}
while($info=mysql_fetch_array($sql));
?>
</select>
<?php
}
?>
</div></td>
</tr>
<tr>
<td height="25" bgcolor="#FFFFFF"><div align="center">商品等级：</div></td>
<td height="25" bgcolor="#FFFFFF"><div align="left">
<select name="dengji" class="inputcss">
<option value="精品" <?php if(trim($info1["dengji"])=="精品"){echo "selected";}?>>精品</option>
<option value="一般" <?php if(trim($info1["dengji"])=="一般"){echo "selected";}?>>一般</option>
<option value="二手" <?php if(trim($info1["dengji"])=="二手"){echo "selected";}?>>二手</option>
<option value="淘汰" <?php if(trim($info1["dengji"])=="淘汰"){echo "selected";}?>>淘汰</option>
</select>
</div></td>
</tr>
<tr>
<td height="22" bgcolor="#FFFFFF"><div align="center">商品品牌：</div></td>
<td height="22" bgcolor="#FFFFFF"><div align="left">
<input type="text" name="pinpai" class="inputcss" size="20" value="<?php echo $info1['pinpai'];?>">
</div></td>
</tr>
<tr>
<td height="25" bgcolor="#FFFFFF"><div align="center">商品型号：</div></td>
<td height="25" bgcolor="#FFFFFF"><div align="left">
<input type="text" name="xinghao" class="inputcss" size="20" value="<?php echo $info1['xinghao'];?>">
</div></td>
</tr>
<tr>
<td height="25" bgcolor="#FFFFFF"><div align="center">是否推荐：</div></td>
<td height="25" bgcolor="#FFFFFF"><div align="left">
<select name="tuijian" class="inputcss" >
<option value=1 <?php if($info1['tuijian']==1) {echo "selected";}?>>是</option>
<option value=0 <?php if($info1['tuijian']==0) {echo "selected";}?>>否</option>
</select>
</div></td>
</tr>
<tr>
<td height="25" bgcolor="#FFFFFF"><div align="center">商品数量：</div></td>
<td height="25" bgcolor="#FFFFFF"><div align="left">
<input type="text" name="shuliang" class="inputcss" size="20" value="<?php echo $info1['shuliang'];?>">
</div></td>
</tr>
<tr>
<td height="25" bgcolor="#FFFFFF"><div align="center">商品图片：</div></td>
<td height="25" bgcolor="#FFFFFF"><div align="left">
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="upfile" type="file" class="inputcss" id="upfile" size="30">
</div></td>
</tr>
<tr>
<td height="80" bgcolor="#FFFFFF"><div align="center">商品简介：</div></td>
<td height="25" bgcolor="#FFFFFF"><div align="left">
<textarea name="jianjie" cols="50" rows="8" class="inputcss"><?php echo $info1['jianjie'];?></textarea>
</div></td>
</tr>
<tr>
<td height="25" colspan="2" bgcolor="#FFFFFF"><div align="center">
<input type="submit" class="buttoncss" value="更改">
  
<input type="reset" value="取消更改" class="buttoncss">
</div></td>
</tr>
</form>
</table></td>
</tr>
</table>
问题2:
Notice: Undefined index: upfile in D:\wamp\www\shop\admin\savechangegoods.php on line 16
代码如下:<?php
include("conn/conn.php");
$mingcheng=$_POST['mingcheng'];
$nian=$_POST['nian'];
$yue=$_POST['yue'];
$ri=$_POST['ri'];
$shichangjia=$_POST['shichangjia'];
$huiyuanjia=$_POST['huiyuanjia'];
$typeid=$_POST['typeid'];
$dengji=$_POST['dengji'];
$xinghao=$_POST['xinghao'];
$pinpai=$_POST['pinpai'];
$tuijian=$_POST['tuijian'];
$shuliang=$_POST['shuliang'];
$upfile=$_POST['upfile'];

if(ceil(($huiyuanjia/$shichangjia)*100)<=80)
{

$tejia=1;
}
else
{
$tejia=0;
}
if($upfile!="")

{
$sql=mysql_query("select * from tb_shangpin where id=".$_GET['id']."",$conn);
$info=mysql_fetch_array($sql);
@unlink(substr($info['tupian'],6,(strlen($info['tupian'])-6)));
}

function getname($exname){
$dir = "upimages/";
$i=1;
if(!is_dir($dir)){
mkdir($dir,0777);
}

while(true){
if(!is_file($dir.$i.".".$exname)){
$name=$i.".".$exname;
break;
}
$i++;
}

return $dir.$name;
}

$exname=strtolower(substr($_FILES['upfile']['name'],(strrpos($_FILES['upfile']['name'],'.')+1)));
$uploadfile = getname($exname);

move_uploaded_file($_FILES['upfile']['tmp_name'], $uploadfile);

$uploadfile="admin/".$uploadfile;

$jianjie=$_POST['jianjie'];
$addtime=$nian."-".$yue."-".$ri;

mysql_query("update tb_shangpin set mingcheng='$mingcheng',jianjie='$jianjie',addtime='$addtime',dengji='$dengji',xinghao='$xinghao',tupian='$uploadfile',typeid='$typeid',shichangjia='$shichangjia',huiyuanjia='$huiyuanjia',pinpai='$pinpai',tuijian='$tuijian',shuliang='$shuliang' where id=".$_GET['id']."",$conn);
echo "<script>alert('商品".$mingcheng."修改成功!');history.back();;</script>";
?>

分享到：

关注

支持(0)

反对(0)

精彩评论 2

346827366

学分：0 LV1

+关注

私信

2010-05-10

沙发

您是运行光盘中的程序，还是自己修改的

我们对光盘中的程序进行了测试，没有出现您所述的问题；

您在修改产品信息时是否添加了图片，如果没有添加图片，那么将出现您所说的第2个问题

支持(0)

反对(0)

玖玖_mrkj

学分：0 LV1

+关注

私信

TA的每日心情

开心

2024-01-09 16:43:55

2010-05-11

板凳

谢谢你，问题已解决，还有一个问题想请你帮忙解决。
回复：
  Notice: Undefined index: spid in D:\wamp\www\shop\showpl.php on line 4
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\wamp\www\shop\showpl.php on line 28
本商品暂无评论信息!   本站共有该商品评论   条每页显示
Notice: Undefined variable: pagesize in D:\wamp\www\shop\showpl.php on line 105
条第
Notice: Undefined variable: page in D:\wamp\www\shop\showpl.php on line 105
页/共
Notice: Undefined variable: pagecount in D:\wamp\www\shop\showpl.php on line 105
页
Notice: Undefined variable: page in D:\wamp\www\shop\showpl.php on line 107

Notice: Undefined variable: pagecount in D:\wamp\www\shop\showpl.php on line 113

Notice: Undefined variable: pagecount in D:\wamp\www\shop\showpl.php on line 114

代码如下:

<?php
include("top.php");
include("function.php");
$spid=$_GET['spid'];
$id=$_GET['id'];
?>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/font.css">
<table width="766" height="438" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="209" height="438" valign="top" bgcolor="#FFFFFF"><div align="center">
      <?php
   include("left.php");
?>
      </div></td>
    <td width="581" valign="top" bgcolor="#FFFFFF"><table width="550" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td><div align="left"><a href="javascript:history.back();">返回</a></div></td>
      </tr>
    </table>
      <table width="550" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr bgcolor="#FDE9C9">
          <td height="25" colspan="4"><div align="center" style="color: #990000">商品评论</div></td>
        </tr>
        <?php
       $sql=mysql_query("select count(*) as total from tb_pingjia where spid='".$_GET['id']."'",$conn);

       $info=mysql_fetch_array($sql);
   $total=$info['total'];
   if($total==0)
   {
     echo "本商品暂无评论信息!";
   }
   else
   {
       $pagesize=3;
   if ($total<=$pagesize){
      $pagecount=1;
}
if(($total%$pagesize)!=0){
   $pagecount=intval($total/$pagesize)+1;

}else{
   $pagecount=$total/$pagesize;

}
if(($_GET[page])==""){
    $page=1;

}else{
    $page=intval($_GET[page]);

}
             $sql1=mysql_query("select * from tb_pingjia where spid='".$_GET[id]."' order by time desc limit ".($page-1)*$pagesize.",$pagesize ",$conn);
             while($info1=mysql_fetch_array($sql1))
     {
  ?>
        <tr>
          <td width="70" height="20"><div align="center">商品名称：</div></td>
          <td width="181"><div align="left">
              <?php
     $spid=$info1[spid];
$sql2=mysql_query("select mingcheng from tb_shangpin where id=".$spid."",$conn);
$info2=mysql_fetch_array($sql2);
echo $info2[mingcheng];
  ?>
          </div></td>
          <td width="70"><div align="center">评论时间：</div></td>
          <td width="229"><div align="left"><?php echo $info1[time];?></div></td>
        </tr>
        <tr>
          <td height="20"><div align="center">评论者：</div></td>
          <td height="20" colspan="3"><div align="left">
              <?php
     $spid=$info1[userid];
$sql3=mysql_query("select name from tb_user where id=".$spid."",$conn);
$info3=mysql_fetch_array($sql3);
echo $info3[name];

  ?>
          </div></td>
        </tr>
        <tr>
          <td height="20"><div align="center">评论主题：</div></td>
          <td height="20" colspan="3"><div align="left"><?php echo unhtml($info1[title]);?></div></td>
        </tr>
        <tr>
          <td height="40"><div align="center">评论内容：</div></td>
          <td height="40" colspan="3" valign="bottom"><div align="left"><?php echo unhtml($info1[content]);?></div></td>
        </tr>
        <tr>
          <td height="10" colspan="4" background="images/line1.gif"></td>
        </tr>
        <?php
   }
  }
  ?>
      </table>
      <table width="550" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td><div align="right">  本站共有该商品评论 
                  <?php
   echo $total;
  ?>
 条 每页显示 <?php echo $pagesize;?> 条 第 <?php echo $page;?> 页/共 <?php echo $pagecount; ?> 页
        <?php
  if($page>=2)
  {
  ?>
        <a href="showpl.php?page=1" title="首页"><font face="webdings"> 9 </font></a> <a href="showpl.php?id=<?php echo $id;?>&page=<?php echo $page-1;?>&spid=<?php echo $spid;?>&id=<?php echo $id;?>" title="前一页"><font face="webdings"> 7 </font></a>
        <?php
  }
   if($pagecount<=4){
    for($i=1;$i<=$pagecount;$i++){
  ?>
        <a href="showpl.php?page=<?php echo $i;?>&spid=<?php echo $spid;?>&id=<?php echo $id;?>"><?php echo $i;?></a>
        <?php
     }
   }else{
   for($i=1;$i<=4;$i++){
  ?>
        <a href="showpl.php?page=<?php echo $i;?>&spid=<?php echo $spid;?>&id=<?php echo $id;?>"><?php echo $i;?></a>
        <?php }?>
        <a href="showpl.php?page=<?php echo $page-1;?>&spid=<?php echo $spid;?>&id=<?php echo $id;?>" title="后一页"><font face="webdings"> 8 </font></a> <a href="editgoods.php?id=<?php echo $id;?>&page=<?php echo $pagecount;?>&spid=<?php echo $spid;?>&id=<?php echo $id;?>" title="尾页"><font face="webdings"> : </font></a>
        <?php }?>
          </div></td>
        </tr>
      </table></td>
  </tr>
</table>
<?php
include("bottom.php");
?>

支持(0)

反对(0)

首页上一页 1 下一页尾页 2 条记录 1/1页