3v4l.org

run code in 300+ PHP versions simultaneously

@ 2021-03-05T15:33:54Z

<?php

/**
 * @return mixed[] An array containing two elements: the modified SQL query (string), and the modified params (array).
 */
function unnameSqlParameters(string $sql, array $params): array
{
    $newParams = [];

    $newSql = preg_replace_callback(
        '/:(\w+)/',
        static function (array $matches) use ($params, &$newParams): string {
            $name = $matches[1];
            
            if (!array_key_exists($name, $params)) {
                throw new \RuntimeException("Cannot find parameter value for :{$name}.");
            }
            
            $newParams[] = $params[$name];

            return '?';
        },
        $sql
    );

    return [$newSql, $newParams];
}

[$sql, $params] = unnameSqlParameters(
    'INSERT INTO table1 (a, b, c) VALUES (:a, :b, :c)',
    ['a' => 'ValueA', 'c' => 'ValueC', 'b' => 'ValueB']
);

echo $sql, PHP_EOL;
print_r($params);

Output for 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.33, 8.2.0 - 8.2.29, 8.3.0 - 8.3.28, 8.4.1 - 8.4.14, 8.5.0 - 8.5.1: INSERT INTO table1 (a, b, c) VALUES (?, ?, ?) Array ( [0] => ValueA [1] => ValueB [2] => ValueC )
Output for 8.4.15: /bin/php-8.4.15: /usr/lib/libm.so.6: version `GLIBC_2.38' not found (required by /bin/php-8.4.15) /bin/php-8.4.15: /usr/lib/libm.so.6: version `GLIBC_2.35' not found (required by /bin/php-8.4.15) /bin/php-8.4.15: /usr/lib/libc.so.6: version `GLIBC_2.34' not found (required by /bin/php-8.4.15) /bin/php-8.4.15: /usr/lib/libc.so.6: version `GLIBC_2.38' not found (required by /bin/php-8.4.15)
Process exited with code 1.

preferences:dark modelive previewkey bindings

197.66 ms | 407 KiB | 5 Q