keyword filters for search box

[Guest]

presently, if you sell a lot of products with the name 'widgets' and if you have a large inventory, somebody using the keyword 'widget' will cause a database connection error.

 

is it possible to add a filter to disallowed keywords?

[Guest]

nobody's ever knocked their site down by typing an overly common term??

[♥bruyndoncx]

1) perhaps you are missing a few indexes to speed up the queries ?

2) perhaps you could limit results ?

 

btw how many products do you have ?

[Guest]

1) perhaps you are missing a few indexes to speed up the queries ?

where should the indexes be created and how does one create them?

 

2) perhaps you could limit results ?

how could this be achieved

 

btw how many products do you have ?

1654, not counting offline products.

[Gil_e_n]

For a quick fix, I'd do something like

if ($keywords == 'widgets') {
 $error = true;

$messageStack->add_session('search', ERROR_TERM_TOO_COMMON);}

although I'm pretty certain that that code isn't going to work without some tweaking because my brain's corpsified today. Long-term, I'd probably prettify it up with a sql query to the database and store the list of disallowed words in the database.

[Guest]

where would i put this? i tried putting it beneath

	$messageStack->add_session('search', ERROR_AT_LEAST_ONE_INPUT);
 } else {
$dfrom = '';
$dto = '';
$pfrom = '';
$pto = '';
$keywords = '';

in advanced_search_results.php and it just let it search

[Gil_e_n]

Yeah, it hasn't defined the keyword yet. I'd try placing it after

	if (tep_not_null($keywords)) {
  if (!tep_parse_search_string($keywords, $search_keywords)) {
	$error = true;

	$messageStack->add_session('search', ERROR_INVALID_KEYWORDS);
  }

 

I'm guessing that'll work better.

[Guest]

excellent. seems to have done the trick :)

 

now how can i add multiple terms?

i tried:

if ($keywords == 'widgets','poop') {
 $error = true;

$messageStack->add_session('search', ERROR_TERM_TOO_COMMON);}

and just got a parse error

[Gil_e_n]

if ($keywords == 'widgets' || $keywords ==  'poop') {
 $error = true;

$messageStack->add_session('search', ERROR_TERM_TOO_COMMON);}

 

Try that.