Online PHP editor | refs for GQXNn

<?php $event_types = array('ea', 'ec'); $type_count = count($event_types); $evtypes = rtrim(str_repeat('?,', $type_count), ','); $query = <<<'QUERY' DELETE FROM events WHERE evtype IN($evtypes) AND cameraid = ? AND endtime < ? QUERY; $params['types'] = str_repeat('s', $type_count) . 'si'; $params += $event_types; var_export($query); var_export($params);