PHP MySQL:将PDF保存到数据库 [英] PHP MySQL: Saving PDF to Database
问题描述
我正在使用TCPDF生成PDF，我想将生成的pdf作为blob保存在MySQL数据库中.我应该保存什么数据到数据库? PDF页面代码
I am generating PDFs with TCPDF, I want to save the generated pdf as blob in a MySQL db. What data should I save to the db? Code for PDF page
<?php
require_once('../config/lang/eng.php');
require_once('../tcpdf.php');
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Nicola Asuni');
$pdf->SetTitle('TCPDF Example 001');
$pdf->SetSubject('TCPDF Tutorial');
$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
// set default header data
$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE.' 001', PDF_HEADER_STRING);
// set header and footer fonts
$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
//set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
//set some language-dependent strings
$pdf->setLanguageArray($l);
// ---------------------------------------------------------
// set default font subsetting mode
$pdf->setFontSubsetting(true);
// Set font
// dejavusans is a UTF-8 Unicode font, if you only need to
// print standard ASCII chars, you can use core fonts like
// helvetica or times to reduce file size.
$pdf->SetFont('dejavusans', '', 14, '', true);
// Add a page
// This method has several options, check the source code documentation for more information.
$pdf->AddPage();
// Set some content to print
$html = <<<EOD
<h1>Welcome to <a href="http://www.tcpdf.org" style="text-decoration:none;color:black;"><span style="background-color:#CC0000;"> TC<span style="color:white;">PDF</span> </span></a>!</h1>
<i>This is the first example of TCPDF library.</i>
<p>This text is printed using the <i>writeHTMLCell()</i> method but you can also use: <i>Multicell(), writeHTML(), Write(), Cell() and Text()</i>.</p>
<p>Please check the source code documentation and other examples for further information.</p>
<p style="color:#CC0000;">TO IMPROVE AND EXPAND TCPDF I NEED YOUR SUPPORT, PLEASE <a href="http://sourceforge.net/donate/index.php?group_id=128076">MAKE A DONATION!</a></p>
EOD;
// Print text using writeHTMLCell()
$pdf->writeHTMLCell($w=0, $h=0, $x='', $y='', $html, $border=0, $ln=1, $fill=0, $reseth=true, $align='', $autopadding=true);
// ---------------------------------------------------------
// Close and output PDF document
// This method has several options, check the source code documentation for more information.
$pdf->Output('example_001.pdf', 'I');
//============================================================+
// END OF FILE
//============================================================+
?>
代码将pdf文件输出到浏览器.如何将pdf数据保存到数据库或文件系统中?对于文本数据，我已经使用file_put_contents创建了html/txt文件.
The code outputs a pdf files to the browser. How do I save the pdf data to a db or otherwise to the file system? For text data I have used file_put_contents to create html/txt files.
感谢 Piskvor . 解决方案代码
$content=$pdf->Output('', 'S');
header("Content-type:application/pdf");
header("Content-Disposition:attachment;filename='pdf.pdf'");
echo $content;
您可以将$ content作为blob保存在数据库中，并对其进行检索以生成pdf.如果要在浏览器中打开pdf，请删除以下行.
You can save the $content as a blob in your db and retrieve it to generate the pdf. If you want the pdf to open in the browser, remove the following line.
header("Content-Disposition:attachment; filename ='pdf.pdf'");
header("Content-Disposition:attachment;filename='pdf.pdf'");
推荐答案
答案就在您的代码中
// Close and output PDF document
// **This method has several options**, check the source code documentation for more information.
$pdf->Output('example_001.pdf', 'I');
从文档中:
参数:(...) 字符串$ dest发送目的地 文档.可能需要其中之一 以下值:(...)S:以 细绳.名称将被忽略.
Parameters: (...) string $dest Destination where to send the document. It can take one of the following values: (...) S: return the document as a string. name is ignored.
因此，请更改您的代码:
So, change your code thus:
$pdffilecontent = $pdf->Output('', 'S');
并将该字符串保存到数据库
and save that string to the database
这篇关于PHP MySQL:将PDF保存到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
