Help my FPDF

Fermé
mike68h Messages postés 13 Date d'inscription vendredi 5 décembre 2008 Statut Membre Dernière intervention 21 août 2009 - 5 mars 2009 à 13:26
Bonjour,

Voila mon souci j'ai un fichier pdf qui m'affiche mes factures mon probleme c'est que les lignes des produits ce son superpose pouvez vous me dire comment faire pour les affiches les un apres les autres. voila le code:

<?php
define('FPDF_FONTPATH','font/');
require('invoice.php');

$pdf = new INVOICE( 'P', 'mm', 'A4' );
$pdf->Open();
$pdf->AddPage();

//Logo
$pdf->Image('images/logo.jpg',70,8,33);


require("conf.php");
$nom_client = $_GET['nom_client'];
$connection = mysql_connect("$sql_serveur","$sql_login","$sql_pass");
// test la connection
if ( ! $connection ) die ("connection impossible");
// Connecte la base
mysql_select_db($sql_bdd) or die ("pas de connection");
$sql="Select* from entreprise, client where nom_client='$nom_client'";
$req=mysql_query($sql,$connection)or exit ('Erreur SQL !'.$sql.'<br>'.mysql_error());


while( $data=mysql_fetch_array($req) ) {
$pdf->addSociete( "".$data['nom']."",
"".$data['nrue']." ".$data['typerue']." ".$data['adres']."\n" .
"".$data['codep']." ".$data['ville']."\n".
"R.C.S. ".$data['greffe']." ".$data['siren']."\n" .
"Capital : ".$data['capital']." " . EURO );

$pdf->addNumTVA("".$data['tva']."");
$pdf->addClientAdresse("Ste ".$data['soc_client']."\nM. ".$data['nom_client']." ".$data['prenom']."\n".$data['adres_client']."\n".$data['postal_client']." ".$data['ville_client']."");
}

$cmd = $_GET['cmd'];
$nom_client = $_GET['nom_client'];
$connection = mysql_connect("$sql_serveur","$sql_login","$sql_pass");
// test la connection
if ( ! $connection ) die ("connection impossible");
// Connecte la base
mysql_select_db($sql_bdd) or die ("pas de connection");

// RECHERCHE SI ON A LA FAMILLE DANS STAT SINON ON AFFICHE 0
$found=mysql_query("SELECT nom_client FROM commande")
or die(mysql_error());
$nb1=mysql_numrows($found);
if($nb1<>"0"){$erreur='Y';}else{$erreur='N';}

if($erreur=='Y')
{

$select = "SELECT * FROM commande WHERE cmd='$cmd'";
$result = mysql_query($select,$connection) or die ('Erreur : '.mysql_error() );
while($row = mysql_fetch_array($result))
{
$rowcmd = $row['type_cmd'];
$rownom = $row['nom_client'];
$rowpaye = $row['paiement'];

}
if($erreur=='N')
{
}
}

$pdf->fact_dev( "".$rowcmd." ", "" );
$pdf->temporaire( "".$rowcmd."" );
$pdf->addDate( "03/12/2003");
$pdf->addClient("".$rownom."");
$pdf->addPageNumber("");
$pdf->addReglement("".$rowpaye."");
$pdf->addEcheance("03/12/2003");

$pdf->addReference("Devis ... du ....");
$cols=array( "REFERENCE" => 23,
"DESIGNATION" => 78,
"QUANTITE" => 22,
"P.U. HT" => 26,
"MONTANT H.T." => 30,
"TVA" => 11 );
$pdf->addCols( $cols);
$cols=array( "REFERENCE" => "L",
"DESIGNATION" => "L",
"QUANTITE" => "C",
"P.U. HT" => "R",
"MONTANT H.T." => "R",
"TVA" => "C" );
$pdf->addLineFormat( $cols);
$pdf->addLineFormat($cols);

$cmd = $_GET['cmd'];
$nom_client = $_GET['nom_client'];
$connection = mysql_connect("$sql_serveur","$sql_login","$sql_pass");
// test la connection
if ( ! $connection ) die ("connection impossible");
// Connecte la base
mysql_select_db($sql_bdd) or die ("pas de connection");

$select = "SELECT * FROM commande WHERE cmd='$cmd' AND nom_client='$nom_client'";
$result = mysql_query($select,$connection) or die ('Erreur : '.mysql_error() );
while($row = mysql_fetch_array($result))
{
$rowid1 = $row['id'];
$rowid = $row['nom'];
$rowprix = $row['prix'];
$rowday = $row['cde'];
$rowpx = $row['pxligne'];


$y = 109;
$line = array ( "REFERENCE" => "".$rowid1."",
"DESIGNATION" => "".$rowid."",
"QUANTITE" => "".$rowday."",
"P.U. HT" => "".$rowprix."",
"MONTANT H.T." => "".$rowpx."",
"TVA" => "1");



$size = $pdf->addLine($y, $line);
$y+= $size + 3;

}
{
}


//Instanciation de la classe dérivée

$pdf->AliasNbPages();
$pdf->SetFont('Times','',12);
$pdf->Output();
?>