Printable View
Hello.
Is there a way, that I have a user uploading a file (e.g. blablabla.txt) to my server. but now i don't want the file to be saved there but the text within the file saved to my mysql database... is there a way to realize that since it's pretty complicated to have the user open the file, copy all, paste it into a textarea, submit it.....
plz help!
FES
well, you will have to save it somehow, even if it's just temporarily.
you could try using this (although, it does not have any code to actually upload the file, you'll have to write or find that yourself):
this is untested, but it should be fine.PHP Code:<?
$upload_dir = "./uploads/";
//upload file here
$thefile = "blah.txt";
//check if the upload was successful or not
if(file_exists($upload_dir . $thefile)){
//open and read in the file
$fh = fopen($upload_dir . $thefile, "r");
$fr = fread($fh, filesize($upload_dir . $thefile));
fclose($fh);
//connect to the database
@mysql_pconnect("host", "user", "pass") or die(mysql_error());
@mysql_select_db("database") or die(mysql_error());
//insert the file information into the database
mysql_query("INSERT INTO thetable VALUES ('" . $fr . "');") or die(mysql_error());
//now, get rid of the text file
if(unlink($upload_dir . $thefile))
echo "deleted file";
else
echo "couldn't delete file";
}else{
echo "file does not exist";
}
?>
if you don't know how to upload a file, i can post some sample code for that as well.
No, PHP does that for you. Just read in the contents of the temp file, save them in the DB, then delete the temp file.Quote:
Originally Posted by kows
The PHP documentation for file uploads is very good. Look under the Features main heading.
oops, my bad then. I just looked at/played with an old upload script I made, so you're right.
thanks a lot!!!! is there a way to do the same thing the other way around, if the user wants to download the file.. i know how to create the file, but how do i delete it automatically when the user is done downloading it?
fes
Don't create a file. Just read the BLOB from the database and directly pass it to the user, after emitting the correct headers.
It would be more efficient to store the file physically instead of in the DB though.