function kwresearch_load_page_keywords_by_page in Keyword Research 7

Same name and namespace in other branches

1. 6 kwresearch.module \kwresearch_load_page_keywords_by_page()

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

Parameters

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

4 calls to kwresearch_load_page_keywords_by_page()

kwresearch_delete_page_keywords_by_page in ./kwresearch.module

Deletes all the page keyword for a given page

kwresearch_form_node_form_alter in ./kwresearch.module

kwresearch_node_insert in ./kwresearch.module

Implements hook_node_insert().

kwresearch_node_save in ./kwresearch.module

File

./kwresearch.module, line 746

Code

function kwresearch_load_page_keywords_by_page($pid) {
  $msgs = array();
  $pn = kwresearch_construct_pathnid_obj($pid, $msgs);
  if (!$pn) {
    return array();
  }
  $sql = "\n    SELECT pk.*, k.keyword, k.priority AS site_priority, k.value AS value\n    FROM {kwresearch_page_keyword} pk\n    JOIN {kwresearch_keyword} k ON pk.kid = k.kid\n    WHERE path = :path\n  ";
  $args = array(
    ':path' => $pn->path,
  );
  $result = db_query($sql, $args);
  $page_keywords = array();
  while ($row = $result
    ->fetchObject()) {
    $page_keywords[] = $row;
  }
  return $page_keywords;
}