retour ...

'; if(!empty($_POST) ) { $_SESSION['sauvegarde_formulaire'] = $_POST ; $page_actuelle = $_SERVER['PHP_SELF'] ; if(!empty($_SERVER['QUERY_STRING'])) { $page_actuelle .= '?' . $_SERVER['QUERY_STRING'] ; } header('Location: ' . $page_actuelle); exit; } if(isset($_SESSION['sauvegarde_formulaire'])) { $_POST = $_SESSION['sauvegarde_formulaire'] ; unset($_SESSION['sauvegarde_formulaire']); } function DB_to_file($filename) { // sauvegarde du classement dans un fichier //$sql = "SELECT * FROM parties ORDER by date asc"; $sql = "SELECT * FROM " .$_SESSION['parties'] ." ORDER by date asc"; $results = mysql_query($sql); $nb_parties = mysql_num_rows($results); while($row = mysql_fetch_assoc($results)) { $blanc = $row['w_name']; $noir = $row['b_name']; $date = $row['date']; $resultat = $row['result']; $date_partie = date('d/m/Y', $date); if($resultat == 1) { $_score_blanc = 1; $_score_noir = 0; } if($resultat == 2) { $_score_blanc = 0; $_score_noir = 1; } if($resultat == 3) { $_score_blanc = 0.5; $_score_noir = 0.5; } $table_csv[0] = $date_partie; $table_csv[1] = $blanc; $table_csv[2] = $noir; $table_csv[3] = $_score_blanc; $table_csv[4] = $_score_noir; $table_fichier[] = $table_csv; } // if (!is_dir('path/to/directory')) { // mkdir('path/to/directory', 0777, true); // } $nom_fichier = $filename; chdir("backup"); $fp = fopen($nom_fichier, 'w'); for ($i=0; $i < $nb_parties; $i++) { $str_comma_separated = implode(";", $table_fichier[$i]); fputs ($fp, $str_comma_separated); if($i != $nb_parties - 1) fputs($fp, "\n"); } fclose($fp); } ?> Edition de la database Liste des parties (format csv)'; ?>