SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    raghu_sitepoint
    SitePoint Community Guest
    I have been planning to develop a website that would allow users to enter their data and pictures. I would like to save each user in a row. But i have no idea of how to store the pictures, will i store them as files somewhere and then have a id pointing to these files in the database.
    In the PHP/MYSQl series looks like kevin is storing the jokes itself in a column in jokes table. What if i had huge files that cant fit in a column.

    I am not very good at db so .....


    Thanks in advance

    Raghu

  2. #2
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Store the URL to the picture in your column. i.e. ROW 1 = http://www.yourdomain.com/pictures/userid/picture1.gif

    Then in your code that builds the page you would write code that inserts that URL into an image tag via a variable.


    ------------------
    Wayne Luke - Sitepoint Forums Administrator
    Digital Magician Magazine - MetaQuark Creations (Coming Soon)
    sitepoint@digitalmagician.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
  •