Need help retrieving mysql data with " and ' in the value

[kts]

I am trying to retreive data with " and ' in the info        ex. "24" 7'" (24ft 7in)

 

I did the add slashes to add it to the database, but whats the best way of getting it into a text box without problems? input text

[DarkWater]

You should have used mysql_real_escape_string() rather than addslashes().

[phoenixx]

Use mysql_real_escape_string when inserting the data

 

but use stripslashes just to be safe on output

echo stripslashes($str);  // WHERE $str is your variable name

[kts]

Ok tried that solution, but the problem isnt output normal, it is when i put it in a value of  a text box it shows up stripped (24) instead of (24" 5')

 

is there a specific way for input text?

[kts]

did not find the solution, but found an alternate route. It shows up fine in a textarea.

[DarkWater]

You need to use htmlentities($string, ENT_QUOTES) on ANY value going into an HTML attribute.  I didn't know what you were talking about originally, otherwise I would have suggested the proper solution.

[wildteen88]

did not find the solution, but found an alternate route. It shows up fine in a textarea.

if it works with a textarea then it means before you was not coding your <input>'s correctly. The only way I see the problem you're having is if you don't wrap attribute values with quotes.

[DarkWater]

Actually wildteen, it was because he had " or ' inside of his value attribute, which screwed everything up.

[discomatt]

Actually wildteen, it was because he had " or ' inside of his value attribute, which screwed everything up.

 

Indeed, and because textarea doesn't use attributes to populate itself, it worked.

 

A quick look at the outputted source code would've made this clear.

[wildteen88]

Actually wildteen, it was because he had " or ' inside of his value attribute, which screwed everything up.

Woops, You're right. Ignore my post.