如何将数组插入带有PHP和PDO的单个MySQL Prepared语句中

您可以以编程方式构建查询…：

$sql = 'INSERT INTO table (memberID, programID) VALUES ';$insertQuery = array();$insertData = array();foreach ($data as $row) {    $insertQuery[] = '(?, ?)';    $insertData[] = $memberid;    $insertData[] = $row;}if (!empty($insertQuery)) {    $sql .= implode(', ', $insertQuery);    $stmt = $db->prepare($sql);    $stmt->execute($insertData);}