How to output multiple line mysql string from database without quotes

Question

I'm retrieving a string from a database that was entered by a form, but if the string is to long, it's generated with double quotes in the html. This is how I'm retrieving the data:

echo '<p>' . $descr['field_value'] . '</P>';

When I view the html source, the browser adds double quotes.

short single line strings do not show up with quotes.

Is there a way to force php to display strings without quotes?

PHP wouldn't be adding quotes to your data, and the database shouldn't either. If quotes are appearing, it would have to be when the data's being inserted into the DB in the first place. Have you run the queries manually from the mysql monitor to see what comes out, without PHP being involved? — Marc B
– Marc B, Commented Dec 20, 2010 at 21:48

Andre · Accepted Answer · 2010-12-20 21:13:14Z

1

You should use echo '<p>' . htmlspecialchars($desc['field_value']) . '</p>';.

See http://php.net/manual/en/function.htmlspecialchars.php for more details.

answered Dec 20, 2010 at 21:13

Andre

3,18125 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

How to output multiple line mysql string from database without quotes

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