public static function get_day_timeunits_admin($date) { global $DB; $sql = ' SELECT * FROM timeunits WHERE date=:date '; $sth = $DB->prepare($sql); $sth->bindParam(':date', $date, PDO::PARAM_STR); $sth->execute(); $ret = array(); foreach ($sth->fetchAll() as $tmp) { $timeunit = new TimeUnit($tmp, false); if (!is_array($ret[$timeunit->court_id])) { $ret[$timeunit->court_id] = array(); } $ret[$timeunit->court_id] += $timeunit->in_array_of_times(); } return $ret; }