Inserting a file into a database

[Ryan_Sanders]

I know that you can do this, but I have never learned. How would I go about making a script, where users can upload a file into the database. The file size limit would be 500kb.

And I wanna limit the extension to .rep

Thanks Ryan!

[discostudio]

I wouldn't advise that; It takes up a rediculous amount of space in your dB.

Use the copy() function and copy it to a directory on your server then just tell you db where it is.

$destfile="/uploads/newfile.ext";
$soucefile=$userfile;

copy($_SERVER['DOCUMENT_ROOT'].$destfile,$sourcefile);

mysql_query("INSERT INTO `table`(`id`,`ref`,`name`,`url`) VALUES (NULL,'$ref','Image1','$destfile');

The syntax will obviously be different for your program but I'm sure you get the point. Hope it helps 🙂