943,919 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 1695
  • MySQL RSS
Mar 27th, 2006
0

Project help with database

Expand Post »
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
Similar Threads
Reputation Points: 10
Solved Threads: 0
Light Poster
Brims is offline Offline
44 posts
since Nov 2005
Mar 28th, 2006
0

Re: Project help with database

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.
Reputation Points: 36
Solved Threads: 6
Posting Whiz
Troy is offline Offline
354 posts
since Jun 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: Random unique primary key - is this possible?
Next Thread in MySQL Forum Timeline: User Management





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC