Page 1 of 1

File database

Posted: Wed Sep 15, 2004 12:45 pm
by Stelios
Hi,

I am trying to design a db that users can download files from. In simple terms a user is going to search for a picture and then according to the name of the pic the link to download is going to pop-up.I am working with PHP and mysql. Does anybody have any idea how I can implement this?

Thanks a lot!

Posted: Wed Sep 15, 2004 1:16 pm
by AVATAr
Save the files in the filesystem
in the DB make a table with the name of the file and a description if you want
all the searches will be in the database and the you dinamically make a link to the file.

Posted: Wed Sep 15, 2004 1:44 pm
by feyd
continuing on AVATAr's thread of thought:

... or link to a downloader script (if you don't want hotlinking ;))

Posted: Wed Sep 15, 2004 1:45 pm
by AVATAr
feyd wrote:continuing on AVATAr's thread of thought:

... or link to a downloader script (if you don't want hotlinking ;))
And this script is in this forums.. :wink:

Posted: Thu Sep 16, 2004 3:02 am
by Stelios
thanks all of you, but because I am pretty new to all this kind of things, is there any tutorial that you have in mind that could help me implement my thinking?

thanks a lot again!

Posted: Thu Sep 16, 2004 6:27 am
by AVATAr
Divide and Concare...

Try issuing one problem at a time. Do the form to upload the files and insert the name in the DB.. when you got that...
Search for the script to show the image.