Censoring out Wordsh

[TimTimTimma]

Here is my delima, I am not to keen any replace functions in php. Lets say I have a paragraph posted in the mysql database that gets echoed out to the public. Now BEFORE its echoed out, I need some script or function to search the entire document for words that I have defined as being inappropriate. I would need the script to grab all the 'bad words' out of the database and search for any matches within a document. Then replace the 'bad words' with their corresponding replacements that are also stored in the database.. I am not sure as to how I need to go about this, any ideas?

[bradgrafelman]

So what do you have in the database, something like this?

+-------------------+
| bad | good |
+-------------------+
| ass | @$$ |
| etc. | so on |
+-------------------+

Best bet would be to use [man]str_ireplace/man I believe, like so:

$query = 'SELECT * FROM badwords';
$exec = mysql_query($query) or die('Error, MySQL said: ' . mysql_error());

while($result = mysql_fetch_assoc($exec)) $data = str_ireplace($result['bad'], $result['good'], $data);

echo $data; // $data should be safe now; no more bad words!

EDIT: Changed code to use str_ireplace() instead of str_replace() to make a more flexible search and replace.