I want to fetch my image blob from MySQL and paste it in a PDF with PDFlib. How can I transform the blob so that I can use it as a normal image for PDFlib?
This is the way I am trying to do it at the moment.
$img = imagecreatefromstring($qra['photo']); //$qra['photo'] is the mysql blob field
// Loading the image with PDFlib (this code is already tested with a normal image src like /images/example.jpg and works)
$image = $p->load_image("auto", $img, "");
$p->fit_image($image, 10, 10, "boxsize={50 50} position=center fitmethod=meet");
Somehow the image is not created properly with imagecreatefromstring because I get an error with that code.
How do I fetch the blob image properly so that I can use it (save it on the server as a tmp image would also work)?
this is more simple. I expect you have your image as a byte array stored in the database. So it should be simple, when you just retrieve the BLOB field as string and use PVF (PDFlib Virtual Filesystem). With this technique, you give your variable a name, which can be used afterwards for the load_image() call.
This is demonstrated in the starter_pvf.php sample, which is included in the PDFlib PHP packages as well in the PDFlib Coobkook: http://www.pdflib.com/pdflib-cookbook/general-programming/starter-pvf/php-starter-pvf/
The sample just read the image data from disc, but this should be similar to fetching it from the database
# We just read some image data from a file; to really benefit
# from using PVF read the data from a Web site or a database instead
$imagedata = read_file("../input/PDFlib-logo.tif");
$p->create_pvf("/pvf/image", $imagedata, "");
# Load the image from the PVF
$image = $p->load_image("auto", "/pvf/image", "");