SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Member
    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

  2. #2
    RAGE
    SitePoint 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 ..

  3. #3
    SitePoint Member
    Join Date
    Feb 2000
    Posts
    10
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Does someone know of a tutorial on this matter?

  4. #4
    SitePoint Enthusiast Daniel's Avatar
    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!

  5. #5
    SitePoint Zealot
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •