In mysql database how to give data with apostrophe

**debasisdas** · Apr 24 '08, 08:46 AM

Try to use \' ----------- A single quote (“'”) character.

**ronverdonk** · Apr 24 '08, 03:28 PM

Originally posted by shiva05

Hi frnds,
In mysql database how to give data with apostrophe for eg. (i want a data like aurovilan's to be inserted).

If you insert your data via PHP, use the addslashes() function before you insert and use the stripslashes() function after you selected.

Ronald

**mwasif** · Apr 25 '08, 06:33 PM

Originally posted by ronverdonk

If you insert your data via PHP, use the addslashes() function before you insert and use the stripslashes() function after you selected.

Ronald

AFAIK, there is no need to apply stripslashes() after selecting data from database.

Comment