function kwresearch_load_page_keyword in Keyword Research 7

Same name and namespace in other branches

1. 6 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

@todo Please document this function.

kwresearch_save_page_keyword in ./kwresearch.module

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

File

./kwresearch.module, line 685

Code

function kwresearch_load_page_keyword($pid, $key) {
  $site_keyword_obj = kwresearch_load_site_keyword($key);
  $kid = $site_keyword_obj->kid;
  $msgs = array();
  $pn = kwresearch_construct_pathnid_obj($pid, $msgs);
  $sql = "\n    SELECT *\n    FROM {kwresearch_page_keyword}\n    WHERE kid = :kid\n      AND path = :path\n  ";
  $args = array(
    ':kid' => $kid,
    ':path' => $pn->path,
  );
  $page_keyword_obj = db_query($sql, $args)
    ->fetchObject();

  //$page_keyword_obj = db_fetch_object(db_query($sql, $args));
  if (empty($page_keyword_obj)) {
    $page_keyword_obj = (object) array();
  }
  $page_keyword_obj->site = $site_keyword_obj;
  return $page_keyword_obj;
}