Online PHP editor | output for peLqP

@ 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 7.1.0 - 7.1.25, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.33, 8.2.0 - 8.2.29, 8.3.0 - 8.3.28, 8.4.1 - 8.4.14, 8.5.0 - 8.5.1: 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);
Output for 8.4.15: /bin/php-8.4.15: /usr/lib/libm.so.6: version `GLIBC_2.38' not found (required by /bin/php-8.4.15) /bin/php-8.4.15: /usr/lib/libm.so.6: version `GLIBC_2.35' not found (required by /bin/php-8.4.15) /bin/php-8.4.15: /usr/lib/libc.so.6: version `GLIBC_2.34' not found (required by /bin/php-8.4.15) /bin/php-8.4.15: /usr/lib/libc.so.6: version `GLIBC_2.38' not found (required by /bin/php-8.4.15)
Process exited with code 1.

preferences:dark modelive previewkey bindings