Posted by Ralphie on 10/04/96 11:50

On Thu, 15 Jun 2006 13:35:44 GMT, joboils@spam_less_hotmail.com wrote...
>
>Hello. I am trying to write a code to filter entries (porn and
>medical, etc) in my guest book. The words will come in the $comments
>field.
>This is the file that handles the data coming from the guestbook.php
>screen. I don't know how to make it work properly. Any help would be
>appreciated. Thank you.
>
>$TableName="banned_words";
>$Query="SELECT * FROM $TableName";
>$Result=mysql_db_query ($DBName, $Query, $Link);
>while ($Row=mysql_fetch_array ($Result))
>{
>$banned_words[]=$Row[banned_word];
>}
>$banned_word_count=count($banned_words);
>
>$i=0;
>// now loop through the list of banned words ;
>for ($i=0; $i<=$banned_word_count; $i++)
>{
>// to check if the banned word is in the comments ;
>if (strstr($banned_words[$i], $comments) !=0)
>{
>header("location:guestbook.php");
>exit();
>}
>}
>

Probably a couple of ways you could tackle that. If you're trying to sanitize
the "$comments" variable the str_replace function may work for you. As an
example...

$newtext = str_replace($banned_words, "**censored**", $comments);

You'd still need to build the $banned_words array like you had in your example.

Ralphie
--
Newsguy Unlimited $19.95 monthly
http://newsguy.com/overview.htm

[Back to original message]