PHP database browse/download

onlinegamesnz

hi, would anyone know of a good script which uses a database to manage files..jst a simple non member upload and file browse and download script with MYSQL? im despirate

thanks

dagon

store their names in the db not the files

onlinegamesnz

can i store files in the database? anyone know a good download / upload script i could use?

Piranha

It depends on what dbms you use, with some you can store files but not with others. But why would you want to store the files themselfes in the database and not only the path and names?

onlinegamesnz

ha i have no idea... i thought u stored the files in the database itself...guess not...so if im right, the file is uploaded to the server and some sort of URL to the database? heres what i need...users login to download/upload....so the files appear when they are logged in...but then if the copy the URL cannot point to tht url from any web browser and download the file?

how would i do this?

cheers

Weedpacket

When you save the file on the server, you save it some where in the filesystem. So you have /some/sort/of/path/to/the/file. Save that in the database. It's a filename, not a URL.

Then have a script that (if the user is logged in) retrieves the file (having got the filename from the database) and outputs it. The URL is for that script.

Xager

If you don't want the file to be accessible without logging in you could do the following:

if($_SESSION['logged_in'] == TRUE){
header("Content-type:" . $content_type);
readfile($path);
}
else{
doStuff();
}

So when the user uploads the file you save the content type and put the file in a location either .htaccess protected or outside of the root folder.
You can save the content type by using:
mime_content_type($file);

Hope this helps.

onlinegamesnz

can u give me a bit more?? where do i put this code? cheers

Xager

onlinegamesnz wrote:
can u give me a bit more?? where do i put this code? cheers

You put it where you want your output, doStuff() is what should happen if the user is not logged in, i just showed you how you output a file with php.