3v4l.org

run code in 300+ PHP versions simultaneously

@ 2015-04-17T09:07:36Z

<?php

$divisor = 60;
        $seconds = '00';

        $statement = "SELECT s.symbol,
                s.symbol64 symbol_id,
                s.multiply,
                s.currency,
                ((t.ctm - unix_timestamp(:date_begin)) DIV %s) as ctm_range,
                date_format(from_unixtime((substring_index(group_concat(cast(t.ctm AS CHAR) ORDER BY t.ctm), ',', 1))), '%%Y-%%m-%%dT%%H:%%i:%s') time,
                (trim(TRAILING '.' FROM(cast(trim(TRAILING '0' FROM
                    substring_index(group_concat(cast(t.bid AS CHAR) ORDER BY t.ctm), ',', 1)
                ) AS char)))) open,
                (trim(TRAILING '.' FROM(cast(trim(TRAILING '0' FROM
                    max(t.bid)
                ) AS char)))) high,
                (trim(TRAILING '.' FROM(cast(trim(TRAILING '0' FROM
                    min(t.bid)
                ) AS char)))) low,
                (trim(TRAILING '.' FROM(cast(trim(TRAILING '0' FROM
                    substring_index(group_concat(cast(t.bid AS CHAR) ORDER BY t.ctm DESC), ',', 1)
                ) AS char)))) close,
                round(avg(abs(t.bid * s.multiply - t.ask * s.multiply))) average_spread
            FROM ticks t
            JOIN symbols s ON s.symbol64 = t.symbol
            WHERE s.symbol = :symbol
              AND t.ctm BETWEEN unix_timestamp(:date_begin) AND unix_timestamp(:date_end)
            GROUP BY s.symbol, ctm_range
            ORDER BY t.ctm";

        $statement = sprintf($statement, $divisor, $seconds);
        echo $statement;

Output for git.master, git.master_jit, rfc.property-hooks: SELECT s.symbol, s.symbol64 symbol_id, s.multiply, s.currency, ((t.ctm - unix_timestamp(:date_begin)) DIV 60) as ctm_range, date_format(from_unixtime((substring_index(group_concat(cast(t.ctm AS CHAR) ORDER BY t.ctm), ',', 1))), '%Y-%m-%dT%H:%i:00') time, (trim(TRAILING '.' FROM(cast(trim(TRAILING '0' FROM substring_index(group_concat(cast(t.bid AS CHAR) ORDER BY t.ctm), ',', 1) ) AS char)))) open, (trim(TRAILING '.' FROM(cast(trim(TRAILING '0' FROM max(t.bid) ) AS char)))) high, (trim(TRAILING '.' FROM(cast(trim(TRAILING '0' FROM min(t.bid) ) AS char)))) low, (trim(TRAILING '.' FROM(cast(trim(TRAILING '0' FROM substring_index(group_concat(cast(t.bid AS CHAR) ORDER BY t.ctm DESC), ',', 1) ) AS char)))) close, round(avg(abs(t.bid * s.multiply - t.ask * s.multiply))) average_spread FROM ticks t JOIN symbols s ON s.symbol64 = t.symbol WHERE s.symbol = :symbol AND t.ctm BETWEEN unix_timestamp(:date_begin) AND unix_timestamp(:date_end) GROUP BY s.symbol, ctm_range ORDER BY t.ctm

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 preview

36.17 ms | 404 KiB | 8 Q