Welcome to WebmasterWorld Guest from 220.127.116.11
I have a mysql database, an artist is selected. the artist may have a number of mp3s associated with them. how can these be played in a web browser. can they be loaded into quicktime for example? if there is more than one audio file, how can i auto play the first, then allow users to stop it, and select another?
it would be great if the solution could also be applied to movies, which are associated with artists in the same way
j milo taylor
i guess the php code is not going to be that complex, and i would like to expand my knowledge (rather than paying for the benefits of someone else's work)
...ensure...playable by everyone...flash solution
Just embed it. Use a search engine for the html end ('embed music file'). If you're pulling the actual binary data from a db table, the source will be a php script. The script will send a header like audio/mpeg and then the data pulled from the table. If you're just storing the file name in the table, that's a whole lot easier, just echo the file name into the embed element.
Believe it or not, not everyone embraces that junk. Some people believe that effective, highly functional web sites can actually be designed without forcing their visitors to load that onto their computers. But I digress - I must have been temporarily blinded by some sort of bright yet useless light.
thanks for you advice, it really works a dream. so simple, i've been trying to get this done for onths , your post really made it 'click'.
to address some of the other posts, well, the solution outlined by cameraman is so simple, and so useful, i really don't need to use flash in any way.
thanks again everyone for your comments