3v4l.org

run code in 300+ PHP versions simultaneously
<?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 for 4.3.0 - 4.3.11, 4.4.0 - 4.4.9, 5.0.0 - 5.0.5, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29, 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.34, 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.26, 8.4.1 - 8.4.13
SELECT '2021-05-01' AS event_date_start UNION SELECT '2021-05-02' UNION SELECT '2021-05-03' UNION SELECT '2021-05-04' UNION SELECT '2021-05-05' UNION SELECT '2021-05-06' UNION SELECT '2021-05-07' UNION SELECT '2021-05-08' UNION SELECT '2021-05-09' UNION SELECT '2021-05-10' UNION SELECT '2021-05-11' UNION SELECT '2021-05-12' UNION SELECT '2021-05-13' UNION SELECT '2021-05-14' UNION SELECT '2021-05-15' UNION SELECT '2021-05-16' UNION SELECT '2021-05-17' UNION SELECT '2021-05-18' UNION SELECT '2021-05-19' UNION SELECT '2021-05-20' UNION SELECT '2021-05-21' UNION SELECT '2021-05-22' UNION SELECT '2021-05-23' UNION SELECT '2021-05-24' UNION SELECT '2021-05-25' UNION SELECT '2021-05-26' UNION SELECT '2021-05-27' UNION SELECT '2021-05-28' UNION SELECT '2021-05-29' UNION SELECT '2021-05-30' UNION SELECT '2021-05-31'
preferences:
146.9 ms | 412 KiB | 5 Q