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? 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. 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. 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 Quote 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. 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
Archived
This topic is now archived and is closed to further replies.