preg_replace question

[vincentp]

I'm trying to do a preg_replace on mysql results.

I have this:

$string = 'The quick brown fox jumped over the lazy dog.';

//(with in the table "brown" in the Pattern field and "blue" in the Replacement field)

$username="user";
$password="password";
$database="database";

mysql_connect(localhost,$username,$password);
mysql_select_db($database) or die( "Unable to select database");

$query = "SELECT * FROM table";

$result=mysql_query($query) or die (mysql_error());

$num = mysql_num_rows($result) or die (mysql_error());


$i=0;
while ($i < $num) {		

$patterns[$i] = mysql_result($result,$i,"Patterns")';


$i++;
}
$i=0;
while ($i < $num) {



$replacements[$i] = mysql_result($result,$i,"Replacements");

$i++;
}

ksort($patterns);
ksort($replacements);
echo preg_replace($patterns, $replacements, $string);

?>

but the script outputs the replaced line without any changes, brown is not replaced with blue.

What am I doing wrong?

Hope anyone can help!

Cheers,
Vincent

[dagon]

what does $patterns and $replacements actully look like?

[vincentp]

Hi Dagon,

if I add an echo line:

$i=0;
while ($i < $num) {



$patterns[$i] = mysql_result($result,$i,"Patterns");

echo $patterns[$i];

$i++;
}
$i=0;
while ($i < $num) {



$replacements[$i] = mysql_result($result,$i,"Replacements");

echo $replacements[$i];

$i++;
}

I get "brownblue" as a result.

echoing $patterns or $replacements gives me "Array"

[vincentp]

I actually found it out myself:

I added slashes to the input in the mysql table. so brown now is /brown/

then brown gets neatly replaced with blue 🙂

thanx 🙂

[Weedpacket]

If that's all you're replacing (i.e., one literal string for another), then preg_replace() is the wrong function to be using. Look at using [man]str_replace[/man] instead.