php PDO update multiple records at a time

Asked Jan 03 '19 at 10:21

Active Jan 03 '19 at 10:50

Viewed 67 times

I'm trying to update mulitple records at a time with pdo. When i execute the script no error shows up, but the records in the database not get updated

require_once('../connect.php');
$data= json_decode(file_get_contents("php://input"));

$collective_answer=($data->answers);
$sme_id=($data->sme_id);

foreach ((array) $collective_answer as $t) {
    $answer= $t ->answer;
    $quest_id= $t ->quest_id;
    $sme_id= $t ->sme_id;
    $tdate= $t ->tdate;

    $stmt = $conn->prepare("UPDATE sme 
                SET sme_answer=:sme_answer,
                    date_answer_sme=:date_answer_sme
                WHERE question_id=:question_id");

    $stmt->execute(array("sme_answer" => $answer,
                         "date_answer_sme" => $tdate,
                         "question_id" => $quest_id));
}

edited Jan 03 '19 at 10:50

Nigel Ren

56,122
11
43
55

asked Jan 03 '19 at 10:21

developer

1

'sme_answer' (etc.) should be ':sme_answer' – treyBake Jan 03 '19 at 10:23
Did you check error reporting was set ON – RiggsFolly Jan 03 '19 at 10:26
Maybe it would help to see a `print_r($collective_answer);` – RiggsFolly Jan 03 '19 at 10:27
And did you set [ATTR_ERRMODE](https://stackoverflow.com/questions/32648371/my-pdo-statement-doesnt-work) on the PDO Connection – RiggsFolly Jan 03 '19 at 10:29
1

@treyBake - they are optional in the `execute()` - https://stackoverflow.com/questions/17386469/pdo-prepared-statement-what-are-colons-in-parameter-names-used-for – Nigel Ren Jan 03 '19 at 10:43
1

You should move the `prepare()` outside the loop as this is only required to be run once. – Nigel Ren Jan 03 '19 at 10:44
@NigelRen hot damn! Learn something new everyday – treyBake Jan 03 '19 at 10:51

php PDO update multiple records at a time

0 Answers0