PHP dowload system help.

Anon

Ok....I wannna make a site where there are a lot of downloads. Is it possible to make it so that when I upload a new file to be downloaded the page will automaticly update it self with a pic that I upload and a link to the file some thing like www.mysite.com/file.php?id=12345 if anyone can help me or tell that I can't even do this please e-mail me.

thanks
steve carman

Anon

you would have to read the directory or something, it would take some work. you would have to assign a new id at random each time the page is loaded to all the new files though.

Anon

A possbile solution:

Upon uploading the file, update a database table containing the name of this file. Refresh the page containing the list of available downloadable files. This would refresh the database giving you an updated list. Sounds simple!!!

The ID of the file would be generated by an Autonumber field in the table which has just been updated with the filename.

Anon

Now where would I go about finding either theses databases and auto number field?

Anon

Hi Steve

I can only speak of MySQL within a PHP environment but when creating a database table, ensure that the field is of an INT datatype, no nulls. Make sure also that you create a PRIMARY key for the field. You should also enable auto increment. Please see example below:

CREATE TABLE tbluploadedfiles (
fileid int(9) DEFAULT '0' NOT NULL auto_increment,
description varchar(255) DEFAULT '' NOT NULL,
filename varchar(255),
uploaddate date DEFAULT '0000-00-00' NOT NULL,
filesize mediumint(9) DEFAULT '0',
PRIMARY KEY (fileid),
KEY SK_description (description),
KEY SK_uploaddate (uploaddate)
);

The field above, 'fileid' will automatically increment by the value of 1 each time a new record is inserted. This will provide you with the unique ID to enable the user to click the hyperlink to download the file.

Hope this helps.

Good Luck.