--- a/lib/common.inc.php +++ b/lib/common.inc.php @@ -92,7 +92,7 @@ } function ucsmart($str) { $shortWords = Array("The", "Pty", "Ltd", "Inc", "Red", "Oil", "A", "An", "And", "At", "For", "In" - , "Of", "On", "Or", "The", "To", "With"); + , "Of", "On", "Or", "The", "To", "With", "Use", "No", "Yes"); $strArray = explode(" ", preg_replace_callback("/(?<=(?<!:|’s)\W) (A|An|And|At|For|In|Of|On|Or|The|To|With) (?=\W)/", @@ -363,10 +363,15 @@ } function include_footer() { - global $start; + global $start, $conn; $end = (float) array_sum(explode(' ', microtime())); - echo '</div> <footer>' . "Processing time: " . sprintf("%.4f", ($end - $start)) . " seconds" . ' <footer>'; + $query = 'SELECT DATE("importDate") FROM contractnotice ORDER BY "importDate" DESC limit 1'; + $query = $conn->prepare($query); + $query->execute(); + databaseError($conn->errorInfo()); + $last_update = reset($query->fetchAll())[0]; + echo '</div> <footer>' . "Last updated: ".$last_update." Processing time: " . sprintf("%.4f", ($end - $start)) . " seconds" . ' <footer>'; if (strpos($_SERVER['SERVER_NAME'], ".gs")) { ?>