<?php

    include("bk_global.php");

?>
<h3>Bookmarks for "<?=htmlspecialchars($_GET['keyword'])?>"</h3>

<?php

    $get_bookmarks_query = $db->prepare("
        SELECT * FROM `bookmarks`
        LEFT JOIN `keywords` ON
            (`bookmarks`.`bookmarkid` = `keywords`.`bookmarkid`)
        WHERE
            `keywords`.`keyword` = :keyword
        AND
            `bookmarks`.`username` = :username
    ");

    $get_bookmarks_query->execute(array(
        ':keyword' => $_GET['keyword'],
        ':username' => $_SESSION['username']
    ));

    while ($row = $get_bookmarks_query->fetch())
    {
        echo '<div><a href="' . htmlspecialchars($row['url']) . '">'
            . $row['url']
            . '</a></div>'; 
    }

?>
