booxvid Posted August 5, 2012 Share Posted August 5, 2012 I have difficulty on what column or in what table will I add a column where photos of that certain users will be saved in MySQL I have already a table of ALBUM (where there's album id) and a table of PHOTOGRAPH (where there's album id also). What will I do for my Schema where I can save all those photos from this certain user? Quote Link to comment https://forums.phpfreaks.com/topic/266707-saving-photos-in-mysql-by-different-users/ Share on other sites More sharing options...
fenway Posted August 5, 2012 Share Posted August 5, 2012 Well, you could store the binary data in the database -- but IMHO, it's far easier to simply store a relative pathname and store them using the filesystem. Quote Link to comment https://forums.phpfreaks.com/topic/266707-saving-photos-in-mysql-by-different-users/#findComment-1366966 Share on other sites More sharing options...
booxvid Posted August 6, 2012 Author Share Posted August 6, 2012 Actually, I didn't use the the binary data method in saving images into mysql. I just simple use the insert method w/o using the MEDIUMBLOB or blob at all. Quote Link to comment https://forums.phpfreaks.com/topic/266707-saving-photos-in-mysql-by-different-users/#findComment-1367080 Share on other sites More sharing options...
fenway Posted August 7, 2012 Share Posted August 7, 2012 Actually, I didn't use the the binary data method in saving images into mysql. I just simple use the insert method w/o using the MEDIUMBLOB or blob at all. I don't know what that means. Quote Link to comment https://forums.phpfreaks.com/topic/266707-saving-photos-in-mysql-by-different-users/#findComment-1367649 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.