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
|
<?php
require('../fpdf.php');
if ($client=="")
{
$requete="SELECT id_clients FROM table_temp GROUP BY id_clients";
$resultat=mysql_query($requete);
$nombre=mysql_num_rows($resultat);
for($i=0;$i<$nombre;$i++)
{
$id_clients=mysql_result($resultat,$i,"id_clients");
$requete2="SELECT * FROM clients WHERE id_clients=$id_clients";
$resultat2=mysql_query($requete2);
$nombre2=mysql_num_rows($resultat2);
for($j=0;$j<$nombre2;$j++)
{
$email1=mysql_result($resultat2,$j,"email1");
$civilite=mysql_result($resultat2,$j,"civilite");
$nom=mysql_result($resultat2,$j,"nom");
$prenom=mysql_result($resultat2,$j,"prenom");
$adresse=mysql_result($resultat2,$j,"adresse");
$complement=mysql_result($resultat2,$j,"complement");
$cp=mysql_result($resultat2,$j,"cp");
$ville=mysql_result($resultat2,$j,"ville");
$pdf=new FPDF('P','cm','A4');
$pdf->SetFont('times','',10);
$pdf->AddPage();
$pdf->SetXY(1,4);
$pdf->SetFillColor(0xdd,0xdd,0xdd);
$pdf->SetTextColor(0,0,0);
//--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------//
$pdf->SetFont('times','',10);
$pdf->SetXY($pdf->GetX()+12,$pdf->GetY()-0.5);
$pdf->Multicell(7,0.5,utf8_decode($civilite.' '.$nom.' '.$prenom),0,'L',0);
//--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------//
$pdf->SetXY($pdf->GetX()+12,$pdf->GetY()+0);
$pdf->Multicell(7,0.5,utf8_decode($adresse),0,'L',0);
//--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------//
if ($complement!="")
{
$pdf->SetXY($pdf->GetX()+12,$pdf->GetY()+0);
$pdf->Multicell(7,0.5,utf8_decode($complement),0,'L',0);
}
//--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------//
$pdf->SetXY($pdf->GetX()+12,$pdf->GetY()+0);
$pdf->Multicell(7,0.5,utf8_decode($cp." ".$ville),0,'L',0);
//--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------//
$pdf->SetXY($pdf->GetX()+8.9,$pdf->GetY()+0.5);
$pdf->Multicell(7,0.5,"Dunkerque, le ".$date,0,'R',0);
?> |
Partager