Connecting Tech Pros Worldwide Help | Site Map

PHP mySQL - table of images

  #1  
Old July 17th, 2005, 10:19 AM
gsb
Guest
 
Posts: n/a
Not sure is best place to ask, but...
What should the mySQL table look like to save and extract a series of
images.
I want to "insert" an image by name (string) and later "select" and send it
to a web page.

Thanks,

gsb


  #2  
Old July 17th, 2005, 10:20 AM
adam@adamcoppin.com
Guest
 
Posts: n/a

re: PHP mySQL - table of images


the table should be reasonably simple, just 3 columns:

image_id (auto incrementing integer)
image_name (string of pre-determined length)
image_url (absolute or referential, either way this would be a
string... be sure to give it plenty of room though!)

That should be all you need... if you are finding yourself needing yet
more information at a later date, columns are easily added to existing
records. this method should allow you to retrieve the image url by
referring either the image_id or the image_name

  #3  
Old July 17th, 2005, 10:23 AM
Geoff Berrow
Guest
 
Posts: n/a

re: PHP mySQL - table of images


I noticed that Message-ID:
<1098928551.325015.286180@z14g2000cwz.googlegroups .com> from
adam@adamcoppin.com contained the following:
[color=blue]
>image_id (auto incrementing integer)
>image_name (string of pre-determined length)
>image_url (absolute or referential, either way this would be a
>string... be sure to give it plenty of room though!)
>
>That should be all you need... if you are finding yourself needing yet
>more information at a later date, columns are easily added to existing
>records. this method should allow you to retrieve the image url by
>referring either the image_id or the image_name[/color]

Short description (useful to automatically add the alt="" attribute) and
long description are useful too.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
changing actionscript to read php/mysql instead of xml anfetienne answers 3 August 14th, 2009 05:39 AM
Need a solution for downloading 100s of images without server timeout psixat answers 2 October 28th, 2008 12:06 PM
Can someone help me with a php mysql error I keep getting???? Chefry answers 4 July 20th, 2005 01:42 AM
PHP/MySQL Image Gallery DaRemedy answers 9 July 17th, 2005 10:12 AM
PHP mySQL image blobs Rob answers 5 July 17th, 2005 01:06 AM