How do you write HTML in a MySQL database field and echo it with PHP?

Question

I'm stuck trying to echo my product descriptions correctly for my eCommerce store.

Is it possible to write formatted HTML (i.e. with elements and tags... to youtube links, etc) as text in a MySQL description field and then echo it with PHP correctly formatted?

At the moment I am using...

<?php

  echo "<p>".Helper::encodeHTML($product['description'])."</p>";

?>

...but as I say it doesn't output as formatted.

Thanks for the help! :)

Edit; Fixed for the moment ('less anything changes) with...

echo html_entity_decode($var['string']);

i.e.

echo html_entity_decode($product['description2']);

https://www.php.net/manual/en/function.html-entity-decode.php

what framework or library is this Helper::encodeHTML from? — developerwjk
– developerwjk, Commented Jul 27, 2015 at 23:00
if you trying to echo $product['description'] it is not good? without Helper::encodeHTML — Pierre-Luc Bolduc
– Pierre-Luc Bolduc, Commented Jul 27, 2015 at 23:05
It seems like the 'Helper::encodeHTML' is removing the html tags. As you can just save it with html tags and echo it. — Nytrix
– Nytrix, Commented Jul 27, 2015 at 23:08
I'm not sure. Sorry, I'm such a newbie. I just checked out another post... stackoverflow.com/questions/8381651/… ...can I do something like that, but echo $product['description]? I'm using PHPMyAdmin and the description field is set to text. Thanks! :) Yes, the tags are posted but not formatted correctly as HTML markup. — Ashley Smith
– Ashley Smith, Commented Jul 27, 2015 at 23:08
Actually it might be working ok. I think I need to add a second field called description2 and add HTML there instead, as I'm echo'ing this in two places... one using Helper::shortenString to shorten the description, and then parse the full description on the product page. — Ashley Smith
– Ashley Smith, Commented Jul 27, 2015 at 23:13

Romnick Susa · Accepted Answer · 2015-07-27 23:14:39Z

0

How about removing the p tag and echo it as is?

    <?php
    echo Helper::encodeHTML($product['description']);
    ?>

or echo it with htmlentities() like this:

    <?php
      echo htmlentities($product['description']);
    ?>

or echo it directly like this:

    <?php
      echo $product['description'];
    ?>

answered Jul 27, 2015 at 23:14

Romnick Susa

1,28814 silver badges34 bronze badges

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

1 Comment

Ashley Smith Over a year ago

Those don't seem to work, it just outputs the tags and doesn't format... i.e. <h1>Contents: -</h1> <iframe width="420" height="315" src="youtube.com/embed/XGSy3_Czz8k?autoplay=1"> </iframe>

Collectives™ on Stack Overflow

How do you write HTML in a MySQL database field and echo it with PHP?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related