function top_searches_catch_search_keys in Top Searches 5

Same name and namespace in other branches

1. 6 top_searches.module \top_searches_catch_search_keys()
2. 7 top_searches.module \top_searches_catch_search_keys()

File

./top_searches.module, line 96

Code

function top_searches_catch_search_keys($form_id, $form_values) {
  switch ($form_id) {
    case "search_block_form":
      $keys = $form_values['search_block_form_keys'];
      break;
    case "search_form":
      $keys = $form_values['keys'];
      break;
  }

  // Beautify the search phrase
  $keys = preg_replace("/[' ']{2,}/", ' ', ucwords(strtolower(trim($keys))));

  // Search the DB for existing keys:
  $results_qid = db_result(db_query("SELECT qid FROM {top_searches} WHERE q = '%s'", $keys));
  if ($results_qid) {
    db_query("UPDATE {top_searches} SET counter = (counter + 1) WHERE qid = %d", $results_qid);
  }
  else {
    db_query("INSERT INTO {top_searches} (q, counter) VALUES ('%s', %d)", $keys, 1);
  }
}