Online PHP editor | rfc for AbcAR

@ 2019-01-07T00:39:04Z

<?php

$db = new PDO('sqlite::memory:');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);

$db->exec('CREATE TABLE example (name TEXT, vals TEXT);');
$insert = $db->prepare('INSERT INTO example (name, vals) VALUES (?, ?)');
$insert->execute(array('row1', '1,3,4'));
$insert->execute(array('row2', '1'));
$insert->execute(array('row3', '5,6'));


function csv_intersection($vals, $search) {
    $vals_array   = explode(',', $vals);
    $search_array = explode(',', $search);
    $intersection = array_intersect($vals_array, $search_array);
    return implode(',', $intersection);
}
$db->sqliteCreateFunction('intersection', 'csv_intersection', 2);

$stmt = $db->prepare('SELECT name, vals FROM example WHERE intersection(vals, ?)');
$stmt->execute(array('1,2,3'));
foreach ($stmt as $row) {
    var_dump($row);
}

Output for git.master, git.master_jit, rfc.property-hooks: array(2) { ["name"]=> string(4) "row1" ["vals"]=> string(5) "1,3,4" } array(2) { ["name"]=> string(4) "row2" ["vals"]=> string(1) "1" }

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