| <?php | <?php |
| function getServiceOverride() { | function getServiceOverride($date="") { |
| global $conn; | global $conn; |
| $query = "Select * from calendar_dates where date = :date and exception_type = '1' LIMIT 1"; | $query = "Select * from calendar_dates where date = :date and exception_type = '1' LIMIT 1"; |
| debug($query,"database"); | debug($query,"database"); |
| $query = $conn->prepare($query); // Create a prepared statement | $query = $conn->prepare($query); // Create a prepared statement |
| $query->bindParam(":date", date("Ymd")); | $query->bindParam(":date", date("Ymd",($date != "" ? $date : time()))); |
| $query->execute(); | $query->execute(); |
| if (!$query) { | if (!$query) { |
| databaseError($conn->errorInfo()); | databaseError($conn->errorInfo()); |
| return Array(); | return Array(); |
| } | } |
| return $query->fetch(PDO::FETCH_ASSOC); | return $query->fetch(PDO::FETCH_ASSOC); |
| } | } |
| ?> | ?> |