<<< Previous question <<< Question ID#0560.md >>> Next question >>>
Consider the following script:
try {
$dbh = new PDO("sqlite::memory:");
} catch(PDOException $e) {
print $e->getMessage();
}
$dbh->query("CREATE TABLE foo(id INT)");
$stmt = $dbh->prepare("INSERT INTO foo VALUES(:value)");
$value = null;
$data = array(1,2,3,4,5);
$stmt->bindParam(":value", $value);
/* ?????? */
try {
foreach($data as $value) {
/* ????? */
}
} catch(PDOException $e) {
/* ??????? */
}
/* ?????? */What lines of code need to go into the missing places above in order for this script to function properly and insert the data into the database safely?
- A) $dbh->beginTransaction();
- B) $dbh->commit();
- C) $stmt->execute();
- D) $dbh->rollback();
Answer
Answer: A, B, C, D