download system

[neo644]

ok, im trying to make a download system
not a waiting system, i mean... if i make a web interface, i dont think uploading 200MB will work, so you could upload files via ftp and tehn in a web interface you can add the file to the database (btw, im using mySQL). i thought something like a "browse" button but instead of viewing the files on your computer, you'll see the one sin a certain directory in the server, and then u select your files and add it to the database...
or if anybody knows how this actually works, it would be greaT!

[jc94062]

A database stores information, text to be more exact (or links to images etc...)

It doesn't store files, it can store the CONTENT of files, but not files.

If you want people to be able to retrieve information from the database, look up "select statements",

ie:

$query = mysql_query("select * from table_name");
while ($rows = mysql_fetch_array($query))
{
    $var = $rows["field_name"];
}

echo $var;

You could then write that all to a file I guess, and then download that, or you can download files directly from the server, the best way to go about that is to go to hotscript.com and grab some of the open source stuff from there, then either use one of those (tip - add security, the one I used to learn from took me 5 mins to crack into and give me access to EVERYTHING on the site!)

Hey, this [ php] stuff if great!

[neo644]

no, no, i know all that, what i mean is that how to like "syncronize" the uplaods with the database. like, u uplaod files via ftp, then somehow u must add them in database.. like, displaying files on the server or maybe making like a "refresh" but where it scans a directory and sub directories in it...

and when i mean add them to the database, i mean, uploader (who uloadid it), date, link to file, description, N downlaods and what not