1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
| <?php
require('fpdf.php');
// connexion base de données
$db_server = "localhost";
$db_user = "root";
$db_pass = "password";
$db_name = "mabase";
function connect($db_server, $db_user, $db_pass, $db) {
if (!($link=mysql_connect($db_server,$db_user,$db_pass))) {
exit();
}
if (!(mysql_select_db($db,$link))) {
exit();
}
return $link;
}
$connexion=connect($db_server,$db_user,$db_pass,$db_name);
//Create new pdf file
$pdf=new FPDF();
//Disable automatic page break
$pdf->SetAutoPageBreak(false);
//Add first page
$pdf->AddPage();
//set initial y axis position per page
$y_axis_initial = 25;
//print column titles
$pdf->SetFillColor(232,232,232);
$pdf->SetFont('Arial','B',12);
$pdf->SetY($y_axis_initial);
$pdf->SetX(25);
$pdf->Cell(30,6,'ID',1,0,"L",1);
$pdf->Cell(50,6,'CODE',1,0,"L",1);
$pdf->Cell(50,6,'NOM',1,0,"R",1);
$y_axis = $y_axis + $row_height;
//Select the Products you want to show in your PDF file
$result=mysql_query('SELECT UniteID,CodeUnite,Nom FROM Unites',$link);
//initialize counter
$i = 0;
//Set maximum rows per page
$max = 25;
//Set Row Height
$row_height = 6;
while($row = mysql_fetch_array($result))
{
$code = $row['UniteID'];
$name = $row['Nom'];
$price = $row['CodeUnite'];
$pdf->SetY($y_axis);
$pdf->SetX(25);
$pdf->Cell(30,6,$code,1,0,"L",1);
$pdf->Cell(50,6,$name,1,0,"L",1);
$pdf->Cell(50,6,$price,1,0,"R",1);
}
mysql_close($link);
//Send file
$pdf->Output();
?> |
