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条)

报告相同问题?

悬赏问题

  • ¥20 删除和修改功能无法调用
  • ¥15 kafka topic 所有分副本数修改
  • ¥15 小程序中fit格式等运动数据文件怎样实现可视化?(包含心率信息))
  • ¥15 如何利用mmdetection3d中的get_flops.py文件计算fcos3d方法的flops?
  • ¥40 串口调试助手打开串口后,keil5的代码就停止了
  • ¥15 电脑最近经常蓝屏,求大家看看哪的问题
  • ¥60 高价有偿求java辅导。工程量较大,价格你定,联系确定辅导后将采纳你的答案。希望能给出完整详细代码,并能解释回答我关于代码的疑问疑问,代码要求如下,联系我会发文档
  • ¥50 C++五子棋AI程序编写
  • ¥30 求安卓设备利用一个typeC接口,同时实现向pc一边投屏一边上传数据的解决方案。
  • ¥15 SQL Server analysis services 服务安装失败