What's the best way to store html code in mysql? [duplicate]

Question

Possible Duplicate:
What structure type do I use for HTML content (MySQL)

What's the best way to store HTML code in MySQL?

If I have, let's say an entire page of source code, and I want to save it, what data type should I use for the column in MySQL?

Also, is it better to just save the code as a file, with a filename equal to the primary key, a unique id, created in MySQL (maybe to save space in the data file?)

Answer 1

I would recommend TEXT. I think blobs are more for multimedia etc. than text.

wikipedia blob

Answer 2

Data type to store HTML in Database would be TEXT

But, you have to encode it using mysqli_real_escape_string
$dbh is the database connection handle you used to connect to your MySQL instance using mysqli_connect()

$html="Yor HTML"; $sql = "INSERT INTO tbl (html)  VALUES ('" . mysqli_real_escape_string($dbh,$html) . "')" 

or use Prepared Statements