001.<html>
002.<head>
003.<title>ThaiCreate.Com PHP PDF</title>
004.</head>
005.<body>
006.
007.<?php
008.require('fpdf.php');
009.
010.class PDF extends FPDF
011.{
012.
013.function LoadData($file)
014.{
015.
016. $lines=file($file);
017. $data=array();
018. foreach($lines as $line)
019. $data[]=explode(';',chop($line));
020. return $data;
021.}
022.
023.
024.function BasicTable($header,$data)
025.{
026.
027. $w=array(30,30,55,25,20,20);
028.
029. for($i=0;$i<count($header);$i++)
030. $this->Cell($w[$i],7,$header[$i],1,0,'C');
031. $this->Ln();
032.
033. foreach ($data as $eachResult)
034. {
035. $this->Cell(30,6,$eachResult["CustomerID"],1);
036. $this->Cell(30,6,$eachResult["Name"],1);
037. $this->Cell(55,6,$eachResult["Email"],1);
038. $this->Cell(25,6,$eachResult["CountryCode"],1,0,'C');
039. $this->Cell(20,6,$eachResult["Budget"],1);
040. $this->Cell(20,6,$eachResult["Budget"],1);
041. $this->Ln();
042. }
043.}
044.
045.
046.function ImprovedTable($header,$data)
047.{
048.
049. $w=array(20,30,55,25,25,25);
050.
051. for($i=0;$i<count($header);$i++)
052. $this->Cell($w[$i],7,$header[$i],1,0,'C');
053. $this->Ln();
054.
055.
056. foreach ($data as $eachResult)
057. {
058. $this->Cell(20,6,$eachResult["CustomerID"],1);
059. $this->Cell(30,6,$eachResult["Name"],1);
060. $this->Cell(55,6,$eachResult["Email"],1);
061. $this->Cell(25,6,$eachResult["CountryCode"],1,0,'C');
062. $this->Cell(25,6,number_format($eachResult["Budget"],2),1,0,'R');
063. $this->Cell(25,6,number_format($eachResult["Budget"],2),1,0,'R');
064. $this->Ln();
065. }
066.
067. $this->Cell(array_sum($w),0,'','T');
068.}
069.
070.
071.function FancyTable($header,$data)
072.{
073.
074. $this->SetFillColor(255,0,0);
075. $this->SetTextColor(255);
076. $this->SetDrawColor(128,0,0);
077. $this->SetLineWidth(.3);
078. $this->SetFont('','B');
079.
080. $w=array(20,30,55,25,25,25);
081. for($i=0;$i<count($header);$i++)
082. $this->Cell($w[$i],7,$header[$i],1,0,'C',true);
083. $this->Ln();
084.
085. $this->SetFillColor(224,235,255);
086. $this->SetTextColor(0);
087. $this->SetFont('');
088.
089. $fill=false;
090. foreach($data as $row)
091. {
092. $this->Cell($w[0],6,$row[0],'LR',0,'L',$fill);
093. $this->Cell($w[1],6,$row[1],'LR',0,'L',$fill);
094. $this->Cell($w[2],6,$row[2],'LR',0,'L',$fill);
095. $this->Cell($w[3],6,$row[3],'LR',0,'C',$fill);
096. $this->Cell($w[4],6,number_format($row[4]),'LR',0,'R',$fill);
097. $this->Cell($w[5],6,number_format($row[5]),'LR',0,'R',$fill);
098. $this->Ln();
099. $fill=!$fill;
100. }
101. $this->Cell(array_sum($w),0,'','T');
102.}
103.}
104.
105.$pdf=new PDF();
106.
107.$header=array('CustomerID','Name','Email','Country Code','Budget','Used');
108.
109.
110.
111.$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
112.$objDB = mysql_select_db("mydatabase");
113.$strSQL = "SELECT * FROM customer";
114.$objQuery = mysql_query($strSQL);
115.$resultData = array();
116.for ($i=0;$i<mysql_num_rows($objQuery);$i++) {
117. $result = mysql_fetch_array($objQuery);
118. array_push($resultData,$result);
119.}
120.
121.
122.
123.
124.$pdf->SetFont('Arial','',10);
125.
126.
127.$pdf->AddPage();
128.$pdf->Image('logo.png',80,8,33);
129.$pdf->Ln(35);
130.$pdf->BasicTable($header,$resultData);
131.
132.
133.$pdf->AddPage();
134.$pdf->Image('logo.png',80,8,33);
135.$pdf->Ln(35);
136.$pdf->ImprovedTable($header,$resultData);
137.
138.
139.$pdf->AddPage();
140.$pdf->Image('logo.png',80,8,33);
141.$pdf->Ln(35);
142.$pdf->FancyTable($header,$resultData);
143.
144.$pdf->Output("MyPDF/MyPDF.pdf","F");
145.
146.
147.
148.
149.$strTo = "member@thaicreate.com";
150.$strSubject = "PDF Report";
151.$strMessage = "Download MyPDF.pdf for PDF Report";
152.
153.
154.$strSid = md5(uniqid(time()));
155.
156.$strHeader = "";
157.$strHeader .= "From: Mr.Weerachai Nukitram<webmaster@thaicreate.com>\nReply-To: webmaster@thaicreate.com\n";
158.$strHeader .= "Cc: Mr.Surachai Sirisart<surachai@thaicreate.com>";
159.$strHeader .= "Bcc: webmaster@thaicreate.com";
160.
161.$strHeader .= "MIME-Version: 1.0\n";
162.$strHeader .= "Content-Type: multipart/mixed; boundary=\"".$strSid."\"\n\n";
163.$strHeader .= "This is a multi-part message in MIME format.\n";
164.
165.$strHeader .= "--".$strSid."\n";
166.$strHeader .= "Content-type: text/html; charset=windows-874\n";
167.$strHeader .= "Content-Transfer-Encoding: 7bit\n\n";
168.$strHeader .= $strMessage."\n\n";
169.
170.$strContent1 = chunk_split(base64_encode(file_get_contents("MyPDF/MyPDF.pdf")));
171.$strHeader .= "--".$strSid."\n";
172.$strHeader .= "Content-Type: application/octet-stream; name=\"MyPDF.pdf\"\n";
173.$strHeader .= "Content-Transfer-Encoding: base64\n";
174.$strHeader .= "Content-Disposition: attachment; filename=\"MyPDF.pdf\"\n\n";
175.$strHeader .= $strContent1."\n\n";
176.
177.
178.$flgSend = @mail($strTo,$strSubject,null,$strHeader);
179.if($flgSend)
180.{
181.echo "PDF Generated & Email Sending.";
182.}
183.else
184.{
185.echo "Email Can Not Send.";
186.}
187.
188.?>
189.</body>
190.</html>
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
