<?php <BR>require('chinese.php'); <BR>class PDF extends PDF_Chinese <BR>{ <BR>function Header() //设置页眉 <BR>{ <BR>$this->SetFont('GB','',10); <BR>$this->Write(10,'XX公司产品名录'); <BR>$this->Ln(20); //换行 <BR>} <BR>function Footer() //设置页脚 <BR>{ <BR>$this->SetY(-15); <BR>$this->SetFont('G<i style="color:transparent">本文来源gaodai$ma#com搞$$代**码)网8</i><strong>搞代gaodaima码</strong>B','',10); <BR>$this->Cell(0,10,'第'.$this->PageNo().'页'); <BR>} <BR>} <br><br>$conn = mysql_connect("localhost", "root", ""); //连接数据库 <br><br>mysql_select_db("product", $conn); //执行SQL <BR>$query_rs_prod = "SELECT * FROM product ORDER BY prod_id"; <BR>$rs_prod = mysql_query($query_rs_prod, $conn) or die(mysql_error()); <BR>$row_rs_prod = mysql_fetch_assoc($rs_prod); <BR>$totalRows_rs_prod = mysql_num_rows($rs_prod); <br><br>$pdf=new PDF(); //创建新的FPDF对象 <BR>$pdf->AddGBFont(); //设置中文字体 <BR>$pdf->Open(); //开始创建PDF <BR>$pdf->AddPage(); //增加一页 <br><br>$pdf->SetFont('GB','',10); //设置字体样式 <br><br>$header=array('产品编号','产品名称','产品类型','产品单价'); //设置表头 <BR>$width=array(20,80,40,20); //设置每列宽度 <br><br>for($i=0;$i<count($header);$i++) //循环输出表头 <BR>$pdf->Cell($width[$i],6,$header[$i],1); <BR>$pdf->Ln(); <br><br>do //循环输出表体 <BR>{ <BR>$pdf->Cell($width[0],6,$row_rs_prod['prod_id'],1); <BR>$pdf->Cell($width[1],6,$row_rs_prod['prod_name'],1); <BR>$pdf->Cell($width[2],6,$row_rs_prod['prod_type'],1); <BR>$pdf->Cell($width[3],6,$row_rs_prod['prod_price'],1); <BR>$pdf->Ln(); <BR>} while ($row_rs_prod = mysql_fetch_assoc($rs_prod)); <br><br>$pdf->Output("product.pdf", true); //下载PDF文件 <BR>?> <BR>
<?php <BR>define('FPDF_FONTPATH','font/'); //定义font文件夹所在路径 <BR>require_once('fpdf/fpdf.php'); //包含fpdf类库文件 <BR>$pdf=new FPDF('P', 'mm', 'A4'); //创建新的FPDF对象,竖向放纸,单位为毫米,纸张大小A4 <BR>$pdf->Open(); //开始创建PDF <BR>$pdf->AddPage(); //增加一页 <BR>$pdf->SetFont('Courier','I',20); //设置字体样式 <BR>$pdf->Cell(0,0,'Hello World!'); //增加一个单元格 <BR>$pdf->Output(); //输出PDF到浏览器 <BR>?><BR>
<?php <BR>define('FPDF_FONTPATH','font/'); //定义font文件夹所在路径 <BR>require_once('fpdf/fpdf.php'); //包含fpdf类库文件 <BR>$pdf=new FPDF('P', 'mm', 'A4'); //创建新的FPDF对象,竖向放纸,单位为毫米,纸张大小A4 <BR>$pdf->Open(); //开始创建PDF <BR>$pdf->AddPage(); //增加一页 <BR>$pdf->SetFont('Courier','I',20); //设置字体样式 <BR>$pdf->Image('sight.jpg',20,20,0,0); //增加一张图片,文件名为sight.jpg <BR>$pdf->Output(); //输出PDF到浏览器 <BR>?><BR>
<?php <BR>define('FPDF_FONTPATH','font/'); //定义font文件夹所在路径 <BR>require_once('fpdf/fpdf.php'); //包含fpdf类库文件 <BR>$pdf=new FPDF(‘P', ‘mm', ‘A4'); //创建新的FPDF对象,竖向放纸,单位为毫米,纸张大小A4 <BR>$pdf->Open(); //开始创建PDF <BR>$pdf->AddPage(); //增加一页 <BR>$pdf->SetFont('Courier','I',20); //设置字体样式 <BR>$pdf->Cell(60,10,'Hello World!',1); //增加一个单元格 边框为1 <BR>$pdf->Output(); //输出PDF到浏览器 <BR>?><BR>
<?php <BR>define('FPDF_FONTPATH','font/'); //定义font文件夹所在路径 <BR>require_once('fpdf/fpdf.php'); //包含fpdf类库文件 <BR>$pdf=new FPDF('P', 'mm', 'A4'); //创建新的FPDF对象,竖向放纸,单位为毫米,纸张大小A4 <BR>$pdf->Open(); //开始创建PDF <BR>$pdf->AddPage(); //增加一页 <br><br>$pdf->SetFont('Arial','',14); //设置字体样式 <br><br>$header=array('Name','Age','Sex','Salary'); //设置表头 <BR>$data=array(); //设置表体 <BR>$data[0] = array('Simon','24','Male','5,000.00'); <BR>$data[1] = array('Elaine','25','Female','6,000.00'); <BR>$data[2] = array('Susan','25','Female','7,000.00'); <BR>$data[3] = array('David','26','Male','8,000.00'); <br><br>$width=array(40,40,40,40); //设置每列宽度 <br><br>for($i=0;$i<count($header);$i++) //循环输出表头 <BR>$pdf->Cell($width[$i],6,$header[$i],1); <BR>$pdf->Ln(); <br><br>foreach($data as $row) //循环输出表体 <BR>{ <BR>$pdf->Cell($width[0],6,$row[0],1); <BR>$pdf->Cell($width[1],6,$row[1],1); <BR>$pdf->Cell($width[2],6,$row[2],1); <BR>$pdf->Cell($width[3],6,$row[3],1); <BR>$pdf->Ln(); <BR>} <br><br>$pdf->Output(); //输出PDF到浏览器 <BR>?> <BR>
<?php <BR>define('FPDF_FONTPATH','font/'); //定义font文件夹所在路径 <BR>require_once('fpdf/fpdf.php'); //包含fpdf类库文件 <BR>$pdf=new FPDF('P', 'mm', 'A4'); //创建新的FPDF对象,竖向放纸,单位为毫米,纸张大小A4 <BR>$pdf->Open(); //开始创建PDF <BR>$pdf->AddPage(); //增加一页 <BR>$pdf->SetFont('Courier','I',20); //设置字体样式 <BR>$pdf->Cell(0,0,'你好,FPDF'); //增加一个单元格并输出中文 <BR>$pdf->Output(); //输出PDF到浏览器 <BR>?> <BR>
<?php <BR>require('chinese.php'); <BR>class PDF extends PDF_Chinese <BR>{ <BR>function Header() //设定页眉 <BR>{ <BR>$this->SetFont('GB','',10); <BR>$this->Write(10,'FPDF中文测试'); <BR>$this->Ln(20); <BR>} <br><br>function Footer() //设定页脚 <BR>{ <BR>$this->SetY(-15); <BR>$this->SetFont('GB','',10); <BR>$this->Cell(0,10,'第'.$this->PageNo().'页'); <BR>} <BR>} <br><br>$pdf=new PDF(); //创建PDF文档 <BR>$pdf->AddGBFont(); <BR>$pdf->Open(); <BR>$pdf->AliasNbPages(); <BR>$pdf->AddPage(); <BR>$pdf->SetFont('GB','I',20); <BR>$pdf->Cell(0,10,'你好,FPDF'); //输出一段中文 <BR>$pdf->Output(); <BR>?> <BR>
<?php
$conn = mysql_connect("localhost", "root", ""); //连接数据库
$colname_rs_article = $_GET['id']; //获取参数idmysql_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);function conv($Text) //对返回文本进行处理
{
$Text=htmlspecialchars($Text); //转换HTML关键字符
$Text=nl2br($Text); //转换换行符
return $Text;
}
?><?php echo $row_rs_article['title']; ?>
<?php echo $row_rs_article['author']; ?> | ">下载PDF文档