I am building a photoviewer application for some friends and I would like to ask your personal opinion about how to accomplish this:
Each user will be able to upload images and make folders inside their root folder "/home/tmp/$username/05_09_01" from a web interface.....My question is what would be the best way to organize the image information inside the database? I will have to have a path, image description, filename, date_uploaded, etc.. (If you see any data that I should have in my image info please let me know.)
I am trying to figure out how to make the actual structure of the table in MySQL. Right now the table is called "users" and the fields are: "username, password, first_name, last_name, email, friends, image_info" How could I organize all the info in the image_info cell without having to make 4-5 more cells to hold the path, description, etc.....can I just input the info in some sort of system like,
"pic.jpg | pics of my friends | /tmp/Chad/05_01_01/ | 05_03_01"
Chad...
Each user will be able to upload images and make folders inside their root folder "/home/tmp/$username/05_09_01" from a web interface.....My question is what would be the best way to organize the image information inside the database? I will have to have a path, image description, filename, date_uploaded, etc.. (If you see any data that I should have in my image info please let me know.)
I am trying to figure out how to make the actual structure of the table in MySQL. Right now the table is called "users" and the fields are: "username, password, first_name, last_name, email, friends, image_info" How could I organize all the info in the image_info cell without having to make 4-5 more cells to hold the path, description, etc.....can I just input the info in some sort of system like,
"pic.jpg | pics of my friends | /tmp/Chad/05_01_01/ | 05_03_01"
Chad...