Inserting mpeg3 into a mysql table

[emcb_php]

Hi,

Is it possible for me to read a file (an mp3) and insert it into a db like this:

$mp3_content = @readfile($file);
mysql_query("INSERT INTO mp3 $name, $artist, $album, $mp3_content");

the file var is specified in the querystring and the mysql_connect/close willl be on the script.

Cheers,

Elfyn

[Anon]

you have to use addslashes($mp3_content).

are you sure you want to store an mp3 in a database though?? i would store the mp3 in the filesystem and its path in the database.

paul
http://xhawk.net

[Anon]

$file = join('', file($filename));
$file = base64_encode($file);
mysql_connect();
mysql_select_db();
mysql_query("INSERT INTO mp3 (thefile) VALUES ('$file')");

To recieve the file:

list($thefile) = mysql_fetch_array(mysql_query("SELECT * FROM mp3 WHERE id = x"));
$file = base64_decode($file);