php playback mp3 from postgresql bytea

[himlastar]

Hello!

 

I'm trying to playback a song from database, and it doesn't play, can someone please help?

 

My code right now...

$conn = pg_connect("user = postgres password = admin host = localhost dbname = wavecloud");
$res = pg_query($conn, "SELECT audio_file FROM audio_files_2 WHERE title = 'abcdefu';");
$raw = pg_fetch_result($res, 'audio_file');

echo '<audio controls>'; 
echo '<source
src="data:audio/mp3;base64,'.base64_encode($raw[0]).'"‌>';
echo '</audio>';

 

[requinix]

Read the documentation for pg_fetch_result to find out what $raw is.