Trouble with Ajax: can't insert words into mysql with characters like ', e.g. "don't"

[angelhiso]

hei coild somebody help me with ajax mysql ?
I use ajax to put data to my database but why i can not put the charector like ' \ ? for example i want to put the word DON'T which has the 'it could not do it why ? what should i do ?

[angelhiso]

I can not put the charector like \ ' to the data base.
I use ajax to put the data to my database and i found today that i can not put these kinds of charector to my database at all. every word which contents ' can not be sent for example don't can't \
But when i tried to put the data to database with the normal method (none ajax) so i could do that.
Ajax is cool and quick but how could i fix this problem ? have somebody here the same prblem as me ?

[Dormilich]

did you escape the values (PHP side)? (e.g. mysql_real_escape_string() or (my personal favourite) by a Prepared Statement)

[acoder]

Welcome to Bytes!

If that suggestion doesn't work, post your code.

PS. posts split off from other threads. Please post a new thread for posts rather than hijacking other members' threads. Thanks.

[angelhiso]

Hi,
How to do that ?
I tried this one but atill not work

    // $sql= sprintf("INSERT INTO tb_music VALUES ('$playlist_id','$playlist_name','$user_id','$song','$artist','$plass')",,
                    mysql_real_escape_string($artist, $sql),
                    mysql_real_escape_string($plass, $sql),
                    mysql_real_escape_string($playlist_name, $sql),
                    mysql_real_escape_string($playlist_id, $sql));
 
//

[acoder]

That's not correct PHP. Have you had a look at the PHP manual? You mentioned that your code worked when not using Ajax. Are you sure about that?

[angelhiso]

oh yeah, i got it.
it's just one line to fix it and it is:
$artist = mysql_real_escape_string($_POST['artist']);

your answer is my angel you know ? if i don't have you maybe i have tp geot headach for more time. thanks so much.

[acoder]

That looks more like it. Glad to see that you fixed it.