$rs_article = mysql_query($query_rs_article, $conn) or die(mysql_error());
$row_rs_article = mysql_fetch_assoc($rs_article);
$totalRows_rs_article = mysql_num_rows($rs_article);
function conv($Text) //对返回文本进行处理
{
$Text=htmlspecialchars($Text); //转换HTML关键字符
$Text=nl2br($Text); //转换换行符
return $Text;
}
?>
<p align="center"><B><?php echo $row_rs_article['title']; ?></B></p>
<p align="center"><font size=2><?php echo $row_rs_article['author']; ?> | <a href="showpdf.php?id=<?php echo $row_rs_article['article_id']; ?>">下载PDF文档</a></font></p>
<HR>
<p><?php echo conv($row_rs_article['content']); ?></p>
<?php
require('chinese.php');
class PDF extends PDF_Chinese
{
function Header() //设置页眉
{
$this->SetFont('GB','',10);
$this->Write(10,'文章系统 - XX网站');
$this->Ln(20); //换行
}
function Footer() //设置页脚
{
$this->SetY(-15);
$this->SetFont('GB','',10);
$this->Cell(0,10,'第'.$this->PageNo().'页');
}
}
//主程序开始
$conn = mysql_connect("localhost", "root", ""); //连接数据库
$colname_rs_article = $_GET['id']; //获取参数id
mysql_select_db("cms", $conn); //执行SQL
$query_rs_article = sprintf("SELECT * FROM articles WHERE article_id = %s", $colname_rs_article);
$rs_article = mysql_query($query_rs_article, $conn) or die(mysql_error());
$row_rs_article = mysql_fetch_assoc($rs_article);
$totalRows_rs_article = mysql_num_rows($rs_article);
//开始创建PDF文档
$pdf=new PDF();
$pdf->AddGBFont();
$pdf->Open();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('GB','B',20);
$pdf->Cell(0,10,$row_rs_article['title']); //输出文章标题
$pdf->Ln(); //换行
$pdf->SetFont('GB','',10);
$pdf->Cell(0,10,$row_rs_article['author']); //输出文章作者
$pdf->Ln();
$pdf->SetFont('GB','',12);
$content = $row_rs_article['content'];
while($content != "") //循环逐页将文章内容写入PDF
{
$length = strlen($content); //获取文章长度
$output = substr($content, 0, 1024); //获取本页输出内容,每1024个字符为1页
$pdf->Cell(0,10,$output); //输出文章内容
$content = substr($content, 1024, $length); //获取剩余未输出内容
$pdf->AddPage(); //换页
}
$pdf->Output($row_rs_article['title'].".pdf", true); //输出PDF文件,文件名为文章标题
?>
<?php
define('FPDF_FONTPATH','font/'); //定义font文件夹所在路径
require_once('fpdf/fpdf.php'); //包含fpdf类库文件
class PDF extends FPDF
{
function Header() //设置页眉
{
$this->SetFont('Arial','B',15); //设置页眉字体
$this->Cell(80); //移动单元格







