How do I pass binary (blob) data from mysql to imagejpeg for a file save?

Question

I'm in the process of converting all my images stored in a DB to a file system structure but can't seem to save them to a file. Here is what I'm trying.

....
$SQL = "SELECT thumbnail FROM profile_image WHERE user_id=7";
$r = mysql_query($SQL) or die ("Error");

$image=mysql_result($r,0,"thumbnail");

$destination = SITE_ROOT .'/photos/7/test.jpeg';

imagejpeg($image, $destination);

//header("Content-type: image/jpeg");
//echo ($image);

It's complaining about an invalid resource...what am I missing?

What is the exact error message? PS: imagejpeg accepts a resource as a first argument, not a string — zerkms
– zerkms, Commented Jul 22, 2012 at 22:02

Federkun · Accepted Answer · 2012-07-22 22:07:45Z

1

Try using imagecreatefromstring to create a valid resource.

// ...
if (false !== $im = imagecreatefromstring($image)) {
    imagejpeg($im, SITE_ROOT . '/photos/7/test.jpeg');
    imagedestroy($im);
}

answered Jul 22, 2012 at 22:07

Federkun

37.2k8 gold badges82 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Flukey Over a year ago

false !== odd comparison.... true == is MUCH clearer. That's kinda made me laugh. first time i've come across a statement such as that

Federkun Over a year ago

@Flukey, following the documentation, FALSE is returned if the image type is unsupported, the data is not in a recognised format, or the image is corrupt and cannot be loaded.

Flukey Over a year ago

Yes I know. but you could still use true == it's much clearer to read than false !== Your way makes the code difficult to read. I know what the function returns.

Collectives™ on Stack Overflow

How do I pass binary (blob) data from mysql to imagejpeg for a file save?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related