Database Design

Database Design : DB2 + PHP + Windows?

Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2007

Posts: 1

Reputation: Holy_Assassin is an unknown quantity at this point

Solved Threads: 0

Holy_Assassin Holy_Assassin is offline

Offline

Newbie Poster

Database Design : DB2 + PHP + Windows?

Oct 12th, 2007

Hello everyone!
I've been thinking to design a web-based database (in DB2 and PHP) for my father's company, but I need some help because I don't know where to start.

Details:

The database will be used to store Microsoft Office's files (Word, Excel, Powerpoint, Publisher) and Adobe files (Indesign, PageMaker, and Photoshop).
The table will contain these fields:
1. ProductCode (Example: IPS50LM) - This is used for the recognize the type of product
2. FileName (Example: IPS50LM_Brochure) - Self Explanatory
3. Size - Self Explanatory
4. Type (Example: Microsoft Word)- Self Explanatory
5. Date Created - Self Explanatory
6. Last Modified - Self Explanatory
7. File Path (Example: C:\MyDoc\IPS50LM\IPS50LM_Brochure.doc) - The path for the file.
8. FileNotes (Example: Brochure for Client no.1) - Self-Notes
The Features:
1. Insert
2. Delete
3. Update
4. Search
5. Open Files (By double-clicking on the entry and it will open the appropriate program for the file type.)

Now the biggest problem is: How am I supposed to make the Windows OS opens the appropriate program for the double-clicked file?
Can anyone help me?

Thank you in advance!

Best Regards,
Guinevere

PS: I am a complete newbie on Database.

Last edited by Holy_Assassin; Oct 12th, 2007 at 12:27 pm. Reason: Forgot to include the Post Script.