damion Posted October 5, 2009 Share Posted October 5, 2009 I have a client who wants me to build him an art gallery web site. There are a few issues that I don't feel comfortable with so I would like your opinion. First of all, his entire inventory - images, text, pricing, descriptions, etc.. are all stored in his database which is an Access mdb file. So the first challenge is all that goodness will need to be imported from his intranet Windows database into mine (the new web site will be built using php/mysql). My first question is is this even possible? Can all this data be imported and how would I structure the mysql database to accomodate and be able to have the site render this data correctly without errors all over the place? My second issue is his images are all prepared and in a folder. He said he will resize them to what the web site's needs are. The new site will feature thumbnails and full size image views. Anyone ever heard of a way to code the site so it will keep his current images as-is from the folder and somehow miraculously show up on the page when someone clicks a link to view them? He wants to do it this way for whatever reason - I don't and would prefer an upload form in the back end. I can't imagine the amount of html work that will be needed if I had to hard code every image into the site! From what I'm told there are very many images! I'm tempted to run for the hills on this one but I would like to know if anyone has any input or experience they can share so I can make an informed decision (and to let the client know what he's looking at too!). Thanks so much. Quote Link to comment https://forums.phpfreaks.com/topic/176583-can-this-be-done-gallery-website-built-with-images-that-are-already-in-a-folder/ Share on other sites More sharing options...
Zane Posted October 5, 2009 Share Posted October 5, 2009 http://www.kitebird.com/articles/access-migrate.html Quote Link to comment https://forums.phpfreaks.com/topic/176583-can-this-be-done-gallery-website-built-with-images-that-are-already-in-a-folder/#findComment-930914 Share on other sites More sharing options...
kickstart Posted October 5, 2009 Share Posted October 5, 2009 Hi I have a very basic and crude image site using very simple php to loop through a directory and display the images (paged), and check a couple of other directories for other versions, putting links if found. Basically thumbnails in the root and the 2 sub directories for small and full size versions (I only upload the full ones on request). This is very simple to do. It would be easy to upload full size versions and generate / cache thumbnails on the fly. All the best Keith Quote Link to comment https://forums.phpfreaks.com/topic/176583-can-this-be-done-gallery-website-built-with-images-that-are-already-in-a-folder/#findComment-930920 Share on other sites More sharing options...
damion Posted October 5, 2009 Author Share Posted October 5, 2009 Keith, Would you think this is a good idea if the site consists of hundreds of images? Wouldn't you still need to code the image names in the html? I definitely would rather have the programming do all the work for me! Thanks for you response. Quote Link to comment https://forums.phpfreaks.com/topic/176583-can-this-be-done-gallery-website-built-with-images-that-are-already-in-a-folder/#findComment-930926 Share on other sites More sharing options...
kickstart Posted October 5, 2009 Share Posted October 5, 2009 Hi I did it this crude way as I wanted to upload thousands of images at a time (ftp is easy, as is batch resizing on a PC, while uploading individual images is time consuming). Makes it pretty easy to do uploads. I just order them in image name order so it is consistant for paging I have never bothered to make it look pretty, or add any extra functions as I wanted something simple, but no reason why something cannot be cleaned up. Eg, you could check a db for a row for images to get extra info / user comments / etc. All the best Keith Quote Link to comment https://forums.phpfreaks.com/topic/176583-can-this-be-done-gallery-website-built-with-images-that-are-already-in-a-folder/#findComment-930929 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.