Online PHP editor | rfc for 2f7aV

@ 2025-10-17T14:05:56Z

<?php

error_reporting(E_ALL);
$db = new PDO("sqlite::memory:");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$queries = array(
    "CREATE TABLE users (
        userid INT PRIMARY KEY,
        name TEXT,
        country TEXT,
        referred_by_userid INT
    )",
    "INSERT INTO users
    (userid, name, country, referred_by_userid)
    VALUES (104, 'Chris', 'Ukraine', NULL)",
    "INSERT INTO users
    (userid, name, country, referred_by_userid)
    VALUES (105, 'Jamie', 'England', NULL)",
    "INSERT INTO users
    (userid, name, country, referred_by_userid)
    VALUES (107, 'Robin', 'Germany', 104)",
    "INSERT INTO users
    (userid, name, country, referred_by_userid)
    VALUES (108, 'Sean', 'Ukraine', NULL)",
    "INSERT INTO users
    (userid, name, country, referred_by_userid)
    VALUES (109, 'Toni', 'Germany', NULL)",
    "INSERT INTO users
    (userid, name, country, referred_by_userid)
    VALUES (110, 'Toni', 'Germany', NULL)",
    "INSERT INTO users
    (userid, name, country, referred_by_userid)
    VALUES (111, 'Sean', 'France', NULL)",
);

foreach ($queries as $query) {
    $db->exec($query);
}

$query = "SELECT userid, name, country, referred_by_userid FROM users";
$fetchMode = PDO::FETCH_COLUMN | PDO::FETCH_GROUP;

print "\nfetchAll (no column specified):\n";
$stmt = $db->query($query);
$result = $stmt->fetchAll($fetchMode);
print_r($result);

print "\nfetchAll (col 2):\n";
$stmt = $db->query($query);
$result = $stmt->fetchAll($fetchMode, 2);
print_r($result);

$query = "SELECT country, name, userid FROM users";

print "\nfetchAll (by country, no column specified):\n";
# Values are column 1, group is column 0
$stmt = $db->query($query);
$result = $stmt->fetchAll($fetchMode);
print_r($result);

print "\nfetchAll (by country, col 0):\n";
# Values are column 0, group is column 0
$stmt = $db->query($query);
$result = $stmt->fetchAll($fetchMode, 0);
print_r($result);

print "\nfetchAll (by country, col 1):\n";
# Values are column 0, group is column 0
$stmt = $db->query($query);
$result = $stmt->fetchAll($fetchMode, 1);
print_r($result);

print "\nfetchAll (by country, col 2):\n";
# Values are column 0, group is column 1
$stmt = $db->query($query);
$result = $stmt->fetchAll($fetchMode, 2);
print_r($result);

Output for git.master, git.master_jit, rfc.property-hooks: fetchAll (no column specified): Array ( [104] => Array ( [0] => Chris ) [105] => Array ( [0] => Jamie ) [107] => Array ( [0] => Robin ) [108] => Array ( [0] => Sean ) [109] => Array ( [0] => Toni ) [110] => Array ( [0] => Toni ) [111] => Array ( [0] => Sean ) ) fetchAll (col 2): Array ( [Ukraine] => Array ( [0] => 104 [1] => 108 ) [England] => Array ( [0] => 105 ) [Germany] => Array ( [0] => 107 [1] => 109 [2] => 110 ) [France] => Array ( [0] => 111 ) ) fetchAll (by country, no column specified): Array ( [Ukraine] => Array ( [0] => Chris [1] => Sean ) [England] => Array ( [0] => Jamie ) [Germany] => Array ( [0] => Robin [1] => Toni [2] => Toni ) [France] => Array ( [0] => Sean ) ) fetchAll (by country, col 0): Array ( [Ukraine] => Array ( [0] => Ukraine [1] => Ukraine ) [England] => Array ( [0] => England ) [Germany] => Array ( [0] => Germany [1] => Germany [2] => Germany ) [France] => Array ( [0] => France ) ) fetchAll (by country, col 1): Array ( [Chris] => Array ( [0] => Ukraine ) [Jamie] => Array ( [0] => England ) [Robin] => Array ( [0] => Germany ) [Sean] => Array ( [0] => Ukraine [1] => France ) [Toni] => Array ( [0] => Germany [1] => Germany ) ) fetchAll (by country, col 2): Array ( [104] => Array ( [0] => Ukraine ) [105] => Array ( [0] => England ) [107] => Array ( [0] => Germany ) [108] => Array ( [0] => Ukraine ) [109] => Array ( [0] => Germany ) [110] => Array ( [0] => Germany ) [111] => Array ( [0] => France ) )

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 previewkey bindings