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
|
$pdf=new phpToPDF();
$pdf->AddPage();
$pdf->SetFont('Arial','B',16);
try
{
$bdd = new PDO('pgsql:host=localhost;dbname=db', 'user', 'pass');
$bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
$categorie = pg_escape_string($_POST['categorie']);
$reponse = $bdd->query("SELECT * FROM table WHERE categorie1 = '$categorie' ORDER BY nom_rep") or die(print_r($bdd->errorInfo())) ;
// Définition des propriétés du tableau.
$proprietesTableau = array(
'TB_ALIGN' => 'L',
'L_MARGIN' => 15,
'BRD_COLOR' => array(0,92,177),
'BRD_SIZE' => '0.3',
);
$proprieteContenu = array(
'T_COLOR' => array(0,0,0),
'T_SIZE' => 10,
'T_FONT' => 'Arial',
'T_ALIGN_COL0' => 'L',
'T_ALIGN' => 'R',
'V_ALIGN' => 'M',
'T_TYPE' => '',
'LN_SIZE' => 6,
'BG_COLOR_COL0' => array(245, 245, 150),
'BG_COLOR' => array(255,255,255),
'BRD_COLOR' => array(0,92,177),
'BRD_SIZE' => 0.1,
'BRD_TYPE' => '1',
'BRD_TYPE_NEW_PAGE' => '',
);
while ($donnees = $reponse->fetch())
{
$contenuTableau [] = array(
utf8_decode($donnees['nom_rep']),
utf8_decode($donnees['prenom_rep']),
utf8_decode($donnees['tel1']));
}
$pdf->drawTableau($pdf, $proprietesTableau, $proprieteContenu, $contenuTableau );
$pdf->output();
?> |
Partager