function kwresearch_update_keyword_page_counts in Keyword Research 7

Same name and namespace in other branches

1. 6 kwresearch.module \kwresearch_update_keyword_page_counts()

Updates the page_count field in site keyword table

Parameters

int $kid - id of keyword:

3 calls to kwresearch_update_keyword_page_counts()

kwresearch_delete_page_keywords_by_page in ./kwresearch.module

Deletes all the page keyword for a given page

kwresearch_node_save in ./kwresearch.module

kwresearch_save_page_keyword in ./kwresearch.module

Saves a page keyword. Links a site keyword to a node/page

File

./kwresearch.module, line 838

Code

function kwresearch_update_keyword_page_counts($kid) {
  $sql = '
    SELECT COUNT(*)
    FROM {kwresearch_page_keyword}
    WHERE kid = :kid
  ';
  $args = array(
    ':kid' => $kid,
  );
  $count = db_query($sql, $args)
    ->fetchField();
  $sql = '
    UPDATE {kwresearch_keyword}
    SET page_count = :count
    WHERE kid = :kid
  ';
  $args = array(
    ':count' => $count,
    ':kid' => $kid,
  );
  db_query($sql, $args);
  return $count;
}