重复输入mysql数据库

问题描述：

i have a problem when inserting data to my database. but when i'm echoing it doesn't duplicate. here's my code:

    foreach($_POST['purpose'] as $i => $a){
         echo $a."-".$i."<br />";
         if($_POST['purpose'][$i] == "recieved"){
              $purpose[$i] = "'1','0','0','0','0'";
         } elseif($_POST['purpose'][$i] == "released"){
              $purpose[$i] = "'0','1','0','0','0'";
         } elseif($_POST['purpose'][$i] == "recalled"){
              $purpose[$i] = "'0','0','1','0','0'";
         } elseif($_POST['purpose'][$i] == "charges"){
              $purpose[$i] = "'0','0','0','1','0'";
         } elseif($_POST['purpose'][$i] == "adjustments"){
              $purpose[$i] = "'0','0','0','0','1'";
         }   
         $query = "INSERT INTO responsibility_center VALUES(
               '',
               '".$_POST['or_number']."',
               '".$_POST['response'][$i]."', 
               $purpose[$i])";
         echo $query."<br />";
         $result1 = mysql_query($query) or die(mysql_error()." inserting responsibility center");

          $responseid = mysql_insert_id();

          $query2 = "INSERT INTO particulars VALUES (
                     '',
                     '".$responseid."',
                     '".$_POST['details'][$i]."')";
          echo $query2."<br />";
          $result2 = mysql_query($query) or die(mysql_error()." inserting particulars");
    }

i dont know where in my code is wrong cause it doesn't give me errors. :/

将数据插入数据库时遇到问题。但是，当我回应它时，它不会重复。这是我的代码： p>

  foreach（$ _ POST ['purpose'] as $ i =＆gt; $ a）{
 echo $ a。“ - ”。$ i。  “＆lt; br /＆gt;”; 
 if（$ _ POST ['目的'] [$ i] ==“收到”）{
 $目的[$ i] =“'1'，'0'，'  0'，'0'，'0'“; 
} elseif（$ _ POST ['目的'] [$ i] ==”已发布“）{
 $目的[$ i] =”'0'，'  1'，'0'，'0'，'0'“; 
} elseif（$ _ POST ['目的'] [$ i] ==”召回“）{
 $目的[$ i] =”'  0'，'0'，'1'，'0'，'0'“; 
} elseif（$ _ POST ['目的'] [$ i] ==”收费“）{
 $目的[$ i  ] =“'0'，'0'，'0'，'1'，'0'”; 
} elseif（$ _ POST ['目的'] [$ i] ==“调整”）{
 $ 目的[$ i] =“'0'，'0'，'0'，'0'，'1'”; 
} 
 $ query =“INSERT INTO responsibility_center VALUES（
''，
'  “。$ _ POST ['or_number']。”'，
'“。$ _ POST ['response'] [$ i]。”'，
 $ purpose [$ i]）“; 
 echo $ query。  “＆lt; br /＆gt;”; 
 $ result1 = mysql_query（$ query）或die（mysql_error（）。“插入r 责任中心“）; 
 
 $ responseid = mysql_insert_id（）; 
 
 $ query2 =”INSERT INTO particulars VALUES（
''，
'“。$ responseid。”'，
'“。  $ _POST ['details'] [$ i]。“'）”; 
 echo $ query2。“＆lt; br /＆gt;”; 
 $ result2 = mysql_query（$ query）或die（mysql_error（）。“ 插入细节“）; 
} 
  code>  pre> 
 
 我不知道我的代码在哪里出错是因为它没有给我错误。  ：/  p> 
  div>

答

$result2 = mysql_query($query)

that should be

$result2 = mysql_query($query2)

This is why you should name your variables something more meaningful than $query. Please also read through this: http://bobby-tables.com/php.html

重复输入mysql数据库

相关推荐