需要将mysql数据库中的图像显示到fpdf

Question

A 将图像保存在 mysql 数据库中作为 bolb，我希望使用 php 将其显示在 fpdf 中。我在执行此操作时遇到问题，因为我对 fpdf 很陌生。我真的需要帮助。谢谢。

Answer 1

您将需要 FPDF 的此扩展： http://www.fpdf.org/en/ script/script45.php

[更新]

$query = "SELECT imageField FROM yyy WHERE ...";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$image = $row['imageField'];

$pdf->MemImage($image, 50, 30);

Answer 2

//Alternatively
//1) Put the class VariableStream inside your php file instead of declaring it
//--------------------------

enter code here

class VariableStream
{
    var $varname;
    var $position;

    function stream_open($path, $mode, $options, &$opened_path)
    {
        $url = parse_url($path);
        $this->varname = $url['host'];
        if(!isset($GLOBALS[$this->varname]))
        {
            trigger_error('Global variable '.$this->varname.' does not exist', E_USER_WARNING);
            return false;
        }
        $this->position = 0;
        return true;
    }

    function stream_read($count)
    {
        $ret = substr($GLOBALS[$this->varname], $this->position, $count);
        $this->position += strlen($ret);
        return $ret;
    }

    function stream_eof()
    {
        return $this->position >= strlen($GLOBALS[$this->varname]);
    }

    function stream_tell()
    {
        return $this->position;
    }

    function stream_seek($offset, $whence)
    {
        if($whence==SEEK_SET)
        {
            $this->position = $offset;
            return true;
        }
        return false;
    }

    function stream_stat()
    {
        return array();
    }
}
//----------------------------------------------------
//2) open and read your mysql longblob that contains your binary data from your image
//in my case the function declaration is this

function showImage($cdImg) {

Global $pdf; 
    //declare your pdf class
    //Connects the way you do. this case assigned as $odbc_conn

   $query = 'SELECT cd_img, ds_img, bin_img FROM tb_img WHERE cd_img = '.$cdImg;

$result= mysqli_query($odbc_conn, $query);

  $row = mysqli_fetch_array($result);

  if (!empty($row["bin_img"]))
  {

    //IF your data is encoded
    //$data=base64_decode($row['bin_img']);
    //
        $data=$row['bin_img'];
   }

   mysqli_free_result($result);

   mysqli_close($odbc_conn);

    stream_wrapper_register('var', 'VariableStream');

$x=null;

$y=null;

$w=0;

$h=0;

$link='';


        //Display the image contained in $data
       $v = 'img'.md5($data);
        $GLOBALS[$v] = $data;
        $a = getimagesize('var://'.$v);
        if(!$a)
        $pdf->Error('Invalid image data');
        $type = substr(strstr($a['mime'],'/'),1);
        $pdf->Cell(1);
        $pdf->Cell(26, 1, '', '', 0,'L');
        $pdf->Cell(150, 1, '', '', 1,'L');
        //650=150 choose your options for height and width
        //845=156
        //$xc=ceil((676-$a['width'])/2);

        $pdf->Image('var://'.$v, 44, $y, 150, 0, $type, $link);

        unset($GLOBALS[$v]);
}

Answer 3

这是代码$pdf->Image('http://www.elwebmaster.com/wp-content/uploads/2015/06/PHP-logo.png',30,278,8); 或者如果在您的根目录中 $pdf->Image($_SESSION['raiz'].'imagens/tsunami.jpg',150,285,12);

您可以在您的sql 数据库，然后使用 $pdf->Image($_SESSION['raiz'].'imagens/picture.php?id=1',150‌ ,285,12); 其中 id 是数据库索引和 picture.php 是检索要显示的图像的文件