This is probably an obvious problem but please help??? I'm thick at this PHP when it

MtPHP

I wish to use the strstr() function to make a profanity filter, but unfortunately I don't know how to use MySQL

I want to do something like this
if(strstr($username, "SELECT words FROM profanity"))
{
?>
Registration ErrorSorry, you must not use profanity, this is a kids site!
<?php
} elseif(//continue my processing as of here
but that didn't work
What will???
Thanks in advance!

planetsim

try this
$result=mysql_query("SELECT words FROM profanity");
while($r=mysql_fetch_array($result))
{
string = eregi_replace(word thats to be replaced,$r[word],string)
}

hope that helps

cgraz

untested, but something like this should work

<?

$query = mysql_query("SELECT words FROM profanity");

while($row = mysql_fetch_array($query)) {

  if (strstr($row, $username)) {
     print "<p align='center'>\n";
     print "<font face='arial' size='5'>Registration Error</font></p>\n"; 
     print "<p><font face='arial' size='3'>Sorry, you must not use profanity, " 
         . "this is a kids site!</font></p>\n";
     exit;
   } else {
     // nothign needs to be here
   }

}


// if the script makes it this far (meaning it didn't exit)
// no profanity was found, so do whatever

?>

Cgraz

MtPHP

Thanks planetsim, it worked. I ended up going with cgraz' idea thougn since it better suits my needs. Thanks both of you!!!

cgraz

Did that code work? I just realized $row should be $row['words']

Cgraz