Database Design : DB2 + PHP + Windows?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 456,541 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,276 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Database Design advertiser: Programming Forums

Thread Tools Display Modes

Views: 943 | Replies: 1

•

Join Date: Oct 2007

Location: Indonesia

Posts: 1

Reputation: Holy_Assassin is an unknown quantity at this point

Rep Power: 0

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.