Online PHP editor | rfc for MpCvF

@ 2014-10-28T10:58:20Z

<?php

class NamedInClause
{
    public $data;
    public $clause;

    public function __construct(array $array, $name = 'in') {
        $placeholders = 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++;
            $placeholders[] = ':' . $key;
            $this->data[$key] = $value;
        }

        $this->clause = implode(', ', $placeholders);
    }
}


$inClause = new NamedInClause([1, 2, 3], 'id');

// Build the query string
$query = "
  UPDATE table
  SET value1 = :val1, value2 = :val2
  WHERE id IN (" . $inClause->clause . ")
";

// Create the data array. Get an array of concrete values and merge the IN clause data
$data = array('val1' => 'Hello', 'val2' => 'World') + $inClause->data;

var_dump($query, $data);

/*
$stmt = $db->prepare($query);
$stmt->execute($data);
*/

Output for git.master, git.master_jit, rfc.property-hooks: 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) }

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