This topic is locked

Hearing mp3 files

4/6/2016 7:22:00 PM
PHPRunner General questions
M
mrfdes author

Hello,

I have made a form on a website where people can apply to work for a radio station, and one of the requirments is that they upload a short mp3 file with some of their work.
This file is stored in a MySQL database as a BLOB type.

I have now set up a system with PHPRunner Enterprise 8.1 so the site owner can go through the applications, but the only problem is that the uploaded file only shows its title, there is nothing you can click on to listen to it or to download the file (just listening would even be better).
I obviously have done something wrong, I only wish I knew what.

Should I replace the file placeholder with a certain filetype or anything else, as I am not sure what to do.
At the moment I set up the form and just kept clicking through, but that obviously was not the answer.
Any help/advice will be much appreciated.

Sergey Kornilov admin 4/6/2016

Setting 'View as' type of this field to 'Audio' should be enough.

M
mrfdes author 4/7/2016



Setting 'View as' type of this field to 'Audio' should be enough.



Thank you.

That is obviously the first thing I thought of, but when I do that, a player appears, but as soon as I click the "Play" button, it disappears.
Also, when I go to the list of "View as" and select Audio, the field name (FileUpload) is the only one not appearing in the list.

All the other ones (Name, Email, etc. do).
I attach two screenshots of how the files look in the MySQL database to see if everything is correct there.

The first one is how the field is shown, and the second one shows what happens when you click on the filename in the database:



And when I open the file from the database, it plays.

Any idea where the fault could be?
Thank you.

Kind regards.

Sergey Kornilov admin 4/7/2016

Sounds a bit strange, should work. Maybe the issue is with file extension being .bin instead of .mp3?