<?php
    include("bk_global.php");

    if (!isset($_SESSION['username']))
    {
        header("Location: bk_login.php");
        exit;
    }

    $insert_bookmark_query = $db->prepare("
        INSERT INTO `bookmarks`
            (`url`, `username`)
        VALUES
            (:url, :username)
    ");

    $insert_bookmark_query->execute(array(
        ':url'      => $_POST['url'],
        ':username' => $_SESSION['username']
    ));

    $bookmarkid = $db->lastInsertId();

    $keywords = explode(",", $_POST['keywords']);

    $insert_keyword_query = $db->prepare("
        INSERT INTO `keywords`
            (`bookmarkid`, `keyword`)
        VALUES
            (:bookmarkid, :keyword)
    ");
    foreach ($keywords as $keyword)
    {
        $insert_keyword_query->execute(array(
            ':bookmarkid' => $bookmarkid,
            ':keyword'    => trim($keyword)
        ));
    }

    header("Location: bk_home.php");

?>