将数组插入mysql数据库

Question

这需要向数据库添加多行，但它只添加数组中的第一个问题。有什么想法吗？

function addNewApp($question, $type, $username, $servername){  
      $time = time();  
      $q  = "INSERT INTO ".TBL_APPLICATIONS." VALUES ('0', '$username', '$servername', '', $time)";  
      if(mysql_query($q, $this->connection)){  
            return true;  
          }else{  
            return false;    
          }  
      for ($x=0; $x<count($question); $x++) {  
        $q2 = "INSERT INTO ".TBL_QUESTIONS." SET   `text`='".mysql_real_escape_string($question[$x])."', `id`='0', `servername`='$servername', `type`='$type[$x]'";  
          if(mysql_query($q2, $this->connection)){  
            return true;  
          }else{  
            return false;  
          }  
      }  
   }

Answer 1

您将在循环中返回true。

if(mysql_query($q2, $this->connection)){
   return true;
}

return语句结束您的函数，也结束您的循环。所以我会这样做：

if(!mysql_query($q2, $this->connection)){ //if correct, don't do anything
   echo "THERE WAS AN ERROR"; // or whatever sort of error reporting
}