如何在PHP中使用varbinary字段作为fpdi的源文件 [英] How to use varbinary field as source file for fpdi in PHP

问题描述

我成功地将一个pdf文件存储到Sql Server中的varbinary字段并按原样检索它但我的问题现在我必须将它传递给fpdi作为源文件请帮帮我





谢谢



我的尝试：

I Stored an pdf file to varbinary field in Sql Server successfully and retrieved it as it is but my problem now i have to pass it to fpdi as source file please help me


Thanks

What I have tried:

<?php
require_once('fpdf/fpdf.php');
require_once('fpdi/fpdi.php');
require_once('connectionphp');
 
$strSQL = "SELECT * FROM files WHERE FilesID = '".$_GET["FilesID"]."' ";
 
$objQuery = sqlsrv_query($strSQL) or die ("Error Query [".$strSQL."]");
 
$objResult =sqlsrv_fetch_assoc($con,$objQuery);
 
header("Content-Type: ".$objResult["FilesType"]);
 
$pdf = new FPDI();
 
$pdf->AddPage();
 
$pdf->setSourceFile($objResult["FilesName"]);
//here $objResult["FilesName"] is the varbinary field extracted from database
 
$tplIdx = $pdf->importPage(1);
 
$pdf->useTemplate($tplIdx, 10, 10, 100);
 
$pdf->SetFont('Helvetica');
$pdf->SetTextColor(255, 0, 0);
$pdf->SetXY(30, 30);
$pdf->Write(0, 'I tried it');
 
$pdf->Output();
?>

推荐答案

strSQL =SELECT * FROM files WHERE FilesID ='。

strSQL = "SELECT * FROM files WHERE FilesID = '".

_GET [FilesID]。';
 

_GET["FilesID"]."' ";  

objQuery = sqlsrv_query（

objQuery = sqlsrv_query(

这篇关于如何在PHP中使用varbinary字段作为fpdi的源文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！