0

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.

2
Contributors
1
Reply
3
Views
9 Years
Discussion Span
Last Post by fatihpiristine
0

design your database first and structure
primary keys, foreign keys, ids, relations between tables,
then user interface "web forms"...

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.