Blocking entries in a database

raustin

I have a meta search engine that displays recent search queries:

http://www.sodora.com/queries.html

As you can tell, there are a lot of 'naughty' searches being submitted.

I fear that Google will assume my site to be adult-related and cut off my adwords stream.

Is there a way to lock out, ban, or omit specified search terms permantly from mySQL?

englishman69

You could set the system that adds the new searches to the MySQL database to compare the new searches against a predefined list to make sure they are okay before adding in.

This can be done with the PHP command strpos or with a really really long SQL insert command. I would recommend the strpos way 🙂

raustin

DO you know of any examples? Will that slow the search time down? Is that the only way?

raustin

ok, so how would i create a list of terms not to display in the query?

mrhappiness

$bad_words = array('some', 'bad', 'words');

$pattern = '%'.preg_quote(implode('|', $bad_words)).'%i';

if (preg_match($pattern, $searchstring)) {
  do_insert();
}

maybe like this

raustin

It doesn't work... the bas words are still there. Mind taking another look?

<?
function format_term($term) {
$term = str_replace('-','~~',$term);
return str_replace(' ','-',$term);
}
$res = mysql_query("SELECT * FROM $querytable ORDER BY q_id DESC") or die(mysql_error());
$bad_words = array('pthc rompl ranchi pthc pthc ranchi board', 'melissa midwest', 'melissa midwest movies');

$pattern = '%'.preg_quote(implode('|', $bad_words)).'%i';

if (preg_match($pattern, $searchstring)) {
do_insert();
}
while (($line = mysql_fetch_assoc($res)) && strlen(ob_get_contents()) < 95*1024) {
echo "<a href='".constant('dir')."search/".format_term($line['q_query'])."'>".$line['q_query']."</a><br>";
}
?>
</div>

Thanks.

raustin

ANd is there a way to make this block all wild cards?

i.e. 'nude'

blocks

'skinny nude', 'nude dude' etc...

raustin

Can anyone tell me what is wrong with my code?

Thanks