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 75 76
|
<?php
include("../variables.inc.php");
// connection à la base
$liendb = mysql_connect($bddserver, $bddlogin, $bddpassword);
mysql_select_db ($bdd);
$query="select * from elevescomplete where `Code Structure`<>' ' order by `Code Structure`";
$resultat=mysql_query($query);
// fin de connection à la base
require('../fpdf.php');
$pdf=new FPDF('P','cm','A4');
ob_start();
$pdf->SetFont('arial','B',8);
//$pdf->AddPage();
$pdf->SetFillColor(255,255,255);
$pdf->SetTextColor(0,0,0);
header ('Content-type: text/html; charset=utf-8');
$fond=0;
// DEBUT affichage cordonnées élève
while($row=mysql_fetch_array($resultat))
{ $pdf->AddPage();
$pdf->SetXY(1,26);
$pdf->write(1,$row['foot']);
$pdf->SetXY(1,1);
$pdf->write(1,utf8_decode('ELEVE:'));;
$pdf->SetXY(4,1);
$pdf->write(1,$row['Nom']);
$pdf->SetXY(6,1);
$pdf->write(1,$row['Prénom']);
$pdf->SetXY(8,1);
$pdf->write(1,$row['Code Structure']);
$pdf->SetXY(10,1);
$pdf->write(1,$row['Eléve No Etab']);
$id1=$row['Eléve No Etab'];
$pdf->SetXY(16,1);
$pdf->write(1,$id1);
$fond=!$fond;
// Début affichage retenues
$pdf->SetFont('arial','BU',14);
$pdf->SetXY(1,2);
$pdf->write(1,utf8_decode ('Retenue(s) disciplinaire(s):'));;
$pdf->SetFont('arial','B',8);
$query2="select * from retenues where elenoet='$id1'";
$resultat2=mysql_query($query2);
while($row=mysql_fetch_array($resultat2))
{
$pdf->SetXY(1,3);
$pdf->write(1,$row['Quand1']);
$pdf->SetXY(3,3);
$pdf->write(1,$row['Adulte:']);
$pdf->SetXY(5,3);
$pdf->write(1,$row['Qui']);
}
// FIN affichage retenues
}
// FIN affichage cordonnées élève
$pdf->output();
?> |
Partager