Jump to content


Photo

online application


  • Please log in to reply
1 reply to this topic

#1 wutang

wutang
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 28 May 2006 - 04:46 PM

Hiya all

I am developing an online music application in php mysql. I wanted to know when my members login they can add music tracks to their personal library so when they log back on there library page will have each track they updated their library with

#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 28 May 2006 - 07:40 PM

You need at least 2 db tables, member and track

When they upload a track, store the path/filename in the track table with their member_id and other details

Tables
member              track
---------           ----------
member_id <---+     track_id
username      |     title
password      |     filepath
etc           +---- member_id

Sample data
track
-------
id |  title               |  path           |  member_id
 1 | Moon River            | xxx/000001.mp3  |     1
 2 | Nessun Dorma          | xxx/000002.mp3  |     1
 3 | Birdie Song           | yyy/000003.mp3  |     2
 4 | My Old Mans a Dustman | yyy/000004.mp3  |     3

Select tracks with their id from track table when the go to their library page.
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users