7 Replies - 1738 Views - Last Post: 25 December 2002 - 08:39 AM

#1 iamcenz  Icon User is offline

  • You wish you were my hand!
  • member icon

Reputation: 7
  • View blog
  • Posts: 2,442
  • Joined: 26-March 01

Images And Databases

Posted 02 November 2002 - 08:53 PM

whats the best way to store images into a database?? i was thinking if there is a way to convert the image into binary, then store it in the MySQL database and then output later back as a image. but im not sure if that is even possible.
Is This A Good Question/Topic? 0
  • +

Replies To: Images And Databases

#2 arniie  Icon User is offline

  • D.I.C Addict

Reputation: 0
  • View blog
  • Posts: 999
  • Joined: 08-October 02

Re: Images And Databases

Posted 03 November 2002 - 04:43 AM

YES it is possible, i have done it on my latest project.

Im at home over the weekend - i can tell you EXACTLY how to do it on monday (if someone doesn't beat me to it)

IT IS DEFINATELY possible, if you want to look how to do it over the weekend

You put an image uploader on the page - they point to the file on there com. then it uploads a binary string to the db. than u call call it back on a page.

MORE INFO monday
Was This Post Helpful? 0
  • +
  • -

#3 Cookie Mobster  Icon User is offline

  • nooneenooneenooonee
  • member icon

Reputation: 7
  • View blog
  • Posts: 4,730
  • Joined: 12-October 01

Re: Images And Databases

Posted 03 November 2002 - 09:30 AM

As arniie said it is very true. Images are already in binary you just have to create a blob field in your table and... well read this article.

http://www.zdnetindi...?iElementId=139
Was This Post Helpful? 0
  • +
  • -

#4 klewlis  Icon User is offline

  • cur tu me vexas?

Reputation: 8
  • View blog
  • Posts: 1,723
  • Joined: 09-November 01

Re: Images And Databases

Posted 03 November 2002 - 03:40 PM

While it's possible, it may not be the most practical method, depending on your purposes.

I usually just store the image name or path in the db and the actual file elsewhere.
Was This Post Helpful? 0
  • +
  • -

#5 iamcenz  Icon User is offline

  • You wish you were my hand!
  • member icon

Reputation: 7
  • View blog
  • Posts: 2,442
  • Joined: 26-March 01

Re: Images And Databases

Posted 03 November 2002 - 06:56 PM

well i guess i should tell you what im trying to do... ok, well im setting up a website calld geek gaming. its a game review site pretty much, and i need it so i have pics for every game for every console, i dont think i got that much room, on the site, i got the dream.plan on guardian hosting... but i think it would use way to much...
Was This Post Helpful? 0
  • +
  • -

#6 Quik  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 2
  • View blog
  • Posts: 3,750
  • Joined: 06-March 01

Re: Images And Databases

Posted 03 November 2002 - 07:35 PM

you would just have a upload field along with the title, price, etc of each game entry..

the name of the file will be placed into a field in the DB and then called later to tell the script which picture to grab from a specific directory.
Was This Post Helpful? 0
  • +
  • -

#7 arniie  Icon User is offline

  • D.I.C Addict

Reputation: 0
  • View blog
  • Posts: 999
  • Joined: 08-October 02

Re: Images And Databases

Posted 13 November 2002 - 04:50 AM

Blunted: did you get this sorted or ??
Was This Post Helpful? 0
  • +
  • -

#8 agazeus  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 38
  • Joined: 25-December 02

Re: Images And Databases

Posted 25 December 2002 - 08:39 AM

Just have them all in numerical order(named), and then have the db indexed - Just have the path there and it loads it with whatever record you are viewing. Storing it in binary might make it a bit big - yes?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1