help a new guy out

[abloveless]

Hey fellas, awesome site btw, just got back into php. Was fooling around with it before but now i have more time and experiance, i got a simple book and am almost complete. So far i have done file uploading, db creation, table creation, and entering data into the table as well as extracting with querys and stuff. Now heres where i would like some ideas.

Just for starters as my first php project, im in the military and i thought i would be nice to have a website where i can upload pictures into a database(dunno if thats possible) w/ an auth script so other people in my family can access the site and upload as well. then be able to search the database and display the pictures accordingly. Any ideas on how to go about this? I dont need a berbadum explanation or anything just perhaps a few ideas/links to articles that could help me accomplish this. Also any corrections in my planning that i would need to take into consideration, like the whole file into a database thing (like i said dunno if you can do that) i would appreciate any feedback you guys can give me. Thanks a bunch

• pat

[Mordecai]

Originally posted by abloveless
...like the whole file into a database thing (like i said dunno if you can do that)...

Well, you can do that..if you want the images to be corrupt. The MySQL manual even warns you from storing images in a table.

As for the entire project, you can take your knowledge of databases and file uploading into account. All in all, it would be a rather simple script--great for someone who's just learning.

But just remember to always store files on the filesystem and just reference their location inside a database.

[abloveless]

thx for your response, and the heads up on mysql and files. when you say reference, you mean upload the file in a dir and have the link inside a db? having a hard time picturing the correct way to do this.