Howz the article area work

I'm a newbie to Php

I was looking a t you article area and was wondering how you stored articles and retrieved them. Seperating them in stages
eg. Introduction, Conclusion

When I use Asp I simply use an inc file to store the article and record this in a database with a discription, etc for search and index purposes.

It's the wrong way but it works.

How does devarticles do it. Enlighten me please!!!


NB. Great site has got me real interested in Php web development.

devArticles uses SiteWorksPro to run their site. SiteWorksPro is developed by devArticles. It's a good application if you don't know how to setup a site like devArticles or would like to spare the programming time and focus on content.

your db table would need fields like:

id (int, auto increment, primary)
Title (varchar)
Author (varchar)
Description (text)
Body (text)

those are the most common things you would need in your db. the script would just run an Insert query to put the content in.

to retrieve them you would go to a page like article.php?id=3 which would run a Select query and print back the article id 3.

hope it helps.

devArticles uses two database tables for our articles.

The first table stores the default information, such as name, descript, topics, author id, links, related books, forum link, etc

then we have another database that links to the main table,

this contains the page name, page data, article id, and page number, then its just a matter of selecting the right page.

so when you have article.php?aId=2&page=2 it selects from the article page table, where the article id is 2, and page number is 2

Thanks

I heard of siteworks and here it's good but since I wanted to learn Php i thought i try something that will keep my attention.

I am with you with the DB structute but what is interesting according to Ben is the pages are indeed seperate and called when needed.

Cause i was thinking you put indexes in the text that the script would seperate them.

NB. Does siteworks do this forum too


ie. nice animation Ben thought you were more into flash

no, this forum is run with vbulletin