dongzhun4898 2013-09-19 10:36
浏览 153
已采纳

PHP表单中的数据被多次插入到mysql数据库中

I'm pretty new in PHP and MYSQL. I've got this form that I use to enter data into a database I created. I add up values from two fields in separate columns and insert the value into a third column (TOTAL_IN). Then I subtract another value (VALUE3) that's in another field from the value in a field in the third column (TOTAL_IN) and put that value in a different column. All these are in the same table. It works just fine, but the problem is that when I open up my database I see that the data has been inserted 20 or 100 times! How can I stop the data from being inserted so many times?

Please note that the submit button was clicked only once.

Here is what I use:

$sql="INSERT INTO $tbl_name (id, date, value1, value2, total_in, value3, value4)
      SELECT '','$date','$value1','$value2',('$value1'+'$value2') AS SUM,
              '$value3',(('$value1'+'$value2')-$value3) AS SUM
      FROM $tbl_name";
$result=mysql_query($sql);

any help?

Thanks in advance!

EDIT::: Here is what my code looks like now after your suggestions:

//From Ruddy's post
$total_in=$value1+$value2;
$value4=($value1+$value2)-$value3;

//From Amit's post
$sql="INSERT INTO $tbl_name(id, date, value1, value2, total_in, value3, value4) VALUES ('', '.$date.', '.$value1.', '.$value2.', '.$total_in.', '.$value3.', '.$value4.')";
$result=mysqli_query($sql);

it works but it still enters the data many times.

  • 写回答

3条回答 默认 最新

  • dongsiju1941 2013-09-19 10:44
    关注
    $sql="INSERT INTO $tbl_name (id, date, value1, value2, total_in, value3, value4)
     VALUES( '', '".$date."', ".$value1.", ".$value2.", ".$value1+$value2.", 
    ".$value3.",".$value1+$value2-$value4.")";
    $result=mysql_query($sql);
    

    You need to concatenate the variables in php while writing in the query please see the syntax.

    see here

    What you were doing was select all the rows of the table and inserting into all.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥18 深度学习tensorflow1,ssdv1,coco数据集训练一个模型
  • ¥100 关于注册表摄像头和麦克风的问题
  • ¥30 代码本地运行正常,但是TOMCAT部署时闪退
  • ¥15 关于#python#的问题
  • ¥15 主机可以ping通路由器但是连不上网怎么办
  • ¥15 数据库一张以时间排好序的表中,找出多次相邻的那些行
  • ¥50 关于DynamoRIO处理多线程程序时候的问题
  • ¥15 kubeadm部署k8s出错
  • ¥15 Abaqus打不开cae文件怎么办?
  • ¥15 小程序准备上线,软件开发公司需要提供哪些资料给甲方