special characters

[ligraci]

Hi to all,
I have a great problem with characters like &#39 and &#34.

I made a &#34form&#34in HTML code.
After filling it I assign the text in the field to a $var and print it. If my $var contains single or double quotes this is the result of echo $var;

\&#34text\&#34 \&#39text\&#39

I need this result:
&#34text&#34 &#39text&#39

I tried using the function htmlspecialchars or htmlentities but it doesn&#39t seem work.
Do someone know what can help me?

Thank you in advance for your help.

[[deleted]]

stripslashes()

[ligraci]

Thanks, that function works.
I have (as usual :-() another problem.
When I send my form every time it meets a " it cuts the text in the field.

Example:
If I fill my field with

What a "lovely" day.

it shows

What a day.

How can I solve it?

Thanks again.

[[deleted]]

Depends.. how do you print this text in the field?

[ligraci]

I put the text in the field in a variable $var and send the $var to my database. If $var contains " my text results cutted.

[[deleted]]

Ofcourse it will be cut. :-)

print out your sql statement and you'll see why.

if your string contains quotes, the quotes will be put into the sql statement as quotes.
SQL the reads those quotes not as data, but as part of the statement.

Use addslashes() to make sure all your quotes etc are escaped with a slash before you put them into an sql statement.

[ligraci]

That's really a big problem for me. :-(

Is it possible to use addslashes() only when there are quotes? If yes how can I say it if there are quotes then addslashes()?

[[deleted]]

Why si that a big problem?
when you insert a text into a database, you allways use addslashes().