PHP: How to store HTML as it is in MySQL?

Question

I know mySQL has no issue to store html tags as it is. I want to know how can I store just by escaping commas, and quotes and put HTML as it is in PHP?

To give further idea, I fetched a SQL backup and now transferring in other db by using a PHP script. The data I have in tables have HTML in original format.

No you do not store "escaped" data. You escape the data when you use it. — Salman A, Nov 17 '15 at 06:51
Just use PDO/mysqli AND prepared statements. They will take care of any escaping for you — Strawberry, Nov 17 '15 at 07:19
You store it as any other string data. There is literally no magic around html so that it was treated differently. — zerkms, Nov 17 '15 at 07:22
You're talking about storing HTML that you buffered, and dumped to the database. That's done with output buffering. — i am me, Nov 17 '15 at 07:30
Possible duplicate of [What's the use of ob\_start() in php?](http://stackoverflow.com/questions/4401949/whats-the-use-of-ob-start-in-php) — i am me, Nov 17 '15 at 07:31
@Strawberry you probably missed the point. I am suggesting that OP stores `` instead of `<a href = "mike\'scafe.html">` — Salman A, Nov 17 '15 at 11:23

score 0 · Answer 1 · answered Nov 17 '15 at 07:26

in the code below you will be putting the HTML being processed:

        ob_start();
        //rendering html

        //end of rendering html
        $html = ob_get_contents();
        ob_end_clean();
    echo $html;

        $sql = $pdo_conn->prepare("INSERT INTO processed (`id`, `html`, ) VALUES (:id, :html)");
        $sql->bindParam(':id', $id);
        $sql->bindParam(':html', $html);
        $sql->execute();

score 0 · Accepted Answer · answered Nov 17 '15 at 07:30

0

Use htmlentities($myHtml, ENT_QUOTES) when retriving the html and Use mysqli_real_escape_string($connection,$myHtml) before inserting to database

answered Nov 17 '15 at 07:30

Cr1xus

427
3
20

1

See prepared statements – Strawberry Nov 17 '15 at 07:56
@cr1xus You need to assemble the HTML before you enter it into the database, which would be most easily done with creating a PHP output object with ob_* – i am me Nov 17 '15 at 20:24
@3.14159265358... `ob_start` will not work here as I am not outputting page HTML – Volatil3 Nov 18 '15 at 04:33
Mysqli is meant for mysql databases only. – i am me Nov 18 '15 at 21:18

PHP: How to store HTML as it is in MySQL?

2 Answers2