David,
MySQL is up to the task. Oodles of people doing this. We do something similar for course syllabi, thousands of documents (currently 113,676), both in XML and HTML, which can be as large as 100 pages when printed. I'm sure there are examples out there with more impressive statistics.
Mike
David Blomstrom wrote:
I finally got my PHP add/edit form to work. While working on it, it occurred to me that I could use it to post and modify more than bits of data in tables. I could use it to make pages that people with no web design skills can add articles to.
Most of my post focuses on PHP; my main question regarding MySQL is this: Is it a good practice to use MySQL databases for entire articles? By "article," I mean anywhere from two to over 100 paragraphs, along with HTML coding and perhaps some images.
I know I haven't invented the wheel; I'm sure people are already doing this or using a similar method. I'm just new to this "content management" stuff, so I'm just learning the ropes.
Anyway, this is my plan:
Suppose I put 50 pages focusing on the 50 states online. But each page's body section is empty, except for a link to a single cell in a MySQL table. The cell corresponds with a field named "Articles," and an echo statement in the page's head section further specifies a state (or row), such as Alaska.
Thus, a client could write an article about Alaska, insert a couple images, then copy the HTML.
Next, he would access my add/edit page, click the Alaska row and find the "Articles" cell/field.
Then he would paste the article into the cell and submit it. He effectively created a web page focusing on Alaska without REALLY creating or uploading a page.
Does this sound like a good idea, and is MySQL up to the task?
Thanks.
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
-- http://mike.kruckenberg.com | michael at kruckenberg.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
