<?php
$userIds = [1, 2, 3, 4, 5, 8, 2, 39, 298];
$userIdKeys = array_map(function ($index) {
return ":userId_{$index}";
}, range(0, count($userIds) - 1));
$userIds = array_combine($userIdKeys, $userIds);
$userIdKeyString = implode(', ', $userIdKeys);
$sql = "SELECT * FROM user WHERE userId IN ({$userIdKeyString});";
var_dump($sql, $userIds);
- Output for 5.4.0 - 5.4.45, 5.5.0 - 5.5.36, 5.6.0 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.20, 7.2.0 - 7.2.33, 7.3.12 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
- string(135) "SELECT * FROM user WHERE userId IN (:userId_0, :userId_1, :userId_2, :userId_3, :userId_4, :userId_5, :userId_6, :userId_7, :userId_8);"
array(9) {
[":userId_0"]=>
int(1)
[":userId_1"]=>
int(2)
[":userId_2"]=>
int(3)
[":userId_3"]=>
int(4)
[":userId_4"]=>
int(5)
[":userId_5"]=>
int(8)
[":userId_6"]=>
int(2)
[":userId_7"]=>
int(39)
[":userId_8"]=>
int(298)
}
- Output for 4.4.2 - 4.4.9, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29
- Parse error: syntax error, unexpected '[' in /in/CAl8e on line 3
Process exited with code 255. - Output for 4.3.0 - 4.3.1, 4.3.5 - 4.3.11, 4.4.0 - 4.4.1, 5.0.0 - 5.0.5
- Parse error: parse error, unexpected '[' in /in/CAl8e on line 3
Process exited with code 255. - Output for 4.3.2 - 4.3.4
- Parse error: parse error in /in/CAl8e on line 3
Process exited with code 255.
preferences:
254.72 ms | 401 KiB | 347 Q