buildRecentComments(getRecentComments()); ?> </div> </div> </div> <div class="row"> <?php if (isset($_SESSION['loggedin'])) { ?> <div class="col-xs-6 col-md-4"> <div class="panel panel-primary"> <div class="panel-heading"> <h4>Your Favorites</h4> </div> <?php buildFavorites(getFavorites($_SESSION['username'])); ?> </div> </div> <?php } ?> <div class="col-xs-12 col-md-8"> <div class="panel panel-primary"> <div class="panel-heading"> <h4>Sports</h4> </div> <?php getSports(); ?> </div>
function getFavorites($username) { /* Queries the database for all the user's favorites */ global $con; try { $sql = "SELECT `favorites` FROM `users` WHERE username = :username"; $sql = $con->prepare($sql); $sql->bindParam(":username", $username); $sql->execute(); buildFavorites($sql->fetch()); } catch (PDOException $e) { echo $e; } }