Reputation: 37
I am developing an android app that download songs(so type of data is blob) from db.
I have the following download image code example:
<?php
if($_SERVER['REQUEST_METHOD']=='GET'){
$id = $_GET['id'];
$sql = "select * from images where id = '$id'";
require_once('dbConnect.php');
$r = mysqli_query($con,$sql);
$result = mysqli_fetch_array($r);
header('content-type: image/jpeg');
echo base64_decode($result['image']);
mysqli_close($con);
}else{
echo "Error";
}
How do I change "header" and "echo"(under header) to download an mp3 audio file ?
Upvotes: 1
Views: 54
Reputation: 3242
You'll want to send the following header for a .mp3 file:
Content-Type: audio/mpeg3
Refer to https://www.sitepoint.com/web-foundations/mime-types-complete-list/ for a good list of MIME types.
Upvotes: 1