pass an ampersand to a database through AJAX......

[scarhand]

I didnt know exactly where to put this so I posted it in PHP and AJAX forums

 

I'm having problems passing an ampersand through AJAX to a database.

 

htmlspecialchars will convert and send all other chars to the database, except ampersand

 

heres my message variable before its inserted into the database:

 

$message = mysql_real_escape_string(htmlspecialchars($_POST['message'], ENT_QUOTES));

 

is there any other php procedures that I could use so that my AJAX script will pass ampersands into the database?

[bobleny]

You could try this:

 

$_POST['message'] = str_replace('&', '&', $_POST['message']);
$message = mysql_real_escape_string(htmlspecialchars($_POST['message'], ENT_QUOTES));

 

Good luck!

[markjoe]

I've never run into this problem, but it occurs to me that you could use the ascii code to make the transit and then back to the character to make the comparison.

Just a thought, seems simple enough.

2 PHP functions of interest:

ord()

chr()