Member Avatar for Holy_Assassin

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
  • 52 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by fatihpiristine
Member Avatar for fatihpiristine

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.