3v4l.org

run code in 300+ PHP versions simultaneously

@ 2019-12-05T02:59:18Z

<?php

$metas = array(
    'key1' => 'value1',
    'key2' => 'value2',
    'key3' => 'value3'
);
$limit = 10;
$config = (object)array('recording_table' => 'recording', 'meta_table' => 'meta');
$join = array();
$params = array();
$types = '';
foreach ($metas as $key => $value) {
    $join[] = 'm.meta_key=? AND m.meta_value=?';
    $params[] = $key;
    $params[] = $value;
    $types .= 'ss';
}
// add the parameter for the `HAVING` check
$params[] = count($metas);
$types .= 'i';
// add the limit
$params[] = $limit;
$types .= 'i';
// make the query string
$sql = "SELECT recording_id 
        FROM {$config->recording_table} r
        JOIN {$config->meta_table} m ON m.recording_id = r.id
         AND (" . implode(' OR ', $join) . ")
        GROUP BY r.id
        HAVING COUNT(*) = ?
        LIMIT ?";
echo $sql . "\n";
print_r($params);
print_r($types);

Output for git.master, git.master_jit, rfc.property-hooks: SELECT recording_id FROM recording r JOIN meta m ON m.recording_id = r.id AND (m.meta_key=? AND m.meta_value=? OR m.meta_key=? AND m.meta_value=? OR m.meta_key=? AND m.meta_value=?) GROUP BY r.id HAVING COUNT(*) = ? LIMIT ? Array ( [0] => key1 [1] => value1 [2] => key2 [3] => value2 [4] => key3 [5] => value3 [6] => 3 [7] => 10 ) ssssssii

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

181.15 ms | 406 KiB | 5 Q