只需使用?
占位符创建查询文本,如下所示:
INSERT INTO table (firstName, lastName) VALUES (?, ?),(?, ?),(?, ?)
并执行它。示例代码可以是:
$data = ['Joe', 'Smith','Fred','Sampson','Lisa','Pearce'];
$placeholders = ['(?, ?)', '(?, ?)', '(?, ?)']; // but you should define this data according to your data
$query = 'INSERT INTO table (firstName, lastName) VALUES ' . implode(',', $placeholders);
$stmt = $dbh->prepare($query);
$stmt->execute($data);