01.<?php
02. include ("call/connectDB.php");
03.
04. function showPDF($type)
05. {
06. $output = '';
07. $strSQL = 'SELECT customer_name, course_name, booking_date, booking_time
08. FROM booking
09.
10. INNER JOIN customer
11. ON booking.customer_id = customer.customer_id
12.
13. INNER JOIN course
14. ON booking.course_id = course.course_id';
15.
16. $objQuery = mysql_query($strSQL)or die(mysql_error());
17. global $strSQL;
18. $i=0;
19. $a=0;
20. while($objResult = mysql_fetch_array($objQuery)){
21. $i++;
22. $a++;
23. if($i%2==0)
24. {
25. $bg = "#F5F5F5";
26. }
27. else
28. {
29. $bg = "#FFFFFF";
30. }
31. $output .='
32. <tr bgcolor="'.$bg.'" >
33. <td width="7%"><div align="center">'.$a.'</div></td>
34. <td width="8%"><div align="left">'.$objResult['customer_name'].'</div></td>
35. <td width="13%"><div align="left">'.$objResult['course_name'].'</div></td>
36. <td width="13%"><div align="left">'.$objResult['booking_date'].'</div></td>
37. <td width="22%"><div align="left">'.$objResult['booking_time'].'</div></td>
38. </tr>
39. ';
40. }
41. return $output;
42. }
43.
44. if(isset($_POST["create_pdf"]))
45. {
46. require_once('tcpdf/tcpdf.php');
47. require_once('call/pdfP.php');
48. $obj_pdf->SetTitle("รายงานรายชื่อลูกค้า");
49.
50. $content .= '
51. <table border="1" cellpadding="3" cellspacing="0" width="100%">
52. <thead>
53. <tr bgcolor="#D3D3D3" color="Black">
54. <th width="7%"><div align="center"><B>Customer name</B></div></th>
55. <th width="8%"><div align="left"><B>Course name</B></div></th>
56. <th width="13%"><div align="left"><B>Booking date</B></div></th>
57. <th width="13%"><div align="left"><B>Booking time</B></div></th>
58. </tr>
59. </thead>
60. ';
61. $content .= showPDF('pdf');
62. $content .= '</table>';
63. $content .= $_SESSION['ss_set_pdf'] ;
64. $obj_pdf->writeHTML($content);
65. ob_end_clean();
66. $obj_pdf->Output('vender.pdf', 'I');
67. }
