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
// Nous donnons un chemin à notre fichier ici
$server="mon serveur";
$username="";
$password="";
$sqlconnect=mssql_connect($server, $username, $password);
$sqldb=mssql_select_db("BYBLOS",$sqlconnect);
$result = mssql_query("SELECT * from byblos.dbo.CLIENT_PARTENARIAT,byblos.dbo.C1_PARTENARIAT2
where byblos.dbo.CLIENT_PARTENARIAT.INDICE = byblos.dbo.C1_PARTENARIAT2.INDICE
and byblos.dbo.C1_PARTENARIAT2.LIB_STATUS LIKE 'RDV'
and byblos.dbo.C1_PARTENARIAT2.DATE like '20080412'");
$nombre = mssql_num_rows($result);
$date = Date("d-m-Y");
$ch1="extract_";
$ch3="_14h";
$nom_fichier=$ch1.$date.$ch3;
require_once 'Spreadsheet/Excel/Writer.php';
$workbook = new Spreadsheet_Excel_Writer();
$workbook->send('test.xls');
$worksheet =& $workbook->addWorksheet('');
$j=$nombre;
$worksheet->write(0,0,'CIVILITE');
$worksheet->write(0,1,'NOM');
$worksheet->write(0,2,'PRENOM');
$worksheet->write(0,3,'ADR1');
$worksheet->write(0,4,'ADR2');
$worksheet->write(0,5,'ADR3');
$i=0;
while( $row = mssql_fetch_array($result))
{
$i=$i+1;
$NOM=$row["NOM"];
$PRENOM=$row["PRENOM"];
$worksheet->write($i,0,$row["CIVILITE"]);
$worksheet->write($i,1,$row["NOM"]);
$worksheet->write($i,2,$row["PRENOM"]);
$worksheet->write($i,3,$row["ADR1"]);
$worksheet->write($i,4,$row["ADR2"]);
$worksheet->write($i,5,$row["ADR3"]);
$worksheet->write
}
$workbook->close();
?> |
Partager