function kwresearch_load_site_keyword in Keyword Research 7

Same name and namespace in other branches

1. 6 kwresearch.module \kwresearch_load_site_keyword()

Loads site keyword object from databased

Parameters

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

10 calls to kwresearch_load_site_keyword()

kwresearch_delete_site_keyword in ./kwresearch.module

Deletes site keyword from db

kwresearch_get_keyword in ./kwresearch.module

Returns the keyword phrase for a given kid

kwresearch_get_kid in ./kwresearch.module

Returns the kid for a given keyworld

kwresearch_keyword_pages_page in ./kwresearch.admin.inc

Generates table of pages assoicated with a keyword

kwresearch_load_page_keyword in ./kwresearch.module

Loads page keyword object from database

... See full list

File

./kwresearch.module, line 378

Code

function kwresearch_load_site_keyword($key, $is_kid = TRUE) {
  if ($is_kid && is_numeric($key) && $key > 0) {

    // load by kid
    $sql = '
      SELECT *
      FROM {kwresearch_keyword}
      WHERE kid = :kid
    ';
    $args = array(
      ':kid' => $key,
    );
    $keyword_obj = db_query($sql, $args)
      ->fetchObject();
  }
  else {

    // load by keyword
    $sql = '
      SELECT *
      FROM {kwresearch_keyword}
      WHERE keyword = :keyword
    ';
    $args = array(
      ':keyword' => $key,
    );
    $keyword_obj = db_query($sql, $args)
      ->fetchObject();
  }
  return $keyword_obj;
}