images in database to webpage

rtown

here's the deal...I am attempting to create a shopping cart for a company out of an existing layout. all pages are entirely image generated, no whitespace, every inch, link, whatever is an image...now to create the catalogue I would be looking at over 160 html pages, so obviously attempt a database driven website, but question is how do I store images in a database (mysql), and then load those images through the query results into their appropriate position???

Any insight would be GREATLY appreciated, let the ideas commeth!

jpmoriarty

i wouldnt try to store the images in a database at all. give each image a name (probably best if you use the auto_increment feature in your database to make sure that no names are the same), something like number.jpg (eg 512.jpg), and then store the image in a directory. Then you can reference to the image by doing <? echo <img src='images/".$image_number.".jpg'>; ?>, which will link to the required image.

rtown

not that that posses a problem, and thanks for the reply, but the way that the site is set up, all the images that correlate to a specific location on the page all have the same image name, they are just located in different folders, so if that stayed the same in the database, but rather separated in different rows reflecting the product...I dunno, what do you think. But thanks to you I have my first example of how to access an image in the database, I haven't been able to find that anywhere, thanks...any more info would be great!

theeper

If your images are always in the same place, I don't see the reason to have their URLs in a DB. Just hardcode the image URLs and use some PHP logic to pull them from the right directory.