如何获取和播放存储为MySQL BLOB的WAV文件？

Question

I want to get and play the WAV file stored in MySql Db using PHP and Zend-Framework. But I am not able to do so. I want to do this in 2 steps: 1. Convert the BLOB as .wav file 2. Play that .wav file in a new window.

Please help me............

Thanks in advance......

Answer 1

To store the data in the database, you would do something like this:

$tmpName  = $_FILES['userfile']['tmp_name'];

$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

And then you would insert $content into the blob field in the sql query. To read the files, it would be something like:

$query = "SELECT name, type, size, content " .
     "FROM upload WHERE id = '$id'";

header("Content-length: $size");
header("Content-type: $type");
header("Content-Disposition: attachment; filename=$name");
echo $content;

To read the file, just have the 2nd code executed and the file should download. You can point your flash player or what ever you use to the url with the above code, and it should work.

Hope this helped REF: http://www.php-mysql-tutorial.com/wikis/mysql-tutorials/uploading-files-to-mysql-database.aspx