Opening audio files

[frobak]

Hi

 

Im making a real simple audio download page with a counter on each download, nothing fancy, just need the job done. So the basics are i want a user to click on a link, and i want it to update a database table, which works fine, but i want it to also open the audio file for download, which i cant get to work.

 

The script im trying to run is as follows:

 

<?php

include '../functions/db_connect.inc.php';

 

$sql = ("INSERT INTO downloadcount

(downloadid) VALUES

('$_REQUEST[downloadreq]')");

 

$result = @mysql_query($sql,$connection) or die(mysql_error());

 

$handle = fopen("../mixes/milli.mp3", "r");  <----------this not working??????????

 

header('Location: ../index.php');

?>

 

Am i barking up the wrong tree? or can i get this to work? any help appreciated.

 

cheers

 

fro

 

 

[JasonLewis]

You need to use the php header() function (like with re-direction), but too force the file download. I think there is an example on that page.

[frobak]

Ive tried this but it opens the index page and not the mp3?

 

<?php

include '../functions/db_connect.inc.php';

 

$sql = ("INSERT INTO downloadcount

(downloadid) VALUES

('$_REQUEST[downloadreq]')");

 

$result = @mysql_query($sql,$connection) or die(mysql_error());

 

$filename = "milli.mp3";

$myFile = "/mixes/milli.mp3";

 

$mm_type="application/octet-stream";

 

header("Cache-Control: public, must-revalidate");

header("Pragma: hack"); // WTF? oh well, it works...

header("Content-Type: " . $mm_type);

header("Content-Length: " .(string)(filesize($myFile)) );

header('Content-Disposition: attachment; filename="'.$filename.'"');

header("Content-Transfer-Encoding: binary\n");

 

readfile($myFile);

 

header('Location: ../index.php');

?>