PHP + MySql + blob for storing a pic.

Hiya all,

How would i go about doing this, i want to store a picture in a MySql database. How would i go about doing that?

Would i use a blob? If so, how do i get the picture onto the database?

Then using PHP, what would i do to output that picture to the screen?

Cheers all
Jon

Hmmm, I'm not sure about blobs, but what's wrong with uploading the file, and storing the system path in the DB? That's usually the route I've taken when storing pics in a DB. Kind of like the theory behind pointers in C...why store the actual data, when all you really need is a pointer to that data?

Quote:

---

Originally posted by Grizzly:
Hmmm, I'm not sure about blobs, but what's wrong with uploading the file, and storing the system path in the DB? That's usually the route I've taken when storing pics in a DB. Kind of like the theory behind pointers in C...why store the actual data, when all you really need is a pointer to that data?

---

yeah, great point.



------------------
www.geocities.com/richardginn/templatehtml -Come visit the Template HTML homepage