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
| $Fnm = $v_extractdvd."fichier.sql";
$inF = fopen($Fnm,"w");
$req1 = mysql_query("premiere requete");
$res1 = array();
while ($data = mysql_fetch_assoc($req1)) {
$res1[] = $data;
}
$req2 = mysql_query("seconde requete");
$res2 = array();
while ($data = mysql_fetch_assoc($req2)) {
$res2[] = $data;
}
res1 = array_chunk($res1, 5);
foreach($res1 as $set) {
foreach($set as $data) {
$reg = ereg_replace("\r\n","<br>", $data);
fwrite($inF, $reg."|");
fwrite($inF, "\r\n");
}
$reg = ereg_replace("\r\n","<br>", $res2);
fwrite($inF, $reg."|");
fwrite($inF, "\r\n");
} |
Partager