eZe616 Posted August 9, 2007 Share Posted August 9, 2007 I'm fairly knew to programming with PHP, I would say I've been coding for almost 3 months now. Not everyday or everyweek, but still enough to build a custom and simple CMS for a small real estate site. Now I've been working at this IT store for a summerjob, and these last week i've been given a chance to build there production department website. I've chosen to use PHP, since it's the only programming lanuage I currently know. Now I had to build a CMS for them to be able to upload the work for clients. Now my superior wants the client to be able to see different drafts of the job being done, ie, posters, ads, etc. and be able to approve a certain image. I have a several table in the database, i.e one calle jobs, imgs, and drafts. Now the table imgs will contain all the paths of the images, including the different drafts. Now I have thought of giving the images, and rand() property and the end of the name, but they'll have the same Job ID, to belong to a certain Job. From them I'll just Select them from the database being ordere by the id. Now some of the other developer there told me they would've just saved the whole image inside the database as a blob, instead of the path. I have read several threads that say it would be better to store the path, and is the big reason I save the path of the image instead of the image itself. They explained that it's easier that way to create a history of the drafts. Other wise it'll make it so that i'll have to write more code. Now I'm not to fond of doing it that way, inserting the whole image. So I was wondering which way would be better?? Also they work mostly with MSSQL and .NET, while i'm more PHP and MySQL. would that make a difference. Do they other types of databases handle the image blob thing better than MySQL, cause I was starting to feel i've been going about this project entirely wrong. any help would be appreciate. TnX Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.