Best way to store artilces

VLE79E

Hello

I am trying to create a website for famous people; something like bibliography. Each person will have little info and an article about him/her. Of course, these articles are formatted. The question is what is the best way to store these articles? Should I leave each article in separate html or should I store them in a database. I also want the user to be able to search these articles?

Please help.

planetsim

To save you time.. Make A Database and you'd only need one file max to show the biograhphy.. Making life easy for you...

Its also a very good way to search the bio's...

ednark

simplest way is one html page for each person... however.. this possible the most horrible way to search as planetsim already said...

you probably want your stuff structured so you can do this though

http://yoursite.com/famousperson?name=anna

and perhaps give several parameters...

if there is only one match.. say if you passed ?id=1123 it would display that person's page

if you passed say ?name=anna then it would display all the famous people with name anna

or ?birthdate=2002 and it would show all 1 year old famous people

for this you need a sql database

planetsim

Like ednark said and i said... If you need the Search Capabilities than use a Database otherwise use html....

Databases are only really needed for huge amounts of data that can be related to one another...

Meaning if i have 1000 articles a database would be better than 1000 html files

as i can cut it down to one or two files.. Thus saving space.. But i guess it comes down to you.. Whatever you want..

ednark

Like planetsim said i said he said....

you could always mix the two

create table KEYWORDS
(
keywords text,
page_name varchar(32)
)

so now you can search... and just have html...

but if you are going to out that much in the databse you might as well put it all

VLE79E

Ok.

As you Gurus said... Database it is...

Now... How about formatting? The Article will have formats or may have a picture or so..

What do you think?

ednark

im assuming you are using mysql... though i might suggest postgres....

however... go to mysql.com and look up the basic types you are allowed to store...
integers, text fields, variable character fiedls, binary fields....

you will have to decide wether to store the whole image itself in sql or to store just a string of the path to the file...

what parts of your article do you have....
some sort of internal id im sure
an author
a posting date
the body html of the article

any other fields

basical you want to try store each article as a row in a table caled ARTICLES or something...

then if you want a specific article you can say

SELECT * FROM ARTICLES WHERE author='ednark'

SELECT * FROM ARTICLES WHERE body LIKE '%php%'

and these will return a list of articles .....

how familiar are you with sql?

BuzzLY

Originally posted by ednark

SELECT * FROM ARTICLES WHERE author='ednark'

Ednark, I had no idea you were famous!! Can I have your autograph? 😃 😃 😃

ednark

3dn4r|<