Online PHP editor | rfc for qN22D

@ 2014-11-03T18:46:44Z

<?php

function expandArguments(&$query, &$args) {
    $modified = FALSE;
    foreach (array_filter($args, 'is_array') as $key => $data) {
        $new_keys = array();
var_dump($data);
        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;
}


function expandArguments2(&$query, &$args) {
    $modified = FALSE;
    foreach (array_filter($args, 'is_array') as $key => $data) {
        $new_keys = array();
var_dump($data);

        foreach (array_values($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 = array(
    'ids' => array(
        1,
        2,
        '0); DROP TABLE foo; --' => 3
    )
);
expandArguments($query, $args);

var_dump($query, $args);

$query = "SELECT * FROM foo WHERE id IN (:ids)";
$args = array( 'ids' => array(
	1,
2,
'0); DROP TABLE foo; --' => 3
) );

expandArguments2($query, $args); 
var_dump($query, $args);

Output for git.master, git.master_jit, rfc.property-hooks: array(3) { [0]=> int(1) [1]=> int(2) ["0); DROP TABLE foo; --"]=> int(3) } string(73) "SELECT * FROM foo WHERE id IN (:ids_0, ids_1, ids_0); DROP TABLE foo; --)" array(3) { ["ids_0"]=> int(1) ["ids_1"]=> int(2) ["ids_0); DROP TABLE foo; --"]=> int(3) } array(3) { [0]=> int(1) [1]=> int(2) ["0); DROP TABLE foo; --"]=> int(3) } string(52) "SELECT * FROM foo WHERE id IN (:ids_0, ids_1, ids_2)" array(3) { ["ids_0"]=> int(1) ["ids_1"]=> int(2) ["ids_2"]=> int(3) }

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

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 preview