if(!isset($_GET['s']) || !isset($_GET['d'])){ $error = true; } include "backend/db.php"; include "backend/semester.php"; $link = dbConnect(); $show_id = trim($_GET['s']); $show_id = filter_var($show_id,FILTER_SANITIZE_NUMBER_INT); $date = trim($_GET['d']); $date = mysqli_real_escape_string($link,$date); if (!DateTime::createFromFormat('d/m/Y', $date)){ $date = "9/8/16"; } $sql = "SELECT * FROM shows WHERE id = ".$show_id; $result = mysqli_query($link,$sql) or die(mysqli_error($link)); $row = mysqli_fetch_array($result); extract($row); $dsql = "SELECT description FROM descriptions WHERE show_id = ".$show_id." AND date = '".$date."'"; $dresult = mysqli_query($link,$dsql) or die(mysqli_error($link)); $drow = mysqli_fetch_assoc($dresult); $ddescription = $drow['description']; $format_name = str_replace(" ","-",strtolower($name)); $year = date('y'); $season = substr(fetchSemester(),0,-5); $format_date = date("Y-m-d",strtotime($_GET['d'])); $dir = "http://podcasts.wsrnfm.org/".$year."-".$season."/".$format_name."/".$format_date."-".$format_name.".mp3"; //echo $dir; ?>
Name | Artist | Album |
} ?> |
There is no playlist for this show.
} ?>