Jump to content


Photo

exif and iptc data extraction with php vs. mysql database


  • Please log in to reply
2 replies to this topic

#1 bullchina

bullchina
  • Members
  • PipPip
  • Member
  • 19 posts
  • LocationHouston

Posted 04 September 2006 - 11:10 AM

i want to store info about a project in a database, and each project can have multiple images associated with it. at first i started to create a relational table for the images, but i was thinking that it might be easier to just store the image title and description info in the exif/iptc tags, and then just run a small php script that runs through the unique project directory where the images are stored, reads the list, and outputs the images with the exif info.

i noticed that save for web in photoshop strips out all the exif info, etc... and images saved with save as... are larger.

which method is better? the database approach or just storing images in a folder with exif/iptc data? thanks for the help

#2 onlyican

onlyican
  • Members
  • PipPipPip
  • Advanced Member
  • 921 posts
  • LocationHants - UK

Posted 04 September 2006 - 11:39 AM

What I do for uploading images is
Create a SET directory as you have to use high CHMOD (means easier to hack that folder)
Upload the files there, maybe evan changing the name to make it unique

Then get the file name, and store that into the DB
Tell me the problem, I will try tell you the solution

#3 bullchina

bullchina
  • Members
  • PipPip
  • Member
  • 19 posts
  • LocationHouston

Posted 04 September 2006 - 02:40 PM

oh i wasn't looking to get into web based submissions of images, this is pretty much a static site where a database will be kept locally in access at the office, and then convert it to mysql or xml when it's changed, and then just copy the files over to the server.

i was just wondering if it's really necessary for me to make a table in the database to store the image names/titles/descriptions, etc...




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users