HV Podcasts
More public radio podcasts are at Current.org.
include("../inc/hv_foot.php") ?>
include_once("../inc/hvConfig.php"); include_once(includeFilesPath . "incStatusAndErrors.php"); include_once(includeFilesPath . "incClassDBConnect.php"); include_once(includeFilesPath . "incFunctions.php"); include_once(includeFilesPath . "incClasses.php"); include_once(includeFilesPath . "incHVStoriesCache.php"); include_once(includeFilesPath . "incTestFunctions.php"); try { // Create a new instance of the DBConnection class $dbConnRead = new DBConnection(); // Open the connection if ($dbConnRead->Open($server, $readUser, $readUserPwd, $db)) { // Provide some status infor $statusStr .= SAE_FormatStatusMessage("server connect", "Connected to server"); } else { // If something went wrong, report it throw new Exception($dbConnRead->errorMessage); } // Get various recordsets needed to build page... /***** podcasts *****/ // Declare recordset var $storyIDRecordset = null; // If everything's okay, define our query $queryStr = "SELECT storyID FROM `casts` WHERE storyTypeID = 10 ORDER BY `airdate` DESC"; // Check to see that the query was properly processed if($storyIDRecordset = $dbConnRead->Command($queryStr)) { // Report on the query's status (query string will be truncated) $statusStr .= SAE_FormatStatusMessage($queryStr, "okay"); } else { // If there was an error, report that and stop execution in the try-catch block throw new Exception($dbConnRead->errorMessage); } } catch(Exception $err) { $errorStr .= SAE_FormatErrorMessage( "database error", $err); } // Classification of stories - default is "all" $classification = "Podcasts"; // Get stories collection from cache $stories = readCachedData(hvStoriesDataFile); // Get total stories count from collection $storyCount = count($stories); $statusStr .= SAE_FormatStatusMessage("cached story count", $storyCount); ?>
More public radio podcasts are at Current.org.