Solved

recording html in a mysql database

Posted on 2011-02-15
2
939 Views
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.

Cheers!
0
Comment
Question by:doRodrigo
2 Comments
 
LVL 2

Accepted Solution

by:
asadhaider earned 500 total points
ID: 34902492
http://php.about.com/od/phpwithmysql/qt/php_in_mysql.htm

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.
0
 

Author Closing Comment

by:doRodrigo
ID: 34902608
Thanks, cheers mate!
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

759 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now