How to show the long blob image from database in phpexcel? -
i have table store data of image in long blob type, how retrieve image show in phpexcel? sample of code:
$order = "select * tblorder"; $tblorder = $conn->query($order); $row_order = $tblorder->fetch(pdo::fetch_assoc); $image =$row_order["image"]; $data = base64_encode($image); $objdrawing = new phpexcel_worksheet_memorydrawing(); $objdrawing->setname('image'); $objdrawing->setdescription('image'); $objdrawing->getindexedfilename($data); $objdrawing->setrenderingfunction(phpexcel_worksheet_memorydrawing::rendering_jpeg); $objdrawing->setmimetype(phpexcel_worksheet_memorydrawing::mimetype_default); $objdrawing->setcoordinates('a85'); $objdrawing->setworksheet($sheet->getactivesheet());
Comments
Post a Comment