I want to make a BIG picture gallery. I wanted to sort the pictures by author, size, theme, etc. To ad a search engine... My first thought was to use php with mySQL, and store the pictures in the database. Then I found out that mySQL databases are usually limited in space (mine is 25MB). So I'm now thinking of only using the database to store information about the pictures, and somethig like a pointer to the pictures which will be located somewhere on the site.
The problem is that I have no idea how to do this. If you can point me to some place where they can show me a tutorial of some sort, or you have a better idea, I would be gracefull.
your idea is right.. your logic is wrong.. in the mysql database, just store the URL to the image.. http://www.webmaster-resources.com/forums/smile.gif.. nothing hard in that.. just normal text ... in a CHAR(255) column ..
Does someone know of a tutorial on this matter?
It was a great help to me when I was learning ;-)
f-free - Free Stuff and Freebies!
Usually the size of yor DB = your disk size, so if you are planning a large collectoin, then you will need more space.
BTW you can also store binary data directly in your mySQL db. There is an article about that at http://www.phpBuilder.com
Axie automatically performs free, customizable searches for new
websites and delivers the links to members by personalized email.