digitalgod Posted September 7, 2007 Share Posted September 7, 2007 Hey guys, I'm working on an admin panel that will control 2-3 shopping cart on different domains. I was wondering what to do when an admin uploads an image for an item, should it be stored in the db (easier access for the shopping carts) or have them stored on the ftp? If they're stored on an ftp, how can I make a cart on a different domain read that image? Quote Link to comment https://forums.phpfreaks.com/topic/68390-solved-uploading-images-to-tables-or-to-folders/ Share on other sites More sharing options...
fenway Posted September 8, 2007 Share Posted September 8, 2007 Hey guys, I'm working on an admin panel that will control 2-3 shopping cart on different domains. I was wondering what to do when an admin uploads an image for an item, should it be stored in the db (easier access for the shopping carts) or have them stored on the ftp? If they're stored on an ftp, how can I make a cart on a different domain read that image? Ah, you've hit the actual problem... not fun having to replicate directory structures across machines. Quote Link to comment https://forums.phpfreaks.com/topic/68390-solved-uploading-images-to-tables-or-to-folders/#findComment-344455 Share on other sites More sharing options...
digitalgod Posted September 11, 2007 Author Share Posted September 11, 2007 it's sort of an affiliate system so I won't really have access to directories of the other domains... Quote Link to comment https://forums.phpfreaks.com/topic/68390-solved-uploading-images-to-tables-or-to-folders/#findComment-345733 Share on other sites More sharing options...
fenway Posted September 11, 2007 Share Posted September 11, 2007 it's sort of an affiliate system so I won't really have access to directories of the other domains... But which machine will you store the images on if it's not in the db? Quote Link to comment https://forums.phpfreaks.com/topic/68390-solved-uploading-images-to-tables-or-to-folders/#findComment-346205 Share on other sites More sharing options...
digitalgod Posted September 14, 2007 Author Share Posted September 14, 2007 well people can have the option of having their shopping cart on my dedicated server or they can have it on whatever server they want. So my admin panel (hosted on my server) controls all of the other shopping carts, so if I upload an image it will be hosted on my domain (www.mysite.com/products/....) The reason why I was asking whether I should upload the images on the server or in the db instead is because say I have 10 shopping carts that are connecting to that same db then I'm guessing it's going to take a lot of ressources and the images will either load really slow or just timeout.... But if I put them in folders, how will the other shopping carts display the images if they're on my server without showing that it's actually loading from there... Everything is done already, the main admin panel, the affiliate system and the shopping carts, but I just need to figure out how to display the images... Quote Link to comment https://forums.phpfreaks.com/topic/68390-solved-uploading-images-to-tables-or-to-folders/#findComment-348430 Share on other sites More sharing options...
fenway Posted September 15, 2007 Share Posted September 15, 2007 Which is why I said you'd have to replicate the directory tree containing the images... Quote Link to comment https://forums.phpfreaks.com/topic/68390-solved-uploading-images-to-tables-or-to-folders/#findComment-349039 Share on other sites More sharing options...
digitalgod Posted September 15, 2007 Author Share Posted September 15, 2007 I understand but when a new product is added how can I add an image to a server I might not have access to... Quote Link to comment https://forums.phpfreaks.com/topic/68390-solved-uploading-images-to-tables-or-to-folders/#findComment-349146 Share on other sites More sharing options...
fenway Posted September 17, 2007 Share Posted September 17, 2007 I understand but when a new product is added how can I add an image to a server I might not have access to... they are your domains, no? Quote Link to comment https://forums.phpfreaks.com/topic/68390-solved-uploading-images-to-tables-or-to-folders/#findComment-349916 Share on other sites More sharing options...
digitalgod Posted September 18, 2007 Author Share Posted September 18, 2007 not all of them, when an affiliate signs up he has the option to host his cart or have it on my server. And anyways it's going to be a hassle having to upload the images manually to each domain especially when they're all resized on the spot :S Quote Link to comment https://forums.phpfreaks.com/topic/68390-solved-uploading-images-to-tables-or-to-folders/#findComment-350266 Share on other sites More sharing options...
fenway Posted September 18, 2007 Share Posted September 18, 2007 Agreed... you may want to store them in the DB after all.... Quote Link to comment https://forums.phpfreaks.com/topic/68390-solved-uploading-images-to-tables-or-to-folders/#findComment-350525 Share on other sites More sharing options...
digitalgod Posted September 19, 2007 Author Share Posted September 19, 2007 ok thanks, will it put too much strain on the mysql server though? Quote Link to comment https://forums.phpfreaks.com/topic/68390-solved-uploading-images-to-tables-or-to-folders/#findComment-350761 Share on other sites More sharing options...
fenway Posted September 19, 2007 Share Posted September 19, 2007 Depends on how big they are, how much/often you're serving, etc... Quote Link to comment https://forums.phpfreaks.com/topic/68390-solved-uploading-images-to-tables-or-to-folders/#findComment-351352 Share on other sites More sharing options...
digitalgod Posted September 20, 2007 Author Share Posted September 20, 2007 well I know that there's going to be a lot of traffic sent to those sites.... *edit* I've been told that they're expecting about 1000 users connected simultaneously, hope that won't be a problem for the server! thanks for your help fenway, I really appreciate it! Quote Link to comment https://forums.phpfreaks.com/topic/68390-solved-uploading-images-to-tables-or-to-folders/#findComment-351800 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.