File database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Stelios
Forum Commoner
Posts: 71
Joined: Fri Feb 06, 2004 6:25 am
Location: Surrey/UK

File database

Post 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!
User avatar
AVATAr
Forum Regular
Posts: 524
Joined: Tue Jul 16, 2002 4:19 pm
Location: Uruguay -- Montevideo
Contact:

Post 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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

continuing on AVATAr's thread of thought:

... or link to a downloader script (if you don't want hotlinking ;))
User avatar
AVATAr
Forum Regular
Posts: 524
Joined: Tue Jul 16, 2002 4:19 pm
Location: Uruguay -- Montevideo
Contact:

Post 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:
User avatar
Stelios
Forum Commoner
Posts: 71
Joined: Fri Feb 06, 2004 6:25 am
Location: Surrey/UK

Post 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!
User avatar
AVATAr
Forum Regular
Posts: 524
Joined: Tue Jul 16, 2002 4:19 pm
Location: Uruguay -- Montevideo
Contact:

Post 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.
Post Reply