I am in the process of designing a site and I would like to know what is the best way to do it. My site is mostly tutorial. Should I put everything as blob in a database or should I just leave everything as html file. How do people do it?
separate the data from the html and use php to show the items on the page. I don't know what items you plan to hold in the DB, so it makes this kinda tough to answer.
hth Bastien
There are many ways to skin this cat,
but it still tastes like chicken
I'm in the process of creating a project to store similar types of information. I'm going to use PHP with mySQL. My plan is to store the content in .XML files and use my PHP/mySQL database to manage the content. Putting the content in .XML files will allow me to use PHP to search the files without having to search text within blob fields. Then presenting the content can be done by putting the .XML file through a PHP routine to make the it 'pretty'.
The blob field is almost out of need. Some people use it for images, dont, some for large texts, oke.
But most time dont use it. If u want to put text in de DB use text, in that way u can always search in it, else put an url in the database with the location of the text files. (this works best is my expirience). mcvdmvs
mick@nederland.net
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.