Add slashes automaticly between " or ' in strings

[Atomiku]

Umm the title is self explanatory...

Lets say I have a string and the string is this: Hello, this is a 'st'rin'g' isnt "i"d"t?"

How can I have PHP add slashes inbetween the " or '?

So the output would be this:Hello, this is a 'st\'rin\'g' isnt "i\"d\"t?"

[Drakla]

I take it you have heard of [man]addslashes[/man] - and what do you mean by 'automatically'?

[Atomiku]

Well... I only want it to add slashes in between " and ' in a string.

So " SELECT * FROM oioi WHERE id = 'hello'you ass' "
would add a slash just after hello

[Drakla]

variables should be escaped with [man]mysql_real_escape_string[/man] before they got into queries. You could probably rig up a regex to rip out the strings in your SELECT but I haven't got the capacity for that right now. Keep your thumb out as I'm sure somebody might have themselves in the right gear for this kind of thing.

[Weedpacket]

One of the problems is a string like this:

The string 'this is 'a string that's got two apostrophes in it' has two apostrophes in it.

The problem is. How to tell if that's supposed to be

The string 
'this is '
a string that
's got two apostrophes in it'
 has two apostrophes in it.

or

The string 
'this is \'a string that\'s got two apostrophes in it'
 has two apostrophes in it.

or

The string \'this is \'a string that\'s got two apostrophes in it\' has two apostrophes in it.

As Drakla suggested; if you can, escape strings before embedding them into others. Otherwise you have to undo all your work to get them back out again so that you can escape them (and then put them back in again).

[Atomiku]

Damn lol. More work for me 🙁 Ive gotta add "addslashes" like 50 times now 😢

[Atomiku]

Right! I know how I can do this now!

The string
++'this is '
a string that
's got two apostrophes in it'
has two apostrophes in it.++'

Inbetween the ++'es so it would then addslashes inbetween the ++' "Tags" and also take out the ++

But how can I do this?