function kwresearch_google_get_keyword_stats in Keyword Research 7

Same name and namespace in other branches

1. 6 modules/kwresearch_google/kwresearch_google.module \kwresearch_google_get_keyword_stats()

Implements hook_stats_callback() via custom define callback in hook_kwresearch_sources() ().

Parameters

string|array $keywords:

array $msgs:

array $params:

1 string reference to 'kwresearch_google_get_keyword_stats'

kwresearch_google_kwresearch_sources in modules/kwresearch_google/kwresearch_google.module

@todo Please document this function.

File

modules/kwresearch_google/kwresearch_google.module, line 395

Code

function kwresearch_google_get_keyword_stats($keywords, &$msgs, $params) {
  $apiret = array();
  $k = explode(',', $keywords);
  $keywords_s = implode('","', $k);
  if (count($k) == 1) {
    $sql = '
        SELECT * FROM {kwresearch_google_data}
        WHERE
          keyphrase LIKE :keyphrase
    ';
    $args = array(
      ':keyphrase' => "%%{$keywords}%%",
    );
    $result = db_query($sql, $args);
  }
  else {
    $sql = '
      SELECT * FROM {kwresearch_google_data}
      WHERE keyphrase IN (:data)
    ';

    // TODO Please convert this statement to the D7 database API syntax.
    $args = array(
      ':data' => $k,
    );
    $result = db_query($sql, $args);
  }
  while ($row = $result
    ->fetchObject()) {
    $apiret[$row->keyphrase]['searches'] = (int) $row->monthly_searches;
    $apiret[$row->keyphrase]['competition'] = (int) $row->competition;
    $apiret[$row->keyphrase]['bid'] = (double) $row->avg_cpc;
  }
  return $apiret;
}