1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| $requete="SELECT * FROM MA_TABLE";
$resultat = OCIParse($conn, $requete);
OCIExecute($resultat);
$CSV="../save/".$_POST['nom_CSV'];
$fh = fopen($CSV,"x+") or die("Le fichier "+$_POST['nom_CSV']+ " existe déjà");
$line = join(";",array('En_tete1','En_tete2'));
$line = "$line\n";
fputs($fh,$line) or die("Error writing line to file<br>DATA: $line");
while(OCIFetch($resultat)){
$ma_variable1 = OCIResult($resultat,"TOTO");
$ma_variable2 = OCIResult($resultat,"TITI");
$line = join(";",array($ma_variable1,$ma_variable2));
$line = "$line\n";
fputs($fh,$line);
}
fclose($fh); |
Partager