function kwresearch_google_get_keyword_stats in Keyword Research 6

Same name and namespace in other branches

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

Implementation of 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

Implentation of hook_kwresearch_sources()

File

modules/kwresearch_google/kwresearch_google.module, line 236

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 "%%%s%%"
    ';
    $result = db_query($sql, $keywords);
  }
  else {
    $placeholders = implode(',', array_fill(0, count($k), '"%s"'));
    $sql = '
      SELECT * FROM {kwresearch_google_data}
      WHERE keyphrase IN (' . $placeholders . ')
    ';
    $result = db_query($sql, $k);
  }
  while ($row = db_fetch_object($result)) {
    $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;
}