Online PHP editor | rfc for XAvnb

@ 2019-03-05T18:41:39Z

<?php

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

$pdo->exec("DROP TABLE IF EXISTS prefs");
$pdo->exec("CREATE TABLE prefs(
	        uid MEDIUMINT UNSIGNED NOT NULL,
            show_email BOOL NOT NULL,
            show_smiles BOOL NOT NULL,
            timezone_offset TINYINT NOT NULL,
            messages_on_page TINYINT UNSIGNED NOT NULL)");

// Insert first row
$pdo->exec("INSERT INTO prefs VALUES(6, 1, 1, 0, 5)");

// Update row with id = 6
$prefs = array(
	'show_email' => (bool) 1,
	'show_smiles' => (bool) 1,
	'timezone_offset' => 0,
	'messages_on_page' => 999,
	'uid', 6
);

$st = $pdo->prepare("UPDATE prefs SET show_email=?, show_smiles=?, timezone_offset=?, messages_on_page=? WHERE uid=?");
$st->bindValue(1, $prefs['show_email'], PDO::PARAM_BOOL);
$st->bindValue(2, $prefs['show_smiles'], PDO::PARAM_BOOL);
$st->bindValue(3, $prefs['timezone_offset'], PDO::PARAM_INT);
$st->bindValue(4, $prefs['messages_on_page'], PDO::PARAM_INT);

$id = 6;
$st->bindParam(5, $id, PDO::PARAM_INT); 


if (!$st->execute()) {
    print_r($pdo->errorInfo());
    exit;
}

$statement = $pdo->prepare('SELECT * FROM prefs');
$statement->execute();

print_r($statement->fetchAll(PDO::FETCH_ASSOC));

Output for git.master, git.master_jit, rfc.property-hooks: Array ( [0] => Array ( [uid] => 6 [show_email] => 1 [show_smiles] => 1 [timezone_offset] => 0 [messages_on_page] => 999 ) )

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