Filtering a Query

raustin

I have a search engine that lists recent search queries, and I want to filter a list of words from the results:

<?
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('words.txt');

$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>

I am a bit lost in how to do this. Any help would be most appreciated.

raustin

Is this a lost cause? Can it be done?

raustin

hello?

liquorvicar

didn't understand what you're after. can you explain it a bit better?

raustin

Sure thing.

The script is for a meta search engine page that displays all of the 'queries' (search terms) in a list. My problem is that there are a lot of naughty searched appearing in the list, and I want to permanently block them. So even if someone typed in 'naked women', it would show in the list as long as that term was in a 'bad words' file.

So the query would check the terms it pulled against a list (ideally in a text file on the server) and display the filtered data. Is it possible?

liquorvicar

ah, ok.
yes this is possible.
store your naughty words in an array and then check each query against that array using in_array()

raustin

so by array, do you mean add a table in the database?

liquorvicar

if your list of naughty words is often updated then yes a db table or a flat text file would work. read them into an array before you do the filtering. if your list is fairly static, you may be able to hardcode the array into your script.

raustin

how would my code look with the array in a text file? I'm fairly new to this stuff...

raustin

Still there liquorvicar?

liquorvicar

just put each naughty word on a new line in your text file. PHP's file command will read a file into an array:
http://uk2.php.net/file

sorry not to respond earlier, bank holiday weekend here in the UK.

raustin

Ok, i'm doing something wrong here:

<div class=content>
<h1>##_queries_archive##</h1>
<?
function file_trim(&$value, $key)
{ $value = trim($value); }

$file = file('bad.txt');
@array_walk($file, 'file_trim');

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());

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>

liquorvicar

first few lines look OK. still not sure what you're doing in the rest of the script but it should leave you with an array of bad words to filter called $file.

ps please enclose any code in the board's PHP tages as it makes it easier to read.

raustin

I just edited the code above... still no dice...

liquorvicar

you're not using the $file array after you have created it. what data are you trying to filter through it?

raustin

$querytable

Basically, I want to display $querytable minus bad.txt

The code:

<?
function file_trim(&$value, $key)
{ $value = trim($value); }

$file = file('bad.txt');
@array_walk($file, 'file_trim');

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());

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>";
}
?>

raustin

Originally posted by liquorvicar
you're not using the $file array after you have created it. what data are you trying to filter through it?

I'm not sure of where or how to use it...

liquorvicar

i'm no expert on regular expressions but this should work:

<?
function file_trim(&$value, $key)
{ $value = trim($value); }

$file = file('bad.txt');
@array_walk($file, 'file_trim');

$res = mysql_query("SELECT * FROM $querytable ORDER BY q_id DESC") or die(mysql_error());

while ($line = mysql_fetch_assoc($res)) {
$searchterm = $line['q_query'];
foreach ($file as $word) {
  $searchterm = str_replace($word,'***',$searchterm);
}
echo "<a href='".constant('dir')."search/".$searchterm."'>".$searchterm."</a><br>";
}
?>

raustin

Thanks for the code... When i put it in, the page doesn't load... is there another way to do this?

liquorvicar

what do you mean the page doesn't load? do you get an error?