FUDforum: comp.lang.php » PHP/MySQL oddity

Home » Imported messages » comp.lang.php » PHP/MySQL oddity

Show: Today's Messages :: Polls :: Message Navigator

PHP/MySQL oddity [message #175480]

Sat, 01 October 2011 18:14

Mason Barge
Messages: 5
Registered: November 2010

Karma:

Junior Member

I've been building a form that takes default text input from a database
(PHP 5.2, MySQL 5). It's to allow a user to modify previously entered
text without rewriting the entire thing.

The database comes from user input and it handles uploading apostrophes to
the database and then downloading them into plain HTML fine. But when the
same downloaded variable is put into a text input in a form, the
apostrophe and everything after it is truncated.

Running the variable through either addslashes() or
mysql_real_escape_string() adds a backslash, but not the apostrophe!

If that's not clear, I do a SELECT query and take, say, the "info" column,
set its value to $info, and write:

<form name=...><input type=text . . . value = '<?php echo $info;?>'

Or echo the whole thing, or double quotes around the variable. I just
can't figure out how to make the apostrophe appear to save my life.

This only happens in <input type=text> where the field is VARCHAR. I also
have textarea input (i.e. <textarea . . .>$info</textarea>) that download
their value from a TEXT column but they function fine!

Report message to a moderator

[Message index]

		PHP/MySQL oddity By: Mason Barge on Sat, 01 October 2011 18:14
		Re: PHP/MySQL oddity By: Luuk on Sat, 01 October 2011 18:31
		Re: PHP/MySQL oddity By: Mason Barge on Sat, 01 October 2011 21:31
		Re: PHP/MySQL oddity By: Denis McMahon on Sat, 01 October 2011 22:23
		Re: PHP/MySQL oddity By: Thomas 'PointedEars' on Sun, 02 October 2011 02:30
		Re: PHP/MySQL oddity By: Jerry Stuckle on Sun, 02 October 2011 13:55
		Re: PHP/MySQL oddity By: Arno Welzel on Sun, 02 October 2011 17:35

Previous Topic:	OCI.DLL and libcs.dll?
Next Topic:	Re: NoDQ.com > Columns > WWE Hell in a Cell Preview by TJR Staff

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 04:37:58 GMT 2024

Total time taken to generate the page: 0.05161 seconds