function kwresearch_load_page_keyword in Keyword Research 6

Same name and namespace in other branches

1. 7 kwresearch.module \kwresearch_load_page_keyword()

Loads page keyword object from database

Parameters

int|str $pid if int, treated as a node id. If str treated as a path.:

int|str $key if int, treated as a kid. If str treated as a keyword phrase:

3 calls to kwresearch_load_page_keyword()

kwresearch_delete_page_keyword in ./kwresearch.module

Deletes site keyword from db

kwresearch_page_keywords_edit_form in ./kwresearch.admin.inc

Returns page keyword edit form

kwresearch_save_page_keyword in ./kwresearch.module

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

File

./kwresearch.module, line 539

Code

function kwresearch_load_page_keyword($pid, $key) {
  $site_keyword_obj = kwresearch_load_site_keyword($key);
  $kid = $site_keyword_obj->kid;
  $pn = kwresearch_construct_pathnid_obj($pid, $msgs);
  $sql = "\n    SELECT * \n    FROM {kwresearch_page_keyword}\n    WHERE kid = %d\n      AND path = '%s'\n  ";
  $page_keyword_obj = db_fetch_object(db_query($sql, $kid, $pn->path));
  $page_keyword_obj->site = $site_keyword_obj;
  return $page_keyword_obj;
}