PHP + MySql + blob for storing a pic.

[LaughingJon]

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

[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?

[richardginn]

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