2. PHPRunner General questions
  3. Music
This topic is locked

Music

 		10/13/2009 4:26:17 AM
PHPRunner General questions
T
 thesofa author

Greetings all.

I am working with a few bands at the moment, recording all our rehearsals and pulling any decent sounding tracks out of the mix.

I want to be able to upload them easily, and store the details in a database, ie track name, who plays what, which band, original artist, score file, in sibelius or Guitar Pro format, etc.

Suggestions please for the best way of storing these files and how to make an upload easy, so I do not have to use FTP clients, also I need to be able to allow a different uploader for each band, so I would have several 'sub-admins' so to speak.

I have never worked with uploading and storing files, do I put the MP3 or OGG or WMV files into a Blob field? or store them externally and just have a field which links to the file?

All suggestions welcome please.

Cheers
J
 		Jane 10/13/2009

Hi,
I recommend you to store files in the separate folder on the disc and save links to these files in the database.

Create text field in the database for that and set up it as File/File on the "Edit as" settings/"View as" settings dialogs in PHPRunner.
T
 		thesofa author 10/14/2009



Hi,
I recommend you to store files in the separate folder on the disc and save links to these files in the database.

Create text field in the database for that and set up it as File/File on the "Edit as" settings/"View as" settings dialogs in PHPRunner.



will that give me a clickable link in the database table to run the file in my browser?

Can I upload files or a file at a time from the PHPR interface created ?
J
 		Jane 10/15/2009

Hi,
sure you can upload and then download files on the PHPRunner-created pages.

You need external application/script to run mp3 files in browser.
T
 		thesofa author 10/15/2009



Hi,
sure you can upload and then download files on the PHPRunner-created pages.

You need external application/script to run mp3 files in browser.



Thank you
T
 		thesofa author 10/29/2009

I have just looked aT THE TUTORIAL ABOUT UPLOADING FILES TO A DATABASE AND IT RELATES TO PICTURE FILES, PRODUCING A THUMBNAIL IN THE DATABASE WHICH IS A CLICKABLE LINK TO AN IFRAME SHOWING THE MAIN PICTURE, CAN i DO A SIMILAR THING WITH MP3 FILES SO I GET A LINK, WHEN CLICKED IT OPENS AN IFRAME IN WHICH THE MUSIC PLAYS?

sorry about the caps lock, dammed fat fingers again
J
 		Jane 10/29/2009

Hi,
unfortunately there is no such functionality in PHPRunner.