<?php
function expandArguments(&$query, &$args) {
$modified = FALSE;
foreach (array_filter($args, 'is_array') as $key => $data) {
$new_keys = array();
foreach ($data as $i => $value) {
$new_keys[$key . '_' . $i] = $value;
}
$query = preg_replace(
'#' . $key . '\b#',
implode(', ', array_keys($new_keys)),
$query
);
unset($args[$key]);
$args += $new_keys;
$modified = TRUE;
}
return $modified;
}
$query = "SELECT * FROM foo WHERE id IN (:ids)";
$args = [
'ids' => [
1,
2,
3,
]
];
$db->expandArguments($query, $args);
var_dump($db);
?>
preferences:
80.57 ms | 402 KiB | 5 Q