7-8
pdf_all.php
include_once "header.php" ; |
require_once (TADTOOLS_PATH. '/tcpdf/tcpdf.php' ); |
$pdf = new TCPDF( "P" , "mm" , "A4" ); |
$pdf ->setPrintHeader(false); |
$pdf ->setPrintFooter(false); |
$pdf ->setFontSubsetting(true); |
$pdf ->SetMargins(15, 15); |
$pdf ->SetFont( 'droidsansfallback' , '' , 24, '' , true); |
$pdf ->Cell(180, 12, '巷談集文章列表' , 0, 1, 'C' , 0); |
$myts = MyTextSanitizer::getInstance(); |
$tbl = $xoopsDB ->prefix( 'snews' ); |
$sql = "SELECT * FROM `$tbl` ORDER BY create_time DESC" ; |
$result = $xoopsDB ->query( $sql ) or web_error( $sql ); |
$pdf ->SetFont( 'droidsansfallback' , '' , 12, '' , true); |
while ( $snews = $xoopsDB ->fetchArray( $result )){ |
$title = $myts ->htmlSpecialChars( $snews [ 'title' ]); |
$username = $myts ->htmlSpecialChars( $snews [ 'username' ]); |
$pdf ->MultiCell( 130, $height , $title , 1, 'L' , false, 0, '' , '' , false, 0, false, false, $height , 'M' , true); |
$pdf ->MultiCell( 28, $height , $username , 1, 'C' , false, 0, '' , '' , false, 0, false, false, $height , 'M' , true); |
$pdf ->MultiCell( 22, $height , $snews [ 'update_time' ], 1, 'C' , false, 1, '' , '' , false, 0, false, false, $height , 'M' , true); |
$pdf ->Image( 'images/aa.png' , 180, 250, 20, 20, 'png' ); |
$pdf ->SetFont( 'droidsansfallback' , '' , 16, '' , true); |
$pdf ->Cell(20, 10, '簽名:' , 0, 0); |
$pdf ->Cell(50, 10, '' , 'B' , 0, 0); |
$pdf ->Output( 'snews.pdf' , 'I' ); |