Uploading and downloading music files to and from Mysql
I have to make a website with a database for a CS class at university that allows the user to search for a piece of music or a particular sound effect, preview the media and then have the option to download or implement another search.
My issue is how do I go about uploading the music/fx files to MySQL, and then retrieving them?
In terms of populating my web page with the items from the database I know can do that by using tables but in terms of getting the files into the db via the webpage, this is still a bit confusing to me.
I've seen somewhere that I need use filetype blob/longbow which will house the file location of the media file but they didn't go into great detail on how to do this or in fact what a blob is.
Any help would be massively appreciated.
Thanks in advance