PDA

View Full Version : Database 'type'


Coober
07-07-2005, 02:20 PM
I am starting two projects that require use of a database, but this subject is completely new to me. I have some experience with databases from some years ago, but never in conjunction with a web application.

I would like to know if there is a particular database 'type' that would be more suitable for the purpose than another.

1. This will be an on-line newspaper. All articles will be assigned an 'articleNumber' and retrieved when the viewer clicks on a small sampler or the story.

2. I need to store passwords and usernames for a simple log-in page.

Thanks in advance,

Coober

tmilewski
07-10-2005, 07:05 AM
MySQL Database with 2 Tables

FORMAT->
column name // type // description


Table: Members

id // int (auto increment) // creates a distinct number for each entry
username // tinytext // field for usernames (use some sort of encryption)
password // tinytext // field for passwords (use some sort of encryption)
email // tinytext // probably want this to email PWs if people need it



Table: Articles

id // int (auto increment) // creates a distinct number for each entry (your 'articleNumber')
timestamp // tinytext // date and time of article(See #1 below)
title // text // title of article
body // text // body of article (See #2 below)


#1 -> I prefer to use PHP's time() function and just store it in a tinytext field rather than using MySQL's TIMESTAMP type.

#2 -> take 'body' and use PHP to parse it and create a 'sampler' of your story to be clicked on for further reading