session_start(); $speakers = "menu-item-active"; include "nav.php"; ?> $clv = $_GET["id"]; $_SESSION["debID"] =$_GET["debid"]; include "./admin/debFunctions.php"; $con = debConnect(); // echo 'here'; $sql = "select * from speakers, events where speakerID = " . $clv . " and speakerEvent = eventID"; // echo $sql; $speaker = $con->query($sql); if (! mysqli_num_rows($speaker)){ echo "
Speaker Not Found
"; echo "
"; include "footer.php"; exit(); }else{ $thisSpeaker = mysqli_fetch_assoc($speaker); echo "
" . $thisSpeaker['speakerFirst'] . " " . $thisSpeaker['speakerLast'] . "
" . $thisSpeaker['eventName'] ."
\n"; } ?>
$imgfile = "./images/speakers/" . $thisSpeaker['speakerImg'] ; if( strlen($thisSpeaker['speakerImg']) && file_exists($imgfile)){ ?>
}else{ ?>
} echo $thisSpeaker['speakerBio']; ?>
if ($thisSpeaker['speakerYoutube']){ ?>
}else{ ?>
Video not available
} ?>
$sql = "select * from speakers where speakerFeatured = 1 order by RAND()"; $next = $con->query($sql); if (mysqli_num_rows($next)){ $nextSpeaker = mysqli_fetch_assoc($next); echo "
See Another Great Talk
"; } ?>
mysqli_close($con); include "footer.php"; ?>