Read BLOB from MySql to binary file in PHP?

Question

I want to read the WAV file stored as BLOB in the MySql using PHP. But I don't have any idea about it.

Please help me.....

Thanks in advance.....

SergeS · Accepted Answer · 2011-02-08 19:22:39Z

1

First a simpliest query to select the data , put it into variable and use file_put_contents( ... ) or if you want to send it as downloadable file just use echo and make sure there no junk output and correct header

answered Feb 8, 2011 at 19:22

SergeS

11.9k3 gold badges31 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

MMG Over a year ago

but can you show us the code please? because mine like this doesnt work

while($row=mysql_fetch_array($result)){     $sound=$row['sound'];     echo '<audio controls>';       echo    '<source src="data:audio/mp3;base64,'.$row['sound'].'">';    echo '</audio>';

SergeS Over a year ago

You need to use base64_encode (Or something like this) on $row['sound'] - otherwise you are pulling raw data, while in data URL base64 is specified

Collectives™ on Stack Overflow

Read BLOB from MySql to binary file in PHP?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related