function kwresearch_load_page_keywords_by_keyword in Keyword Research 7

Same name and namespace in other branches

1. 6 kwresearch.module \kwresearch_load_page_keywords_by_keyword()

Loads an array of page keyword objects of all pages associated with a specific keyword

Parameters

int|str $key Int treated as kid, str as keyword phrase:

File

./kwresearch.module, line 718

Code

function kwresearch_load_page_keywords_by_keyword($key) {
  if (!is_numeric($key) || $key <= 0) {
    $keyword_obj = kwresearch_load_site_keyword($key);
    $kid = $keyword_obj->kid;
  }
  else {
    $kid = $key;
  }
  $sql = '
    SELECT *
    FROM {kwreserach_page_keyword}
    WHERE kid = :kid
  ';
  $args = array(
    ':kid' => $kid,
  );
  $result = db_query($sql, $args);
  $page_keywords = array();
  while ($row = $result
    ->fetchObject()) {
    $page_keywords[] = $row;
  }
  return $page_keywords;
}