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
| <?php
$a=mysql_connect("localhost","root","");
mysql_select_db("gestionpersonnel",$a);
$sep = ",";
$filename = 'fichier/'.strtotime("now").'.csv';
$req = mysql_query("SELECT * FROM employer") or die (mysql_error());
$num_rows = mysql_num_rows($req);
if($num_rows >= 1)
{
$row = mysql_fetch_assoc($req);
$fp = fopen($filename,"w");
$seperator = "";
$comma = "";
foreach($row as $name => $value)
{
$seperator .= $comma . '' .str_replace('','""',$name);
$comma = ",";
}
$seperator .= "\n";
echo $seperator;
fputs($fp,$seperator);
mysql_data_seek($req, 0);
while($row = mysql_fetch_assoc($req))
{
$seperator = "";
$comma = "";
foreach($row as $name => $value)
{
$seperator .= $comma . '' .str_replace('','""',$value);
$comma = ",";
}
$seperator .= "\n";
fputs($fp,$seperator);
}
fclose($fp);
}
else
{
echo 'La base de donnee est vide';
}
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename =' .$filename);
header('Pragma: no-cache');
readfile($filename);
?> |
Partager