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
|
<?php
session_start(); # 7
include("taz.inc"); #14
$cxn = mysql_connect($host, $user, $passwd)
or die ("Couldn't connect to server.");
mysql_set_charset('utf8',$cxn);
$db_selected = mysql_select_db($dbname, $cxn);
if (!$db_selected) {
die ('Impossible de sélectionner la base de données : ' . mysql_error());
} #16
//requête SQL:
$sql = "SELECT *
FROM Produit
ORDER BY Reference" ;
//exécution de la requête:
$requete = mysql_query( $sql, $cxn ) ;
while($res = mysql_fetch_array($requete)) {
$content.=
"Nom : ".$res['Reference']." ";
}
require('fpdf.php');
$pdf=new FPDF();
$pdf->AddPage();
$pdf->SetFont('Arial','B',16);
$arr = array(1, 2, 3, 4);
while($resultat = mysql_fetch_assoc($requete))
{
pdf->BasicTable($header,$resultat,$entete);
$entete=1;
}
$pdf->Output();
?> |
Partager