DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)
-   Database Design (http://www.daniweb.com/forums/forum142.html)
-   -   Database Design : DB2 + PHP + Windows? (http://www.daniweb.com/forums/thread92738.html)

Holy_Assassin Oct 12th, 2007 12:25 pm
Database Design : DB2 + PHP + Windows?
 
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.

fatihpiristine Oct 17th, 2007 4:51 pm
Re: Database Design : DB2 + PHP + Windows?
 
design your database first and structure
primary keys, foreign keys, ids, relations between tables,
then user interface "web forms"...


All times are GMT -4. The time now is 7:30 pm.

Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC