Replace all special characters from a string using PHP

Question

Hi, I am using jQuery editor with PHP it works fine for plane text (text with out special characters) but if I try to post text which contain special characters then it does not store these special characters in to db table.. and when I tried to replace any special character with HTML codes it works fine. But it is too difficult to replace all special character one by one.. Is there any script which replace all special characters from a string...?

Thanks

Answer 1

Do you mean something like PHP's str_replace()?
http://php.net/manual/en/function.str-replace.php

Answer 2

Is there any script which replace all special characters from a string...?

This is the wrong approach. You need to get your character sets right, so will be no need to replace anything.

I don't know what you're doing, but if you are transmitting data through Ajax, it is probably UTF-8 encoded. If your database is in a different character set, you may need to convert it.

• Basic (deep) reading: The Absolute Minimum Every Software Developer Absolutely, Positively Must Know About Unicode and Character Sets (No Excuses!)

• For more specific information, you will need to provide more details about your situation. Here are a few questions that deal with the subject, maybe one of them already helps:

  • Special characters in PHP / MySQL

  • How to store characters like ♥☆ to DB?