SitePoint Sponsor |
|
User Tag List
Results 1 to 5 of 5
Thread: php picture database
Hybrid View
-
Feb 4, 2000, 23:00 #1
- Join Date
- Feb 2000
- Posts
- 10
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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.
Thanks
-
Feb 4, 2000, 23:04 #2RAGESitePoint Community Guest
your idea is right.. your logic is wrong.. in the mysql database, just store the URL to the image..
.. nothing hard in that.. just normal text ... in a CHAR(255) column ..
-
Feb 5, 2000, 06:22 #3
- Join Date
- Feb 2000
- Posts
- 10
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Does someone know of a tutorial on this matter?
-
Feb 5, 2000, 06:55 #4
- Join Date
- Dec 1999
- Location
- Belfast
- Posts
- 81
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Try
http://www.devshed.com/Server_Side/PHP/DB_Basics/
It was a great help to me when I was learning ;-)
------------------
Daniel Irvine
f-free - Free Stuff and Freebies!
-
Feb 6, 2000, 17:07 #5
- Join Date
- Nov 1999
- Location
- Manhattan!
- Posts
- 107
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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
Christian
------------------
Axie automatically performs free, customizable searches for new
websites and delivers the links to members by personalized email.
http://www.axie.com/
Bookmarks