Who are you looking for?'; echo "No presenter was selected. Please check your URL."; goto endbit; } $FirstName = substr($PresenterName,0,strpos($PresenterName, " ",0)); $PresenterImage = "img/pres/bio/" . $PresenterName . ".png"; if (file_exists($PresenterImage)) { echo 'Photo of ' . $PresenterName . ''; } $query3 = mysqli_stmt_init($mysqli_master); mysqli_stmt_prepare($query3, "SELECT `a`.`ActualShowTitle`, `a`.`ActualPresenter`, IF((`a`.`ActualStartTime`UNIX_TIMESTAMP(NOW())), 'YES', 'NO') as IsItOnNow, CONCAT(DATE_FORMAT(FROM_UNIXTIME(`a`.`ActualStartTime`), '%a %D %b'), ' at ', LOWER(DATE_FORMAT(FROM_UNIXTIME(`a`.`ActualStartTime`), '%l:%i%p'))) as OnAirString FROM `Merged Timetable` a INNER JOIN (SELECT OnAirName FROM tblPresenters WHERE OnAirName=? OR PresenterName LIKE ?) AS b ON `a`.`ActualPresenter` = `b`.`OnAirName` WHERE `a`.`ActualEndTime`>UNIX_TIMESTAMP(NOW()) AND (`a`.`ActualShowType` NOT IN ('A', 'R')) ORDER BY `a`.`ActualStartTime` ASC LIMIT 5;"); $PNPCT = '%' . $PresenterName . '%'; mysqli_stmt_bind_param($query3, "ss", $PresenterName, $PNPCT); mysqli_stmt_execute($query3); $query3r = mysqli_stmt_get_result($query3); $query3a = mysqli_stmt_init($mysqli_master); mysqli_stmt_prepare($query3a, "SELECT EmailAddress, FacebookPage, TwitterHandle, Bio FROM tblPresenters WHERE OnAirName=? LIMIT 1"); mysqli_stmt_bind_param($query3a, "s", $PresenterName); mysqli_stmt_execute($query3a); $PresInfo = mysqli_stmt_get_result($query3a); mysqli_close($mysqli_master); echo '

' . strtoupper($PresenterName) . "\n"; if ($PresInfo->num_rows > 0) { while($Infos = $PresInfo->fetch_assoc()) { if ($Infos['EmailAddress'] != "") { echo ' ' . "\n"; } if($Infos['FacebookPage'] != "") { echo ' ' . "\n"; } if($Infos['TwitterHandle'] != "") { echo '' . "\n"; } $ThisIsBio = $Infos['Bio']; } echo '

' . "\n"; if ($query3r->num_rows != 0) { echo ''; } if (!is_null($ThisIsBio)) { echo $ThisIsBio; } else { echo '

Please check back soon for more information!

'; } } else { echo '

No information is currently available for this presenter.

'; } endbit: echo '
Other Presenters:
    '; while ($pres = $PresRundown->fetch_assoc()) { if ($pres['OnAirName'] != urldecode($PresenterName)) { $OtherPresenterImage = "img/pres/thumb/" . $pres['OnAirName'] . ".png"; if (file_exists($OtherPresenterImage)) { $ImageName = $pres['OnAirName']; } else { $ImageName = "_Blank"; } echo '
  • Photo of ' . $pres['OnAirName'] . '
    • '; } } echo '
'; ?>