写了个PHP网站,但是每次只能添加一条信息,即只能添加和显示第一条数据,以后添加的数据都看不到;
代码如下:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>添加商品</title>
<link rel="stylesheet" type="text/css" href="css/font.css">
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
-->
</style>
</head>
<?php include("conn/conn.php");?>
<body topmargin="0" leftmargin="0" bottommargin="0">
<p> </p>
<table width="720" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="20" bgcolor="#0099FF"><div align="center" class="style1">添加商品</div></td>
</tr>
<tr>
<td height="253" bgcolor="#666666"><table width="720" border="0" cellpadding="0" cellspacing="0">
<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="savenewgoods.php" 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"></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 echo $i;?></option>
<?php
}
?>
</select>
年
<select name="yue" class="inputcss">
<?php
for($i=1;$i<=12;$i++)
{
?>
<option><?php echo $i;?></option>
<?php
}
?>
</select>
月
<select name="ri" class="inputcss">
<?php
for($i=1;$i<=31;$i++)
{
?>
<option><?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" >
元 会员价:
<input type="text" name="huiyuanjia" size="10" class="inputcss">
元</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 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 selected value="精品">精品</option>
<option value="一般">一般</option>
<option value="二手">二手</option>
<option value="淘汰">淘汰</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"></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"></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 selected value=1>是</option>
<option value=0>否</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"></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 type="file" name="upfile" class="inputcss" 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="80" rows="8" class="inputcss"></textarea>
</div></td>
</tr>
<tr>
<td height="25" colspan="2" bgcolor="#FFFFFF"><div align="center"><input name="submit" type="submit" class="buttoncss" id="submit" value="添加">
<input type="reset" value="重写" class="buttoncss"></div></td>
</tr>
</form>
</table></td>
</tr>
</table>
</body>
</html>
PHPMYSQL显示数据帮忙
代码如下:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>添加商品</title>
<link rel="stylesheet" type="text/css" href="css/font.css">
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
-->
</style>
</head>
<?php include("conn/conn.php");?>
<body topmargin="0" leftmargin="0" bottommargin="0">
<p> </p>
<table width="720" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="20" bgcolor="#0099FF"><div align="center" class="style1">添加商品</div></td>
</tr>
<tr>
<td height="253" bgcolor="#666666"><table width="720" border="0" cellpadding="0" cellspacing="0">
<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="savenewgoods.php" 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"></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 echo $i;?></option>
<?php
}
?>
</select>
年
<select name="yue" class="inputcss">
<?php
for($i=1;$i<=12;$i++)
{
?>
<option><?php echo $i;?></option>
<?php
}
?>
</select>
月
<select name="ri" class="inputcss">
<?php
for($i=1;$i<=31;$i++)
{
?>
<option><?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" >
元 会员价:
<input type="text" name="huiyuanjia" size="10" class="inputcss">
元</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 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 selected value="精品">精品</option>
<option value="一般">一般</option>
<option value="二手">二手</option>
<option value="淘汰">淘汰</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"></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"></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 selected value=1>是</option>
<option value=0>否</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"></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 type="file" name="upfile" class="inputcss" 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="80" rows="8" class="inputcss"></textarea>
</div></td>
</tr>
<tr>
<td height="25" colspan="2" bgcolor="#FFFFFF"><div align="center"><input name="submit" type="submit" class="buttoncss" id="submit" value="添加">
<input type="reset" value="重写" class="buttoncss"></div></td>
</tr>
</form>
</table></td>
</tr>
</table>
</body>
</html>
PHPMYSQL显示数据帮忙
解决方案 »
- 如何获取登录后跳转的网址,有点难度!!
- 新手问下这句正则什么意思?
- 为什么预览时不显示,数据库连接没问题。
- 頻繁使用數組跟file_get_contents是否會有CPU與內存有巨大影響
- php+mysql怎么实现一个简单的登录,注册功能(菜鸟路过)
- 用PHP mail()发邮件时,hotmail邮箱接收时附件大小为0KB,不能打开下载 。Gmail和Yahoo的邮箱能正常接收,用Dreammail能正常打开、下载附件,请大侠指点一二
- array_multisort数组排序问题,请看代码!
- 请问,关于PHP读XML数据
- 怎么获得字符串的机器码
- PHP使用静态方法和动态方法,在效率和资源上有何区别?
- 一下程序原本可以登录,为啥我加了自动登录部分(前面1-15行),系统检测不到用户资料后不显示登录界面出来,请帮忙看看,多谢了
- 验证码的一个类,怎么就是不出来图片呢
$sql=mysql_query("select * from tb_type order by id desc",$conn);
$info=mysql_fetch_array($sql);
if($info==false)
{
echo "请先添加商品类型!";
}while($info = mysql_fetch_array($sql)){}
138以下行重写么?最后得while替换到哪里 谢谢
目前的问题是 后台只能添加一条数据 以后再怎么添加都看不到,但是类别添加却可以看到savenewgoods.php
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<?php
include("conn/conn.php");
if(is_numeric($_POST[shichangjia])==false || is_numeric($_POST[huiyuanjia])==false)
{
echo "<script>alert('价格只能为数字!');history.back();</script>";
exit;
}
if(is_numeric($_POST[shuliang])==false)
{
echo "<script>alert('数量只能为数字!');history.back();</script>";
exit;
}
$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;
}
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);
if(trim($_FILES['upfile']['name']!=""))
{
$uploadfile="admin/".$uploadfile;
}
else
{
$uploadfile="";
}$jianjie=$_POST[jianjie];
$addtime=$nian."-".$yue."-".$ri;
mysql_query("insert into tb_shangpin(mingcheng,jianjie,addtime,dengji,xinghao,tupian,typeid,shichangjia,huiyuanjia,pinpai,tuijian,shuliang,cishu)values('$mingcheng','$jianjie','$addtime','$dengji','$xinghao','$uploadfile','$typeid','$shichangjia','$huiyuanjia','$pinpai','$tuijian','$shuliang','0')",$conn);
echo "<script>alert('商品".$mingcheng."添加成功!');window.location.href='addgoods.php';</script>";
?>savechangegoods.php
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<?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>";
?>conn.php<?php
$conn=mysql_connect("localhost","root","") or die("数据库服务器连接错误".mysql_error());
mysql_select_db("db_shop",$conn) or die("数据库访问错误".mysql_error());
mysql_query("set character set gb2312");
mysql_query("set names gb2312");
?>
我简单测试了一下应该没有问题的,是不是建表的primary key没有设置对?
表,我找到问题了 MYSQL的写入被禁用了 PHP.INI和MY.INI没有配置好