PDF ezImage and Longblob images

[charris1980]

I am trying to grab an image from the DB, it is a longblob type.  I'm using ezpdf right now, and using ezImage isn't doing anything.  If I use ezText just to see if it grabbed it, then it will display the cryptic text of that longblob.

 

I guess my question is, is there a way to show this longblob image in a PDF?

[amites]

why are you storing an image in your database?

 

makes the server happier to store the directory of the image and then call it in normally....

 

just a thought

[charris1980]

yeah i know.  i wish it was my choice, and if this isn't possible it will be the ammo to switch it back to that.  for now though they wanted it in the DB.

[charris1980]

i think i figured it out.  kind of a weird solution though.

 

create-pdf.php (snip)

                //php code that looks up the image based on ID and displays it.
	$filename = "/show-image.php?image_id=150";

                //copies the image to a .tmp file on the disk.
	copy($filename, "/var/www/temppdfimage.img.jpeg");

                //refreshes the page to the actual ezPDF code that pulls that .tmp file.
	echo "<meta http-equiv=\"refresh\" content=\"0;url=/pdf-test.php?id=58507\">\r\n";

 

seems to work so far anyway.  just have to make the ID's variable _GETs now.  I just hard coded them to test it.

[charris1980]

didn't really want to bump this, can't find a edit button.

 

anyway i guess i really over thought this because below worked fine for me

 

create-pdf.php (snip)

	$row = mysql_fetch_array($result);
	$imageurl = "http://www.website.com/show-image.php?imageid=" . $row['image_id'] . "";
	$doc->ezImage($imageurl, '100', '150', 'none', 'right');

 

show-image.php (snip)

	$connection = mysql_connect($host, $user, $pass);
	mysql_selectdb($dbname, $connection);
	$sql = "SELECT image FROM `images_table` WHERE `image_id` = " . $image_id;
	$result = mysql_query($sql, $connection);
	$img = mysql_fetch_row($result);
	print $img[0];

 

just thought i would share...