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

Question

Hye guys,

I really need help .. I manage to submit this value into DB but it only submit one, not all values. Below I attached the example. I had enter dd, 55 but in DB only received 55

Here is what i have done. I have this html textarea : <td><textarea class="form-control" name="d3_CA[]"></textarea></td>

Then when I click on submit button this how i handle :

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..";
  }

it show correct value when i'm echoing. Then i want to submit it into DB, this what i do :

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;
    }   
}

Exprator · Accepted Answer · 2017-08-04 04:05:10Z

2

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..";
  }
 }

}

the problem is at the end one value is being stored in $report->d3_CA, and the echo prints the correct result is because its inside the loop, print it outside and you will get the last value only, so use the above code and it will solve your problem

answered Aug 4, 2017 at 4:05

Exprator

27.8k6 gold badges54 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

user1909310 Over a year ago

Exprator ; you means like this ? foreach($_POST['d3_CA'] as $value) { $report->d3_CA = $value; } echo $report->d3_CA;

user1909310 Over a year ago

if i echo outside the foreach it still store only one value inside DB

user1909310 Over a year ago

Nice Exprator ! manage to submit it ! you saved my day man ! thank you

Exprator Over a year ago

glad could help bro :)

user1909310 Over a year ago

Exprator , now i having this problem .. i'm using your code and change it to this, because i have another textarea/field. When I insert on 1st row -"a b" , 2nd row "c d". When i check in DB i saved like this 1st row "a d", 2nd row "c d" which is not correct. foreach($_POST['d3_CA'] as $valueX){ $report->d3_CA = $valueX; foreach ($_POST['d3_Resp'] as $key => $valueA) { $report->d3_Resp = $valueA; } $report->registerD3(); }

Collectives™ on Stack Overflow

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

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related