function insertKeyword($keyword) { global $keywordInsertStmt; $existingKeywordId = getKeywordId($keyword); if ($existingKeywordId != null) { return $existingKeywordId; } $keywordInsertStmt->bind_param("s", $keyword); $keywordInsertStmt->execute(); return getLastInsertedId(); }
/** * Adds keywords to the keyword table and links the new commit * with the keywords * * @param array $arKeywords Array of keywords * @param integer $nCommitId Database ID of the commit * @param PDO $db Database connection object * * @return void */ function linkKeywordsAndCommit($arKeywords, $nCommitId, $db) { if (count($arKeywords) == 0) { return; } foreach ($arKeywords as $keyword) { $nKeywordId = getKeywordId($keyword, $db); $numAffected = $db->exec('INSERT INTO keywords_commits' . ' SET k_id = ' . (int) $nKeywordId . ' , c_id = ' . (int) $nCommitId); if ($numAffected === false) { handleError($db); } } }