Missing Part Of String During Mysql Insert

Question

So maybe im just dumb or tired right now and am missing the obvious or whatever but why is this mysql insert cutting the string off at the double quotes (")>

the contents of the posted field is: It's my text "quote"

$gpCaption = mysql_real_escape_string ($_POST['gpCaption']);

$sql = "INSERT INTO galleriesphotos SET gpID = '$gpID', gID = '$gID', gpCaption = '".$gpCaption."'";
$rows = $db->query($sql);
}

Only this gets inserted into mysql: It\'s my text \

what happened to the rest of it?

How are you reading it back from the database and displaying it? — Mark Byers
– Mark Byers, Commented Apr 19, 2012 at 18:49
Looks like a possible magic_quotes issue? (will those ever go away?) What happens if you print $sql? What happens if you change the structure to this: "INSERT INTO galleriesphotos SET gpID = '$gpID', gID = '$gID', gpCaption = '{$gpCaption}'"; What happens if you put in a debug breakpoint and look at the value of $gpCaption? (or var_dump()?) — Kato
– Kato, Commented Apr 19, 2012 at 18:58

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

Are you sure it is cutting? if $_POST['gpCaption'] is =

It's my text "quote"

This escaping result of this is:

$gpCaption = mysql_real_escape_string ($_POST['gpCaption']);

It\'s my text \"quote\"

And when I insert it in a table, I can see it without a cutoff:

ID FIELD

1 It's my text "quote"

Here is the sql fiddle test:

http://sqlfiddle.com/#!2/e5059/1

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Apr 19, 2012 at 18:58

Nesim Razon

9,8043 gold badges38 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Missing Part Of String During Mysql Insert

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related