problems with str_replace

Hi,
am very new to php and am trying to strip swear words listed in a database from a variable and replace them with blank space.

Can anyone help?

php code:
-------------------------------------------------------------------------------
<?php
mysql_select_db($database_icarus, $icarus);
$query_rsDot = "SELECT extension FROM bad";
$rsDot = mysql_query($query_rsDot, $icarus) or die(mysql_error());
$row_rsDot = mysql_fetch_assoc($rsDot);
$totalRows_rsDot = mysql_num_rows($rsDot);

$text = "blah blah blah xxxx blah2 blah2";
$text2 = str_replace (array("$rsDot"), " ","$text"); ?>
--------------------------------------------------------------------------------
I was try to put the database results ($rsDot) into an array, replace all occurences in $test with blank space, and then display the results as $text2 I am not getting any errors but it is not taking the words out.

It's close but you'd be better of with this;



Note that mysql_query() returns a resource not an array.

that would almost work except for one thing

$text = str_replace ($row_rsDot, '*bleep*',$text);

should be

$text = str_replace ($row_rsDot[0], '*bleep*',$text);


dont forget

$row_rsDot = mysql_fetch_assoc($rsDot))

makes $row_rsDot an array

Good point. Attention wandered there for a moment.

many thanks Harry, many thanks Ben. Actually Harry your code worked first time and when I made Ben's changes it wouldn't work! Thanks again,
cheeri
Anders

thats weird, as you cant replace an "array" only an array value!

I have a similar problem getting str_replace() to work.

Here's my following code:



<?php

$words = file("badwords.txt");
trim($words);
$search = "The bad kitty said doh and hello.";
$num = count($words);
$i = 0;

while($i < $num)
{

$search = str_replace($words[$i], '*bleep*' , $search);
$i++;

}

echo "<br>";
echo $search;


?>



I think it has something to do with the file() bc the following code works:


<?php

$words = array( "bad", "kitty", "hello");
$search = "The bad kitty said doh and hello.";
$num = count($words);
$i = 0;

while($i < $num)
{

$search = str_replace($words[i], '*bleep*' , $search);
i++;

}

echo "<br>";
echo $search;


?>

ben, shouldn't it be

it's an associative array, maybe that's why he couldn't get it to work using $text = str_replace ($row_rsDot[0], '*bleep*',$text);

Will your bad word filter replace case insensative? str_replace() is case sensative, so, it might get BAD_WORD but will not get BaD_WoRd, or other combinations of bad_word. Below is a more robust solution to your dillema ->

So use that case insensative function. Now, build your array of words to look for and iterate over a copy of the array() like so ->

Where $post holds the data you are searching through for the bad words....

or juse use ereg_replace

Or preg_replace().....

or eregi_replace()...