[thelist] PHP/PostgreSQL

[Daniel J. Cody]

Jay,

How about something like this:

Create the table in the DB that has the fields you mentioned, plus an 
extra one called something like 'file path':


SQL> desc users
  Name                                      Null?    Type
  ----------------------------------------- -------- -------
  ARTIST                                    NOT NULL VARCHAR2(100)
  GENRE                                       NOT NULL VARCHAR2(50)
  SONG_NAME                                     NOT NULL VARCHAR2(100)
  FILE_PATH                                NOT NULL VARCHAR2(100)
  SONG_ID	 
			NOT NULL NUMBER(8)

for example..

Then when you pull up the song you want to hear either by search or 
whatever, the php page would show display that info however you wanted.. 
the trick would be to have a link around the song name with the filepath 
info around it like so:

<a href="file:///F:\music\mp3s\beegees\you_should_be_dancing.mp3">You 
Should Be Dancing</a> by the Bee Gee's.

So that when you clicked on the link, it would open up whatever you have 
associated with the .mp3 extension, like WinAmp and you're groovin to 
the Bee Gee's :)

This assumes that you have a list of where each file sits on your hard 
drive or mapped network drive. There are a hundred utilities that will 
do it for you on download.com

Basically, when you input the info like artist and song name into the 
DB, insert some information in there as well about where the file is. 
Then use 'file:///' in your <a> tag to link to it.

Hopefully that helps you out, shout if you have any more questions. :)

.djc.



Jay Fitzgerald wrote:

> I have an idea for a project I want to try; here's the scenario:
> 
> I have approximately 6,400 mp3 files...what I am thinking of doing is
> making an SQL database which contains all the the song titles along with
> artist and possibly genre to which they belong...then have a PHP file
> that would allow you to view all songs by title, artist or genre;; but
> would also allow you to search for a specific song...when the results
> are displayed, the visitor to the page could click on the song they want
> and it would play right from the web or execute their default mp3
> player...
> 
> I know it will be extremely tedious and nerveracking - but IS it
> possible? if not - fine; but if it is possible, does anyone have ideas
> for where I should begin and how I can execute an external program via
> this type of interface.