How to insert image into database?

[shauno7]

Is there any way to store an acutal image(jpeg, gif) into a database? I'm using a cms for my website, and I want to try and extract almost everything from the database, so that includes the images. Could someone show me how this can be accomplished?
Thanks.

[guelphdad]

Almost everything I've seen on this says you are better off storing an image elsewhere and the path to the image in the database itself.

[Hartmann]

It is called storing binary data in the database and yes it is possible. However, like Dave said, it is considered inefficient and looked down upon.

There is a good article at PHPBuilder about it though, if you are still interested: http://www.phpbuilder.com/columns/florian19991014.php3

Your best bet though is to store the location of the image in your database and just retrieve that. It will require less resources and be faster than if you stored the actual image in the database.