示例#1
0
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>
示例#2
0
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;
    }
}