Store code in mysql (HTML, PHP etc)

Question

I want to store HTML and PHP in mysql db, i'm unsure as to what field type i should use TEXT or BLOB?

amosrivera · Accepted Answer · 2011-01-15 06:35:07Z

4

Text (if it is code) unless you want to store the php/html file itself, blob is meant for binary data such as images and files.

answered Jan 15, 2011 at 6:35

amosrivera

26.6k9 gold badges70 silver badges76 bronze badges

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

Comments

Wasim Karani · Accepted Answer · 2011-01-15 06:55:27Z

0

Yup... that would be funny to search it... and if you do put html into a db, don't plan on using phpMyAdmin, or at least older versions of it. Can make quite a mess.

Generally the "commonality" uses flat-files (like .tpl files) for the html. This keeps your DB clean, and remember large amounts of data in a single field can produce somewhat slow results.

Also For search options, you will have to write code to surpass any html tags from the text. This can be done but needs to be coded properly.

edited Jan 15, 2011 at 6:55

answered Jan 15, 2011 at 6:40

Wasim Karani

8,87410 gold badges58 silver badges100 bronze badges

Collectives™ on Stack Overflow

Store code in mysql (HTML, PHP etc)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related