3v4l.org

run code in 300+ PHP versions simultaneously

sponsor
bughunt
search
recent
about

@ 2018-10-07T11:35:59Z

<?php
$ym = date('Y-m-');
$derived_table = '';
for ($d = 1, $end = date('t'); $d <= $end; ++$d) {
    $date = $ym . str_pad($d, 2, 0, STR_PAD_LEFT);
    if ($d == 1) {
        $derived_table .= "SELECT '$date' AS event_date_start";
    } else {
        $derived_table .= " UNION SELECT '$date'";
    }
}

echo $derived_table;

Output
Performance
VLD
References
Branches

date: documentation ( source)
str_pad: documentation ( source)

preferences:dark modelive previewkey bindings

21.85 ms | 405 KiB | 5 Q