Implode Removing \\ From Mysql_Real_Escape_String

[richiejones24]

I run data through mysql_real_escape_string() before using implode() but implode() is removing 1 of the \ after mysql_real_escape_string() has put them in.

 

If anyone you could let me know how i could stop this i would be great.

 

Thanks

[Jessica]

implode does not affect the values within the array.

Post the code.

[ManiacDan]

Better yet, post code that proves this is happening, along with the output.

[richiejones24]

MySql Values after implode() '140 Church Street','St John\'s Wood','London','NW8 8EX'

MySql Values before implode() '140 Church Street','St John\\'s Wood','London','NW8 8EX'

 

The Code

while ($f < count($AddressSplitBus))
{
$AddressSplitBus[$f] = trim($AddressSplitBus[$f]);
$AddressSplitBus[$f] = mysql_real_escape_string($AddressSplitBus[$f]);

$f++;
}

//Create the Values to insert into DB
$MysqlValuesBus = implode("','", $AddressSplitBus);
$MysqlValuesBus = "'$MysqlValuesBus'";
$NumberValsBus = count($AddressSplitBus);

 

Again Thanks for the help guys

[Barand]

Your values before the implode should look like the values that you get after. It looks as though you are escaping data that has already been escaped. Have you checked that magic_quotes are not on?

[Jessica]

And how do you KNOW that is happening? There's nothing in your code that does an echo or dump of the data.

[ManiacDan]

Right, this code proves nothing other than you still say something which most of us think is impossible.

 

Barand is right, this data is already escaped by something. Though that has no bearing on implode()