recording html in a mysql database

Posted on 2011-02-15
Medium Priority
Last Modified: 2012-08-14
Hi folks I need to record into my database parts of several html files so that the final html file will be constructed from queries of the database.

Is this possible? How would I go about it?

My idea is to have a field for the head part, another for the body part and other for the footer...

I tried to make it work creating fields as blob but it didn't work so I scraped it all and decided to start from the beginning.

Any help and code will be appreciated.

Question by:doRodrigo

Accepted Solution

asadhaider earned 2000 total points
ID: 34902492

This is a simple tutorial exactly what you are looking for.

You could add an id column and give each page ID's, the relevent title/body content for each page would then be pulled from the database.

Author Closing Comment

ID: 34902608
Thanks, cheers mate!

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this article, we’ll look at how to deploy ProxySQL.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question