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
|
$requete = "SELECT mail,nom,adresse,cp,ville,tph FROM user WHERE lvl=1 ORDER BY nom ASC";
$sql = mysql_query($requete);
if(mysql_num_rows($sql) > 0)
{
$i = 0;
while($Row = mysql_fetch_assoc($sql))
{
$i++;
if($i == 1)
{
$outputCsv = "Mail;Nom;Adresse;Code_Postal;Ville;Telephone";
$outputCsv .= "\n";
}
foreach($Row as $clef => $valeur)
$outputCsv .= trim(utf8_decode($valeur=str_replace(array(''',"\n","<br />"),array('\''," "," "),$valeur))).';';
// Suppression du ; qui traine à la fin
$outputCsv = rtrim($outputCsv, ';');
// Saut de ligne
$outputCsv .= "\n";
} |
Partager