PHP PDO OOP : Why only one value is being send/insert into MySQL?

Question

大家好，

我真的需要帮助.. 我设法将这个值提交到数据库中，但它只提交一个值，而不是所有值。下面我附上了例子。我已经输入 dd, 55 但在 DB 中只收到 55

这是我所做的。我有这个 html 文本区域: <td><textarea class="form-control" name="d3_CA[]"></textarea></td>

然后当我点击提交按钮时我是这样处理的:

if(isset($_POST['save-report'])){
 foreach($_POST['d3_CA'] as $value)
 {
  $report->d3_CA = $value;
  echo $report->d3_CA;
 }

}

if($report->registerD3()){

  $successMSG ="Success ! Report <span style='color:red;'>" 
  .$_POST['reportNo']. "</span> has been created. ";
  }
  else{
    $errMSG = "Opps ! problem..";
  }

当我回应时它显示正确的值。然后我想将它提交到数据库中，这就是我所做的:

function registerD3(){
    $query2 = "INSERT INTO " . $this->table_d3 . "
            SET d3_CA=:d3_CA";

    $stmt = $this->conn->prepare($query2);

    $stmt->bindParam(":d3_CA", $this->d3_CA);
    echo $this->d3_CA;
    if($stmt->execute()){
        return true;
    }
    else{
        return false;
    }   
}

Answer 1

if(isset($_POST['save-report'])){
 foreach($_POST['d3_CA'] as $value)
 {
  $report->d3_CA = $value;
  echo $report->d3_CA;
if($report->registerD3()){

  $successMSG ="Success ! Report <span style='color:red;'>" 
  .$_POST['reportNo']. "</span> has been created. ";
  }
  else{
    $errMSG = "Opps ! problem..";
  }
 }

}

问题是最后一个值存储在$report->d3_CA中，回显打印正确的结果是因为它在循环内部，在外部打印它，你会得到只有最后一个值，所以使用上面的代码，它会解决你的问题