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 git.master, git.master_jit, rfc.property-hooks: INSERT INTO table1 (a, b, c) VALUES (?, ?, ?) Array ( [0] => ValueA [1] => ValueB [2] => ValueC )

This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.

Active branches

Archived branches

Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page

2022-12-01 RFC: Property hooks - included in PHP 8.4
2020-03-21 RFC: Is_Literal - declined
2020-12-04 Enumerations - included in PHP 8.1
2018-06-15 Typed Properties v2 - implemented in PHP 7.4
2016-08-12 Object typehint - included in PHP 7.2
2016-08-14 Arrow functions - withdrawn
2016-05-29 array_change_keys() - withdrawn
2016-04-19 Lexical scope support for anonymous classes - suspended
2016-04-17 Functional Interfaces - declined
2016-03-16 Typed Properties - superseded in favor of Typed Properties 2.0
2015-08-27 Callable Prototypes - declined
2015-05-01 Short Closures - declined / withdrawn in favor of Arrow Functions
2015-02-18 Scalar type hints v5 - included in PHP 7
2015-02-14 Union Types - declined
2013-09-22 Anonymous classes - included in PHP 7

preferences:dark modelive previewkey bindings

190.82 ms | 405 KiB | 5 Q