CKEditor 4
Sun, 04/08/2007 - 06:13
#1
bostonphp11
bostonphp11's picture
Joined: 10/06/2004
Posts: 2

problem with (") when submitting to database

Folks,

I am having trouble using this editor when submitting to a mySQL database. I am trying to submit a long text field and if double quotes are used in the text, then it is cut off and not completely stored in the database. The text gets cut off right after the escape character '/'.

Anyone have any idea why this is happening or how to fix it?

I am using version 1.5
Top
Thu, 06/10/2004 - 12:13
bostonphp11
bostonphp11's picture
Joined: 10/06/2004
Posts: 2

RE: problem with (") when submitting to database

Additional Info:

It looks like there is a function in the 'fckeditor.js' file to replace " with it's HTML equivilent. If this worked it would solve the problem but it doesnt seem to. Still need help....
Top
Fri, 06/11/2004 - 01:24
old_goat
old_goat's picture
Joined: 13/07/2006
Posts: 36

RE: problem with (") when submitting to database

Sure its not an issue with mySQL and special characters?
Top
Fri, 06/11/2004 - 01:32
maxell1976
maxell1976's picture
Joined: 08/06/2004
Posts: 4

RE: problem with (") when submitting to database

I have a similar problem when submitting to a FileMaker-database. A (\) is added in front of every ("), and this causes big problems specially when using this in links.

Anybody has a clue on what is going on?
Top
Fri, 06/11/2004 - 02:50
maxell1976
maxell1976's picture
Joined: 08/06/2004
Posts: 4

RE: problem with (") when submitting to database

I found a solution to my problem, but I guess there would be a better way.

I used str_replace('\"','"',$str);
Top
Fri, 06/11/2004 - 02:51
geisi
geisi's picture
Joined: 11/06/2004
Posts: 5

RE: problem with (") when submitting to datab

i parsed the text by php
$text=preg_replace('!(\\\\")!', '"', $text);
so no escapes \" for " are inserted in the database
Top
Fri, 06/11/2004 - 05:52
citanus
citanus's picture
Joined: 11/06/2004
Posts: 6

RE: problem with (") when submitting to database

what add_slashes(), this function is specialy for this
Top
Fri, 06/11/2004 - 07:09
astpaul
astpaul's picture
Joined: 25/05/2004
Posts: 25

RE: problem with (") when submitting to database

you should use the htmlentities() function, should do the trick.
Top
Sun, 04/08/2007 - 06:04
bigmesi
bigmesi's picture
Joined: 08/04/2007
Posts: 2

RE: problem with (") when submitting to datab








http://www.allegro.pl


















Top
Sun, 04/08/2007 - 06:13
bigmesi
bigmesi's picture
Joined: 08/04/2007
Posts: 2

RE: problem with (") when submitting to datab





Top
Twitter Facebook Facebook Instagram Medium Linkedin GitHub Arrow down Phone Menu Close icon Check