＋设为首页 ＋添加到收藏夹
-------guanli.php-----------
<?php
session_start();
if ( ! session_is_registered(fg34op) ) header("location:error.php");
//session_register(fg34op);
function sqlstr($data)
{
$temp="".ereg_replace("","",$data)."" ;
return ($temp);
}
$mysql_link=mysql_connect("localhost","root");
mysql_select_db("zhtry",$mysql_link);
$sql="select * from commend order by id desc limit 10";
$result=mysql_query($sql,$mysql_link);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>管理页面</title>
</head>
<body>
<table width="400" height="178" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="178" valign="top"><table width="400" height="178" border="0" cellpadding="1" cellspacing="1" bgcolor="#009933">
<tr bgcolor="#B7F986">
<td height="25" colspan="5"><div align="center">管理页面</div></td>
</tr>
<form name="form1" method="post" action="signup.php">
<tr bgcolor="#EFFFEF">
<td width="120" align="center" bgcolor="#EFFFEF"><div align="center"><font size="2">日期</font></div></td>
<td bgcolor="#EFFFEF"><div align="center"><font size="2">摘要</font>
</div></td>
<td bgcolor="#EFFFEF"><div align="center"><font size="2">开户行</font></div></td>
<td bgcolor="#EFFFEF"><div align="center"><font size="2">帐号</font></div></td>
<td bgcolor="#EFFFEF"><div align="center"><font size="2">金额</font></div></td>
</tr>
<tr bgcolor="#EFFFEF">
<td height="18" align="center"><font size="2">
<input name="date[0]" type="text">
</font></td>
<td bgcolor="#EFFFEF"> <input name="summary[0]" type="text"></td>
<td bgcolor="#EFFFEF"><input name="bank[0]" type="text"></td>
<td bgcolor="#EFFFEF"><input name="account[0]" type="text"></td>
<td bgcolor="#EFFFEF"><input name="money[0]" type="text"></td>
</tr>
<tr bgcolor="#EFFFEF">
<td height="18" align="center"><font size="2">
<input name="date[1]" type="text">
</font></td>
<td><input name="summary[1]" type="text"> </td>
<td><input name="bank[1]" type="text"></td>
<td><input name="account[1]" type="text"></td>
<td><input name="money[1]" type="text"></td>
</tr>
<tr bgcolor="#EFFFEF">
<td height="18" align="center"><font size="2">
<input name="date[2]" type="text">
</font></td>
<td><input name="summary[2]" type="text"> </td>
<td><input name="bank[2]" type="text"></td>
<td><input name="account[2]" type="text"></td>
<td><input name="money[2]" type="text"></td>
</tr>
<tr bgcolor="#EFFFEF">
<td height="18" align="center"><font size="2">
<input name="date[3]" type="text">
</font></td>
<td><input name="summary[3]" type="text"> </td>
<td><input name="bank[3]" type="text"></td>
<td><input name="account[3]" type="text"></td>
<td><input name="money[3]" type="text"></td>
</tr>
<tr bgcolor="#EFFFEF">
<td height="17" align="center"> <div align="center"><font size="2">
<input name="date[4]" type="text">
</font></div></td>
<td height="17" align="center"><input name="summary[4]" type="text"></td>
<td height="17" align="center"><input name="bank[4]" type="text"></td>
<td height="17" align="center"><input name="account[4]" type="text"></td>
<td height="17" align="center"><input name="money[4]" type="text"></td>
</tr>
<tr bgcolor="#EFFFEF">
<td height="18" colspan="5" align="center"> <input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重写"> </td>
</tr>
</form>
</table></td>
</tr>
</table>
<table width="400" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table width="650" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="1" bgcolor="#009933"></td>
</tr>
</table>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table width="75%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="749" height="46" valign="top"><table width="743" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#9ED191">
<tr align="center" bgcolor="#B7F986">
<td width="98" height="25"><font size="2">日期</font></td>
<td width="86" height="25"><font size="2">摘要</font></td>
<td width="146" height="25"><font size="2">开户行</font></td>
<td width="174" height="25" bgcolor="#B7F986"><font size="2">帐号</font></td>
<td width="146" height="25"><font size="2">金额</font></td>
<td height="25" colspan="2"><font size="2"></font></td>
</tr>
<?php
while($rowa=mysql_fetch_array($result))
{ ?>
<tr align="center" bgcolor="#EFFFEF">
<td height="9"><?php print($rowa["date"]);?></td>
<td><?php print($rowa["summary"]);?></td>
<td><?php print($rowa["bank"]);?></td>
<td><?php print($rowa["account"]);?></td>
<td><?php print($rowa["money"]);?></td>
<td width="44"><font size="2"><a href=changenote.php?changeid=<?php print($rowa["id"]);?>>编辑</a></font></td>
<td width="41"><font size="2"><a href=delenote.php?deleid=<?php print($rowa["id"]);?>>删除</a></font></td>
</tr>
<?php }?>
</table></td>
</tr>
</table>
</body>
</html>
--------signup.php-------------
<?php
function sqlstr($data)
{
$temp="".ereg_replace("","",$data)."" ;
return ($temp);
}
$mysql_link=mysql_connect("localhost","root");
mysql_select_db("zhtry",$mysql_link);
for($i=0;$i<=4;$i++)
{
$date=ereg_replace("<"," ",$date[$i]);
$summary=ereg_replace("<"," ",$summary[$i]);
$bank=ereg_replace("<"," ",$bank[$i]);
$account=ereg_replace("<"," ",$account[$i]);
$money=ereg_replace("<"," ",$money[$i]);
$sql="insert into commend (date,summary,bank,account,money) values(";
$sql=$sql.sqlstr($date).",";
$sql=$sql.sqlstr($summary).",";
$sql=$sql.sqlstr($bank).",";
$sql=$sql.sqlstr($account).",";
$sql=$sql.sqlstr($money).")";
//print($sql);
mysql_query($sql,$mysql_link);
}
header("location:guanli.php");
?>
--------------
现在我一条一条记录提交，可以连上数据库，可是我现在想一次行提交多条记录，
我总是改不成功，如何修改以上代码，可以一次提交多条记录到数据库，并且正确显示到
页面？如何做这个循环？
谢谢！
帮你顶一下！关注
如下试试：
for($i=0;$i<=4;$i++)
{
$date=ereg_replace("<"," ",$date[$i]);
$summary=ereg_replace("<"," ",$summary[$i]);
$bank=ereg_replace("<"," ",$bank[$i]);
$account=ereg_replace("<"," ",$account[$i]);
$money=ereg_replace("<"," ",$money[$i]);
$sql="insert into commend (date,summary,bank,account,money) values(";
$sql=$sql.sqlstr($date).",";
$sql=$sql.sqlstr($summary).",";
$sql=$sql.sqlstr($bank).",";
$sql=$sql.sqlstr($account).",";
$sql=$sql.sqlstr($money).")";
//print($sql);
mysql_query($sql,$mysql_link);
}
header("location:guanli.php");
?>
==>
$sql="insert into commend (date,summary,bank,account,money) values";
for($i=0;$i<=4;$i++)
{
if($i==0)$sql .= "(";
else $sql .= ",(";
$date=ereg_replace("<"," ",$date[$i]);
$summary=ereg_replace("<"," ",$summary[$i]);
$bank=ereg_replace("<"," ",$bank[$i]);
$account=ereg_replace("<"," ",$account[$i]);
$money=ereg_replace("<"," ",$money[$i]);
$sql=$sql.sqlstr($date).",";
$sql=$sql.sqlstr($summary).",";
$sql=$sql.sqlstr($bank).",";
$sql=$sql.sqlstr($account).",";
$sql=$sql.sqlstr($money).")";
$sql .= ")";
}
print($sql);
if(mysql_query($sql,$mysql_link))
header("location:guanli.php");
else echo "error!";
?>
还是不行啊！连不上数据库了！出现这种错误
insert into commend (date,summary,bank,account,money) values(21,32132,2321,323,2323)),(1,2,3,2,3)),(,,,,)),(,,,,)),(,,,,))error!
括号太乱,先把括号修正好,
另外建议提交时,采用数组
把name中间的数字全去掉在试试
如
</tr>
<tr bgcolor="#EFFFEF">
<td height="18" align="center"><font size="2">
<input name="date[0]" type="text">
</font></td>
<td bgcolor="#EFFFEF"> <input name="summary[0]" type="text"></td>
<td bgcolor="#EFFFEF"><input name="bank[0]" type="text"></td>
<td bgcolor="#EFFFEF"><input name="account[0]" type="text"></td>
<td bgcolor="#EFFFEF"><input name="money[0]" type="text"></td>
</tr>
==>
</tr>
<tr bgcolor="#EFFFEF">
<td height="18" align="center"><font size="2">
<input name="date[]" type="text">
</font></td>
<td bgcolor="#EFFFEF"> <input name="summary[]" type="text"></td>
<td bgcolor="#EFFFEF"><input name="bank[]" type="text"></td>
<td bgcolor="#EFFFEF"><input name="account[]" type="text"></td>
<td bgcolor="#EFFFEF"><input name="money[]" type="text"></td>
</tr>
