<?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); |
} |
} |
?> |
?> |