3v4l.org

run code in 300+ PHP versions simultaneously

@ 2018-08-07T20:55:31Z

<?php
$json = "{
    \"Data 1\": {
        \"Text1\": \"Anything1\",
        \"Text2\": \"Anything2\"
    },
    \"Data 2\": {
        \"2018-08-02\": {
            \"1.\": \"145\",
            \"2.\": \"258\"
        },
        \"2018-08-03\": {
            \"1.\": \"428\",
            \"2.\": \"528\"
        },
        \"2018-08-04\": {
            \"1.\": \"727\",
            \"2.\": \"514\"
        }
    }
}";

$jsonDecoded = json_decode($json, true);
foreach ($jsonDecoded['Data 2'] as $dateKey => $data) {
    //$values = '';
    //foreach ($data as $datum) {
    //    $values .= $datum . ',';
    //} 
    $values = implode(',', $data);
    $statement = "INSERT INTO mytable (TheDate, Value1, Value2) VALUES ('{$dateKey}'," . $values . ");";
    echo $statement . PHP_EOL;
}

Output for git.master_jit, git.master, rfc.property-hooks: INSERT INTO mytable (TheDate, Value1, Value2) VALUES ('2018-08-02',145,258); INSERT INTO mytable (TheDate, Value1, Value2) VALUES ('2018-08-03',428,528); INSERT INTO mytable (TheDate, Value1, Value2) VALUES ('2018-08-04',727,514);

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

24.62 ms | 406 KiB | 5 Q