I have a image archive site and I was told that if I stored my images in a database that no one could hotlink me or use a siteripper to steal them. How can i learn to make something like this, i don't know mySQL or PHP but i do know basic cgi.
Where do i start? I don't understand how you make a database do i have to enter the location of each image or does it do all that for you and make the HTML pages showing a image. I don't even know what you need to make a database but i want to learn or would it be dumb to make something like this for a few hundered pics?
A few hundered pics rick?
What if in a year you have a few 1000?
A database is definitely the way to go if you have large amounts of information.
For an overview of the popular databasing methods out there.
As far as people taking your images. As long as they're displayed on the browser then people can take them. The only real way to securely copyright an image is to put a watermark on it. This allows you to easily prove you own the image in any copyright lawsuit. A popular company for this is digimarc (digimarc.com) and you can also get a digimarc filter that works with Photoshop and allows you to put water marks on your images.
Check this article: http://webmasterbase.com/article.php?aid=228 on Building a Database-Driven Site Using PHP and MySQL by Kevin Yank.
I think PHP/SQL are the best all round database combination at the moment, they are free, most hosts provide them, relatively easy to learn, etc.
Check out that article and see what you think.
And also check
They also have lots of good tutorials on coding stuff.