Project help with database

Reply

Join Date: Nov 2005
Posts: 44
Reputation: Brims is an unknown quantity at this point 
Solved Threads: 0
Brims Brims is offline Offline
Light Poster

Project help with database

 
0
  #1
Mar 27th, 2006
I am building an online music video library where u can strean the media to ur browser mobile phne and pda devices. I am using PHP for the middle HTML for the front end and MYsql for the backend.

I want to have database with the music files residing on them but I dnt know where to start if I could be given some advise I would be greatfull.

I have started and this is what i have so far. I have untill MAY 4th to do it but i am open to any criticism and any ideas that will help me

http://itsuite.it.bton.ac.uk/student/iak/m/
http://itsuite.it.bton.ac.uk/student/iak/m/login.php
The functionality is a member logs in or a user can browse the song list

members have to be rcognised by the database which i havnt done yet

and non members can join which i have done and linked to the database but does not remember as a member,

a member has a personal library also where the songs that they browse can be added to their personal library
Reply With Quote Quick reply to this message  
Join Date: Jun 2005
Posts: 354
Reputation: Troy is an unknown quantity at this point 
Solved Threads: 5
Troy's Avatar
Troy Troy is offline Offline
Posting Whiz

Re: Project help with database

 
0
  #2
Mar 28th, 2006
Although you can store large binary data blobs (such as MP3s) in a database, I recommend you store the media files as normal files in the filesystem. Use the database to store meta data--that is data about the media files, but not the media files themselves.
Troy Wolf is the author of SnippetEdit. "Website editing as easy as it gets." IX Web Hosting
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the MySQL Forum


Views: 1579 | Replies: 1
Thread Tools Search this Thread



Tag cloud for MySQL
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC