3v4l.org

run code in 300+ PHP versions simultaneously

@ 2023-08-07T08:13:28Z

<?php

$config['sql_query_logging'] = [
    'enabled' => true,
    'exclusions' => [
        'tables' => ['ci_sessions', 'system_log', 'jobs_log', 'error_log'],
        'keywords' => ['select', 'show tables']
    ]
];

$sqls = [
    'select * from table',
    'show tables',
    'update ci_sessions set some_col = some_val',
    'update test set some_col = some_val',
    'insert into test values(23, 45)',
    'insert into ci_sessions values(1,2,3)',
    'truncate ci_sessions'
];

foreach($sqls as $sql){
    $result = array_merge(
            array_filter($config['sql_query_logging']['exclusions']['keywords'], fn($v) => preg_match('/\b'.$v.'\b/', $sql) === 1),
            array_filter($config['sql_query_logging']['exclusions']['tables'], function($table) use ($sql){
                return preg_match('/\b(from|insert into|update|join|truncate|table)\s+'.$table.'\b/', $sql) === 1;
            })
         );
    if(empty($result)){
        echo "Can log: ", $sql, PHP_EOL;
        // log here
    }else{
        echo "Cannot log: ", $sql, PHP_EOL;
    }
}

Output for git.master_jit, git.master, rfc.property-hooks: Cannot log: select * from table Cannot log: show tables Cannot log: update ci_sessions set some_col = some_val Can log: update test set some_col = some_val Can log: insert into test values(23, 45) Cannot log: insert into ci_sessions values(1,2,3) Cannot log: truncate ci_sessions

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

104.76 ms | 406 KiB | 5 Q