3v4l.org

run code in 300+ PHP versions simultaneously
<?php function pdo_named_in_clause_from_array($array, $name = 'in') { $in = $data = array(); $i = 0; $name = preg_replace('/[^a-z0-9_]+/', '', (string)$name); if (!preg_match('/^[a-z]/i', $name)) { throw new \InvalidArgumentException('Placeholder name ' . $name . ': must begin with a letter'); } foreach ($array as $value) { $key = $name . $i++; $in[] = ':' . $key; $data[$key] = $value; } return array(implode(', ', $in), $data); } $inList = [1, 2, 3]; list($inClause, $inData) = pdo_named_in_clause_from_array($inList, 'id'); $query = " UPDATE table SET value1 = :val1, value2 = :val2 WHERE id IN (" . $inClause . ") "; $data = array('val1' => 'Hello', 'val2' => 'World') + $inData; var_dump($query, $data); /* $stmt = $db->prepare($query); $stmt->execute($data); */
Output for 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.38, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 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.4, 8.3.6
string(86) " UPDATE table SET value1 = :val1, value2 = :val2 WHERE id IN (:id0, :id1, :id2) " array(5) { ["val1"]=> string(5) "Hello" ["val2"]=> string(5) "World" ["id0"]=> int(1) ["id1"]=> int(2) ["id2"]=> int(3) }
Output for 8.3.5
Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 string(86) " UPDATE table SET value1 = :val1, value2 = :val2 WHERE id IN (:id0, :id1, :id2) " array(5) { ["val1"]=> string(5) "Hello" ["val2"]=> string(5) "World" ["id0"]=> int(1) ["id1"]=> int(2) ["id2"]=> int(3) }
Output for 5.3.0 - 5.3.29
Parse error: syntax error, unexpected '[' in /in/KtWlv on line 21
Process exited with code 255.
Output for 5.1.0 - 5.1.6, 5.2.0 - 5.2.17
Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /in/KtWlv on line 9 Parse error: syntax error, unexpected '[' in /in/KtWlv on line 21
Process exited with code 255.
Output for 5.0.0 - 5.0.5
Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /in/KtWlv on line 9 Parse error: parse error, unexpected '[' in /in/KtWlv on line 21
Process exited with code 255.
Output for 4.4.2 - 4.4.9
Parse error: syntax error, unexpected T_NEW in /in/KtWlv on line 9
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
Parse error: parse error, unexpected T_NEW in /in/KtWlv on line 9
Process exited with code 255.
Output for 4.3.2 - 4.3.4
Parse error: parse error in /in/KtWlv on line 9
Process exited with code 255.
preferences:
239.03 ms | 401 KiB | 451 Q