protected static function updateDb($seed, $keywordRow, $titles, $numSearchResults = 0)
{
if (empty($seed) || empty($keywordRow) || empty($titles)) {
return;
}
//store keyword
$seedKeyword = KeywordIdeasCSV::getSeedKeyword($seed);
$keyword = $keywordRow[KeywordIdeasCSV::KEY_KEYWORD];
$avgMonthlySearches = $keywordRow[KeywordIdeasCSV::KEY_AVG_SEARCHES];
$ipRank = $keywordRow[KeywordIdeasCSV::KEY_IP_RANK];
$res = LDao::addDbKeyword($seedKeyword, $keyword, $avgMonthlySearches, $numSearchResults, $ipRank);
//store titles
foreach ($titles as $title) {
$posInResults = $title[self::KEY_POS_IN_RESULTS];
$origTitle = $title[self::KEY_ORIG_TITLE];
$shortTitle = $title[self::KEY_SHORT_TITLE];
$site = $title[self::KEY_SITE];
$url = $title[self::KEY_URL];
$res = LDao::addTitle($seedKeyword, $keyword, $posInResults, $origTitle, $shortTitle, $site, $url);
}
}
