storing image directly to mySQL

[philippo]

How do I store an image that I've created with the GD directly into mySQL without storing it as a file?

I'm using the following code to show the Image:

header('Content-type:image/PNG');

imagePNG($img);

if I use $imgdata = imagePNG($img); I'm just getting '1' (=true) as result. If I use $imgdata = $img; then imgdata will just contain 'Resource id #97'
How do I get the binary data of the image?

thanks
Philippo

[[deleted]]

Search the forum, storing images in a database is not always a good idea.

if you are bent on doing it, read this article:
http://www.phpbuilder.com/columns/florian19991014.php3

[philippo]

wether it is a good idea or not - I need to store them in mySQL because of several reasons!

I've read that article already before but it doesn't treat my problem. Did you understand my question?

my question was: How do I get the binary data of the image that was created by imageGIF() or imagePNG() ?

on php.net, Pablo wrote:

http://www.php.net/manual/en/function.imagegif.php

[e-mail]
16-Jan-2001 02:28
Be careful, since it does't return the image you can't put it in a variable, or in a database.
It just prints it.

The function returs '1'.

so, what's the solution? there must be one!

thanx
Philip

[[deleted]]

You may be able to read the GD stream directly, but that is not proper image data. I think the easiest would still be to use a temporary file.

[philippo]

any idea how to read that GD-stream?

[[deleted]]

Unfortunately no 🙁