如何使用PHP作出PDF表@新竹站架|PChome Online 人新台
2023-01-06 03:37:45| 人17| 回0

如何使用PHP作出PDF表

0 收藏 0 0 站台

真的是一超方便的工具喔 ^ ^~~



 

首先可以到FPDF站下程式,固然FPDF的站有教授教也值得前往看http://www.fpdf.org/

 

或直接下fpdf16.zip

因FPDF的站是英文的,是以若要利用中文字,

接下器看的成以下:

 

  1. <?php  session_start();
  2.  
  3. mysql_select_db($database, $test);
  4.  
  5. //index(首)
  6. $query_index = "SELECT * FROM `flow` WHERE date = CURDATE( ) AND page = 'index'";
  7. $index = mysql_query($query_index, $test) or die(mysql_error());
  8. $totalRows_index = mysql_num_rows($index);
  9. $query_index2 = "SELECT * FROM `flow` WHERE page = 'index'";
  10. $index2 = mysql_query($query_index2, $test) or die(mysql_error());
  11. $totalRows_index2 = mysql_num_rows($index2);
  12.  
  13. //introduce(品牌介)
  14. $query_introduce = "SELECT * FROM `flow` WHERE date = CURDATE( ) AND page = 'introduce'";
  15. $introduce = mysql_query($query_introduce, $test) or die(mysql_error());
  16. $totalRows_introduce = mysql_num_rows($introduce);
  17. $query_introduce2 = "SELECT * FROM `flow` WHERE page = 'introduce'";
  18. $introduce2 = mysql_query($query_introduce2, $test) or die(mysql_error());
  19. $totalRows_introduce2 = mysql_num_rows($introduce2);
  20.  
  21. //......................(其面法同上)
  22.  
  23. ?>
  24.  

test.php

reportSQL.php

 

report.php

1.png

  1. <?php
  2. $hostname = "localhost";   //主名
  3. $database = "test";              //料名
  4. $username = "xxxx";            //料使用者
  5. $password = "****";            //料利用者暗
  6.  
  7. $test = mysql_pconnect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);
  8. mysql_select_db("test",$test);
  9. mysql_query("set names 'utf8'");
  10.  
  11. ?>
  12.  
  1. <?php
  2. require('chinese-unicode.php');            //入下的中文化的FPDF
  3. require_once('../Connections/test.php');   //入保持料的法
  4. require_once('../require/reportSQL.php');  //入表的SQL法
  5. $pdf=new PDF_Unicode();                    //立PDF_Unicode
  6. $pdf->Open();                              //
  7. $pdf->AddPage();                           //新的一
  8. $pdf->AddUniCNShwFont('uni');              //加入中文
  9. $pdf->SetFont('uni','',16);                //定字型字巨
  10. //接著料放入一列中
  11. $row0=array('面','本日人流量(人)','人流量(人)');
  12. $row1=array('首',$totalRows_index,$totalRows_index2);
  13. $row2=array('品牌介',$totalRows_introduce,$totalRows_introduce2);
  14. $row3=array('理念',$totalRows_manage,$totalRows_manage2);
  15. $row4=array('署理品牌',$totalRows_agent,$totalRows_agent2);
  16. $row5=array('品',$totalRows_product,$totalRows_product2);
  17. $row6=array('通知告',$totalRows_publish,$totalRows_publish2);
  18. $row7=array('新',$totalRows_activities,$totalRows_activities2);
  19. $row8=array('素材介',$totalRows_material,$totalRows_material2);
  20. $row9=array('',$totalRows_place,$totalRows_place2);
  21. $row10=array('系我',$totalRows_contact,$totalRows_contact2);
  22.  
  23. //本日人流量
  24. $today=$totalRows_index+$totalRows_introduce+$totalRows_manage+$totalRows_agent+$totalRows_product+$totalRows_publish+$totalRows_activities+$totalRows_material+$totalRows_place+$totalRows_contact;
  25. $total=$totalRows_index2+$totalRows_introduce2+$totalRows_manage2+$totalRows_agent2+$totalRows_product2+$totalRows_publish2+$totalRows_activities2+$totalRows_material2+$totalRows_place2+$totalRows_contact2;
  26. $row11=array('',$today,$total);
  27. //再料放入2列中
  28. $trow=array($row0,$row1,$row2,$row3,$row4,$row5,$row6,$row7,$row8,$row9,$row10,$row11);
  29.  
  30. //定表格的度
  31. $w=array(60,65,60);
  32.  
  33. //圈
  34. for($j=0;$j<count($trow);$j++){
  35.   for($i=0;$i<count($trow[$j]);$i++){
  36.    $pdf->Cell($w[$i],7,$trow[$j][$i],1,0,'C');     //料放入表格
  37.   } $pdf->Ln();                                    //下一列
  38. }
  39. $pdf->Output();                                   //出出
  40. ?>
  41.  



 

好啦,上面的案下之後解放入站的料就能始



 

  1.  
  2. // Set font
  3. $pdf->SetFont('Arial','B',16);
  4. // Move to 8 cm to the right
  5. $pdf->Cell(80);
  6. // Centered text in a framed 20*10 mm cell and line break
  7. $pdf->Cell(20,10,'Title',1,1,'C');

需要再下chinese-unicode.rar


Cell(float w [, float h [, string txt [, mixed border [, int ln [, string align [, boolean fill [, mixed link]]]]]]])

w
Cell width. If 0, the cell extends up to the right margin.
h
Cell height. Default value: 0.
txt
String to print. Default value: empty string.
border
Indicates if borders must be drawn around the cell. The value can be either a number:
0: no border
1: frame
or a string containing some or all of the following characters (in any order):
L: left
T: top
R: right
B: bottom
Default value: 0.
ln
Indicates where the current position should go after the call. Possible values are:
0: to the right
1: to the beginning of the next line
2: below
Putting 1 is equivalent to putting 0 and calling Ln() just after. Default value: 0.
align
Allows to center or align the text. Possible values are:
L or empty string: left align (default value)
C: center
R: right align
fill
Indicates if the cell background must be painted (true) or transparent (false). Default value: false.
link
URL or identifier returned by AddLink().
Example



自: 站架

台: palmerbgqj
人(17) | 回(0)| 推 (0)| 收藏 (0)|
全站分: 社象(事、政、公益、八卦、社、宗教、超自然) | 人分: NetYea |

是 (若未登入"人新台"看不到回覆唷!)
* 入:
入片中算式的果(可能0) 
(有*必填)
TOP
全文
ubao msn snddm index pchome yahoo rakuten mypaper meadowduck bidyahoo youbao zxmzxm asda bnvcg cvbfg dfscv mmhjk xxddc yybgb zznbn ccubao uaitu acv GXCV ET GDG YH FG BCVB FJFH CBRE CBC GDG ET54 WRWR RWER WREW WRWER RWER SDG EW SF DSFSF fbbs ubao fhd dfg ewr dg df ewwr ewwr et ruyut utut dfg fgd gdfgt etg dfgt dfgd ert4 gd fgg wr 235 wer3 we vsdf sdf gdf ert xcv sdf rwer hfd dfg cvb rwf afb dfh jgh bmn lgh rty gfds cxv xcv xcs vdas fdf fgd cv sdf tert sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf shasha9178 shasha9178 shasha9178 shasha9178 shasha9178 liflif2 liflif2 liflif2 liflif2 liflif2 liblib3 liblib3 liblib3 liblib3 liblib3 zhazha444 zhazha444 zhazha444 zhazha444 zhazha444 dende5 dende denden denden2 denden21 fenfen9 fenf619 fen619 fenfe9 fe619 sdf sdf sdf sdf sdf zhazh90 zhazh0 zhaa50 zha90 zh590 zho zhoz zhozh zhozho zhozho2 lislis lls95 lili95 lils5 liss9 sdf0ty987 sdft876 sdft9876 sdf09876 sd0t9876 sdf0ty98 sdf0976 sdf0ty986 sdf0ty96 sdf0t76 sdf0876 df0ty98 sf0t876 sd0ty76 sdy76 sdf76 sdf0t76 sdf0ty9 sdf0ty98 sdf0ty987 sdf0ty98 sdf6676 sdf876 sd876 sd876 sdf6 sdf6 sdf9876 sdf0t sdf06 sdf0ty9776 sdf0ty9776 sdf0ty76 sdf8876 sdf0t sd6 sdf06 s688876 sd688 sdf86