User Name Password Register
DaniWeb IT Discussion Community
All
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.
Please support our Database Design advertiser: Programming Forums
Views: 943 | Replies: 1
Reply
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's Avatar
Holy_Assassin Holy_Assassin is offline Offline
Newbie Poster

Help Database Design : DB2 + PHP + Windows?

  #1  
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.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Sep 2007
Location: Budapest
Posts: 252
Reputation: fatihpiristine has a little shameless behaviour in the past 
Rep Power: 0
Solved Threads: 14
fatihpiristine's Avatar
fatihpiristine fatihpiristine is offline Offline
Posting Whiz in Training

Re: Database Design : DB2 + PHP + Windows?

  #2  
Oct 17th, 2007
design your database first and structure
primary keys, foreign keys, ids, relations between tables,
then user interface "web forms"...
Do a favour, leave me alone
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Database Design Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the Database Design Forum

All times are GMT -4. The time now is 4:57 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC